skysight-inc/HackerNews huggingface dataset:
Ahh. I guess for SQL you could just pass the queries through, and for NoSQL engines try to convert the AST format.

When I was researching this area, it seems like Apache Calcite is the way to go, and already does this though?

It lets you use standard SQL and has adapters which translate from the abstract query AST to the particular implementation.

https://calcite.apache.org/docs/adapter.html

You can query anything with this, exactly the same way. It's kind of wild I've never heard it talked about tbh.

I went looking for solutions to multi-datastore querying when I fiddled with a business intelligence side project. Pretty useless to only be able to query one type of data, and too time consuming to implement individual mappings.

Apache Calcite and Metabase Query Language (quite the exact usecase there for Metabase, haha) were the only things I could find.
A streaming JSON parser is a parser that emits {"[","]","{","}",string,number,bool,null} without holding anything in memory.

Where do you think it's different from streaming XML (SAX)?
> 4) optional schemas

Perhaps CDDL:

* https://tools.ietf.org/html/rfc8610
Shouldn't...

I know that Minecraft lazily generates the world, so the RNG for an arbitrary location has to be deterministic otherwise you get a mess.

Why isn't the RNG for tiles based on the world seed and the location? That's at least a billion times more search space, still deterministic.
Last time I checked, QLDB is in AWS
Is this not the same type of thinking that’s convinced people who do all sorts of dirty but necessary jobs are “real sickos”? Jobs like homicide/sex crime investigation, fixing the sewers, exterminating pests, and so on. I would probably get PTSD if I had to investigate bleeding anuses digitally but my doctor seems to manage and I doubt she’s a sociopath.

My point is, some people simply aren’t traumatized by photos/videos, either via talent or training, and because of this they can process it enough to categorize it and keep their emotional/social/intellectual distance. That doesn’t make them sociopaths and it certainly doesn’t make them bad people.
Can't you simplify this by making each digit a separate animation, with the ones digit running at full speed, the tens digit running at 1/10th speed, and the hundreds digit running at 1/100th speed? Then you'd only need ten keyframe values.
"Look for things that are hot, but relatively unknown."

What?
That makes sense to me. I've been trying to decide out of Crux or Datahike for a side project. I was leaning towards Datahike because I didn't like the idea of having to do a full document update like you do in Crux, but I need to dig into it a bit more.
One interesting comment I heard is that Tesla is the biggest company NOT in the S&P 500 (I believe that was the index, at least).

So even if Tesla had the exact same retail 'excitement' as, say, Microsoft or Apple or GM, they'd have much wilder fluctuations in stock price because they don't have that massive institutional index fund investment to dampen the swings.
Processing instructions can always be added as a special name value entry, that wouldn't be a good reason to get rid of name value pairs
> All that said, Tesla also doesn’t build and sell cars profitably. Selling credits is the source of their profits.

GAAP gross margin is 21%. They're making excellent profits on their cars.
Radiation therapy for prostate cancer is in fact odd for a patient expected to live to see the side effects. Standard treatment is nothing for a small tumor, surgery for an advanced tumor when the patient has 10+ years of life expectancy, radiation for an advanced tumor when the patient has short life expectancy.
Good, because you grasp the importance of my suggestion.

Emailing me to continue forward is also important. Otherwise you stay in the same place.
I'm pretty sure musk had literally said this is not your theory. that's why there was there patent stunt. It not some plot rather being the change you want to see, a even if Tesla collapses they moved the EV needle.
Agreed, I'd also like to see more transparency - nevertheless, this is exciting. Good luck!
I was thinking about spinning up a support library for Haskell.. but it’d be a pretty serious investment of time when everyone’s employment is cut back or up in the air already. It would be nice to get a crate of sanitiser or something.
What do you mean by schema? JSON supports schema with libraries included in most popular languages nowadays. https://json-schema.org/

For numeric types, if you handle integer larger than 2 billions or floating numbers where the precision is critical (that's where json fails), these can and should be represented as string. I don't think there is any common format that guarantees large numbers and/or arbitrary precision to be encoded and decoded properly across languages and platforms.
If you want a working implementation (see comment below) and not a reference for the parser, you could use Apache Calcite:

https://calcite.apache.org/

But again, yeah it's a JVM thing so your options are that.
Gotcha. Thanks for taking the time to look!

It does seem like it was made to be easy to visually parse but it still feels like the delimiter choice has been something of historical baggage (to the point where just changing the delimiter itself, such as TSV, makes it easier to parse).
It seems much more directly comparable with CBOR/JSON as they mention it a lot https://amzn.github.io/ion-docs/guides/why.html#dual-format-... . I use CBOR quite a bit. It sounds like it doesn't really offer too much different in the binary form other than in the textual form it maintains better types than JSON and the textual version matches the binary version (where JSON / CBOR are mismatched in terms of types). So, seems nicer as a cohesive textual/binary format. I'd be interested in seeing how well packed the data is in Ion vs CBOR.
There simply isn’t enough data to base predictions on. It will be close to random wether or not this system will “predict” a crime, to a similar degree that a clairvoyant can guess where the next crime will happen.

It seems like the law of small numbers at play here - or a snake-oil salesman doing a thorough job.
I'd be interested to see if the tooling around moderation could also be improved. For example, could the images start heavily blurred, with a circle of clarity that opens when you click. Or something like that, which would harm throughput, but be more humane.
https://wiki.bitlbee.org/
What English skills did you acquire at uni? My English has always been quite good and I don't feel like formally studying English has helped me that much.

Perhaps I've just forgotten about how much I've actually learnt though.
I would argue that any human-readable format that relied on defining blocks by opening/closing symbols is a format that's not suited for config files that are expected to be manually edited by humans with a text editor.
The second part of that conjunction--discouraging your family and friends from using FB or Twitter--is definitely not easy.

In fact, it's basically the entire problem.
The story of the Tank Man photo by its photographer, Jeff Widener
From the document:

> The following timestamp encoded as a JSON string requires 26 bytes

> ...

> This timestamp requires just 11 bytes when encoded in Ion binary

So, we just use JSON, and our solution to this problem has been to pass 64 bit unix timestamps around. It doesn't provide arbitrary precision, but for most use cases it is more than enough practical range & precision to get the job done. And of course we store & transmit everything as UTC, so there is no weirdness around needing to store additional timezone information. To give you an idea, our database columns are named things like CreatedUnixTimestamp.

It is also trivial to compare 64-bit timestamps without conversion, so any SQL storage of these as integers should yield massive speedups to queries against these types - Assuming you are coming from some more complex datatype like a string or byte array.
The YC application process in and of itself can be very useful for founders. It forces them to really think about what they're building and why it's going to bring value to customers.
Like most decisions from the Administration these days - it's likely aimed at Trump's base in a critical red state where his support has fallen.

https://www.forbes.com/sites/nicholasreimann/2020/07/22/bide...
So I take it that you're volunteering to come run all my Audio/Visual stuff for free?

I spent 120+ hours dealing with all the Audio-Visual idiocy to deliver a 20 minute talk that took me probably 20 hours to prepare.

Yeah, adapt. I have some four letter words for you.
It's a little bit of work, but really it's surprising how well Git works with the dumbest servers. I run a number of Git mirrors off a $5 VPS served from a folder that I run python3 -m http.server in; it's literally just that and it works beautifully.
Just seems kinda odd to me to distinguish Fortran and Python here, based on how many levels of abstraction there are between the user code and the main function.

How would you place Bash scripts then? Or a JITed language like Julia?
Tesla hasn't proved that you can make a reasonable amount of profit compared to your investment when selling to that market. Hell, they haven't showed you can make any profit on that investment, they're still deep in the red. It would take them something like 10+ more years at their current income to even break even. Is it really such a surprise that companies that need to make money aren't dying to get into that market?
> no one is reporting these guys for selling you rat that's labelled as chicken.

This seems unnecessarily hyperbolic and maligning of Southeast Asians. Some of the best food in the world is in South East Asia, and even in less regulated places, no one serves inedible food. Market forces work even those places, and food places that are bad will naturally fail.
The Model 3 and Y make that (mostly) moot (size aside).

We've got a Model 3, I've had S loaners and my dad's got an S, and I've driven the S as far back as maybe 2013?

There are things I like about both. It's not at all clear to me that if you made me choose a free car to receive, that I'd choose the S over the 3.

If you're making me spend my own dollars, 3 all day. I just don't like the S twice as much.
It's not just Rails, it's basically any semi-modern development toolkit. JavaScript's minimal standard library is one of its biggest flaws and one of the richest sources of exploitation, as exemplified by the left-pad fiasco.

It's not even about the standard lib as much as the culture. Ignoring the fact that it would take years for the changes to become widespread enough to be usable, "pull in 400MB of dependencies for everything, including dependencies of dependencies" is practically a cultural value in the JS scene. It demonstrates why JS is voluntarily practiced primarily by the inexperienced all these years after it established itself as the universal platform.
Hermit Crab Vacancy Chain
> I speak with startups who have a product that is poorly differentiated, me-too like, that think they are going to take over the world. The reality, the vicious Darwinian reality, is that you and your team have to bust your collective rear-ends. And get lucky.

Even being Early (or in our case the first to do something) doesn't always work, we had to give our services away for free, or at a significant loss when operating costs were accounted for, because we were using technology that was not really understood (much less by our demographic) and had not been attempted in the past to facilitate or service the Industry we chose. So we had to engage our future paying customers in a way that they relied on us for something they found useful and pay for it in the future, so I boot-strapped and fell back on my other skill-sets, that ultimately took time from further development that could have otherwise yielded a better product in less time, but again... uncharted territory means you are make the Map as you go along, with all the mistakes and hidden landmines along the way.

> This is very ... very hard for bootstrapped companies, operating on shoestring budgets at best.

I'd say Bootstrapping is a Pyrrhic Victory, because on a financial level, had I decided to stay on the sidelines and just DCA while trimming the fat from my budget working a normal day job, as so many now in this space did, I'd have an ROI way better than my Startup, and most ever created in that space for that matter, ever was. They thought they were geniuses, when in reality they were just 'free-riders' that directly benefited from the work done by risk takers and people who actually did the heavy lifting to get the project to where it was and currently is. But ultimately looking at our holdings and net-worth on paper wasn't the point for some of us, it was to bring our vision into existence and prove a technology could solve far more problems than even it's core developers and even the greater community at large could ever think it could and bring about a desirable change to the Enviorment. And for that it takes a lot of sacrifice, which ultimately made me understand that 'disruption isn't always profitable' is a very true statement in a financial sense, but can be very profitable if you're goals are to do more than that. It's just how you quantify it.

> And the cost to you, financially, mentally, physically, will be huge. Not can be. Will be.

Agreed. Still dealing with that to this day. Just my Physical Therapy costs alone have been something I didn't anticipate to be so expensive in every sense of the word.
> So, we just use JSON, and our solution to this problem has been to pass 64 bit unix timestamps around.

Passing an integer does not have the same semantics as passing a timestamp. Relying on out-of-band info to parse a document is a problem in the making.

> but for most use cases it is more than enough practical range & precision to get the job done.

Parsing s-expressions would also get the job done, even if it's a primitive s-expression that only supports cons cells and a string data type. However, people find value in enabling the parser to validate booleans, arrays, and objects.

ION is just a logical next step. Timestamps are quite naturally a fundamental data type in comm between web services, particularly in binary form.
> Why do you want those separated?

You don't, there was a time when separation of concerns got mistranslated into separation of technologies and it became an almost religious mantra. But if HTML, CSS, and JS all combined to create a single black box component, that is a single concern, separating the technologies for separations sake only serves to reduce the reasonably of the black box. There are still those that where taught in that time, that separation of technologies and separation of concerns where the same thing, but they are not and that is well evident in that react component are easy to reason about.
The courts ruled that Microsoft should be broken up in 2000, and the case was settled without a breakup about a year later. The cases in the early 1990s were not even about the web browser, which did not exist yet -- they were about Windows licensing agreements from the 1980s.
They watch for new DNS entries and then ping it.

It's the reason why Google have their own DNS registrar, they get told about all new websites.
Tax credits may have made the difference between making Tesla survive and not (I don't think any of us can know that, but I'm being generous here), but that's not the same thing as a business being "largely funded by US tax payers". That needs a huge [citation required], not to mention an analysis as to whether these are outsized taxpayer subsidies for Tesla + electric infrastructure and subsidies vs internal combustion automakers + petrol infrastructure and subsidies.
So *that's* how Breitbart is still making money
Pass 64-bit Unix timestamps around as JSON numbers? That's a bad idea, seeing as they're 64-bit floats. You're better off formatting your 64-bit integers as strings.
This is a great bit of internet history, if for nothing else than this Douglas Crockford quote in response to a flamebait-y argument about XML being superior to JSON:

“The good thing about reinventing the wheel is that you can get a round one.”
I would argue aiming for synergies is fundamentally wrong headed unless you're trying to moonshot with a lucky deck. There's way too much varience in expecting to get offered certain cards. That being said some synergies like silent poison probably worth gunning for... But that's mostly because poison cards are disperportionately strong.
> Fretty: An interactive fretboard exploration tool for all stringed instruments.

Except for the stringiest instrument of all: the piano. :)
Any chance you could share a screenshot? I can't test safari without owning apple products or paying for a service :(

as far as I know iOS 13.4.1 should be completely compatible.. there might a smaller limit on the number of calc() operations? The spec says it must support a minimum of 20 operations, but I'm (ab)using almost 1000 in a max()
The mere possibility of this underlines the relevance of RISC-V.
Gnuplot is really an awesome project. Though I don't use it all that much anymore, it will always hold a special place in my computing heart. In an undergrad physics lab it was my first experience with launching a program from a shell-- and that sure sent me in the right direction. Thanks to all who have contributed to the project.
tl;dr: They are committing ad fraud.
Would you please stop feeding egregious comments by replying, a.k.a. feeding the trolls? The site guidelines explicitly ask you not to do this, but to flag the comments instead: https://news.ycombinator.com/newsguidelines.html.

I've banned that account but the damage is caused just as much by the users who perpetuate the flamewar.
Why all the Vox hate? Real question. I don’t have an informed opinion about the site.

With things like high joblessness, rents/mortgages going past due, and unemployment assistance set to expire, the road ahead in the US looks pretty bumpy to me.
tbh I've been a moderator on various old school forums for over a decade, and I've never had to deal with anyone posting any gore at all. I think they're usually too tight knit and reputation based for anyone to feel like they could get away with it. it's not like people posting gore on facebook are doing it to mess with the moderators, that's just a side effect
You seriously want to play with sourcehut.

It has its own very hacker-oriented aesthetic and tries to keep the various components it provides separated so for things that are "close enough" you might be able to bootstrap off their tools.

Also, the concept of a CI system where a failed build sticks around for a while and lets you ssh in to figure out what went wrong is -way- cool.
There are a lot of accounting choices that go into gross margin, and a forensic accountant could dedicate a year to understand the various shell games played by car companies between financing, depreciation on equipment, and warranty.

So as a simple matter, it helps to double check the reported gross margin against EBIDTA. And with that measure, my comment stands: Tesla’s reported profits depend on continuing to sell regulatory credits.
From the linked article:

Q: Can't you just apply some filter, or compression, or blurring algorithm, or add some noise to the image to destroy image cloaks?

A: As counterintuitive as this may be, the high level answer is no simple tools work to destroy the perturbation that form image cloaks. To make sense of this, it helps to first understand that Fawkes does not use high-intensity pixels, or rely on bright patterns to distort the classification value of the image in the feature space. It is a precisely computed combination of a number of pixels that do not easily stand out, that produce the distortion in the feature space. If you're interested in seeing some details, we encourage you to take a look at the technical paper (also linked above). In it we present detailed experimental results showing how robust Fawkes is to things like image compression and distortion/noise injection. The quick takeaway is that as you increase the magnitude of these noisy disruptions to the image, protection of image cloaking does fall, but slower than normal image classification accuracy. Translated: Yes, it is possible to add noise and distortions at a high enough level to distort image cloaks. But such distortions will hurt normal classification far more and faster. By the time a distortion is large enough to break cloaking, it has already broken normal image classification and made the image useless for facial recognition.
> This binary format supports rapid skip-scanning of data to materialize only key values within Ion streams.

(1) awesome but (2) 'key values' is a confusing way to say this
If Tesla own something that's worth money, they generally are required to disclose that publicly. They need to include it on their balance sheet and send that to the SEC quarterly in their 10-Q or 10-K filing. That's the main requirement of being a public company.

Tesla's accountants know this and follow the SEC rules, even if Musk doesn't. Is there some special treatment for these tax credits? Are they rolling this credit in with something else? Otherwise I don't believe they can be "squirreled away" to make the numbers look good "at opportune times".
Please don't do ideological flamewar on HN.

https://news.ycombinator.com/newsguidelines.html
Also, "Why use something else when we can use data.join(',') -- that should be enough!" must also be a contributing factor to why CSV will never die.
Although it is easier to see the benefits of using JSON as an interchange format because it is lightweight, I still believe that XML is more elegant and verbose than JSON. One of the complains for JSON has been the lack of schemas, although there are some ways around that in projects such as Apache Avro https://avro.apache.org/, registry schemas and all that Jazz
You're ignoring the forest for the trees. Were you listening when the extrajudicial killings incited these peaceful protests?
If you have more than one developer working on different features, it’s inevitable they’re going to need different data. Unless you have a tight feedback loop between frontend and backend devs, you’re going to end up with pending unresolved issues requesting they add another field to be returned on a specific, custom “rest-like” endpoint. If you instead put the onus on the frontend to allow arbitrary field requests (of course within limits, typed and auth’d), this is no longer an issue. Of course the api has to have a schema defined, so there could be a request for a new field to be added there. But if all your endpoint returns is what we need NOW, then you will inevitably have to add more data to the endpoints later with new features. This isn’t of course the only benefit of GraphQL, but it’s certainly a nice convenience for those having to make those requests.
* Truth tables and Karnaugh maps blew my mind, as did the rest of Boolean math. I loved finding a way to formally think about things I'd vaguely and unrigorously thought about before, and the notion of mathematics without numbers opened my eyes.

* I loved political science and sociology classes. I would not have predicted that.

* I use my physics classes all the time, but never in ways I would have anticipated. "Hey, I wonder how high we are. Here's a rock we can toss down into that pond. Get your stopwatch!"

* I very rarely find myself working with finite state machines, but when I do, it's nice to feel comfortable reasoning about them.

* Big-O notation? All the freaking time. That's an enormously powerful tool for thinking about how systems will scale with the number of users, for instance.
> This is memory safe, but in an unsatisfying way.

How is it unsatisfying? I know that "xs[idx]" isn't going to be garbage data from elsewhere in my program, and that it won't occasionally segfault when I try to print it.

That's a big improvement.