skysight-inc/HackerNews huggingface dataset:
I know RDBMSes are supposed to hide the “raw” procedural query plan underneath a declarative “what data do you want” abstraction layer... but what if I know exactly the query plan I want? Why can’t I upload a “prepared query plan” and execute exactly that query plan?

In most RDBMSes, the problem with that would be that there’s no existing formal intermediate representation of a query plan, to use on the wire.

But in PG’s case, that’d be LLVM IR, no?

I haven’t looked too deeply into what Postgres exposes via its extension APIs, but I feel like it wouldn’t be impossible to write a PG extension that would let you call a stored procedure with a bytea containing the LLVM IR for a query plan, and get back a handle to a “prepared statement that’s a little bit more” — where EXECUTEing that statement would just reuse the cached query-plan attached to it, as if PG had previously JITed a plan for that statement.

If I built something like this, would anyone want to use it? It’d have the disadvantage of you having to figure out how to generate LLVM IR on the client side representing your desired query plan; and that query plan potentially getting out-of-sync with the DB. But with stable DB schemas + data sizes (e.g. in data warehousing) it seems like a win.
I find this to be so very cool. Here in the US, we have very few small businesses, if any at all, that have been around for 100 years in the same location let alone a location that has been there for 9 centuries, let alone with decorations that have been on the walls dating that far back.
> Inspections can save a blade failure from happening, but they cannot be relied upon to prevent failures

You still are not addressing my point.

Of course inspections cannot be relied upon to prevent failures due to root causes that are not known prior to the incident.

But inspections are relied upon to prevent failures due to root causes that are known. And that's what failed to happen in this case.

Put it this way: by your argument, the NTSB's final report on this should be something along the lines of "this was an expected failure and the containment worked, so no corrective action needs to be taken". Do you really think that's what will happen?

Whereas by my argument, the NTSB's final report on this will be something along the lines of "the inspection process failed to properly catch a cracked fan blade, and corrective actions A, B, and C need to be taken to fix the process".
Creating synthetic time series data
A step-by-step guide to creating high quality synthetic time-series datasets with Python
Smart? That's the wrong methphor.

That said, yes apparently so. Else it wouldn't have "canceled" this idea.
Scroll up or go to https://www.flowrite.com/?ref=lbixer#examples to see more examples of what it can do.
But I'm a gamer and upset already :)

I just checked and my 1050Ti costs new about 30% more than what I paid for it 2 or 3 years ago...
Don't worry they will let you know you're privileged again to explain why you don't get the mental gymnastics required to make sense of this crap.

So much of the stuff I hear groups like BLM say is very far from being true and isn't based on any stats. They often operate very similar to a terror group and do cause a lot of actual terror. Businesses get destroyed, burned down, they attack federal buildings, they attack police, they attack white people who disagree with their ideology, they attack politicians who disagree, they riot outside of politics houses or people who disagree with them, etc. I'm sick of this being deemed somehow "ok" when if a different group did it they would get labeled as a terrorist group. It baffles me how a small group like "Proud Boys" can be labeled as a terror group despite being leagues less dangerous than BLM. The BLM roots caused over $1 Billion in insurance costs alone. If that isn't a terror group I don't know what is.
Has anyone bundled this inside an Obj-C (/swift) app to see if it's possible to run this on an iPhone?
I'm so glad you took debate club. Meanwhile, what is the message? Because anemic articles excel in not having one...
That seems like the bare minimum but I expect that at some point a ransomware will hit a high enough profile target that the federal goes through the effort of actually tracking down recipients.
Huawei Unveils $2,800 Foldable 'Mate X2' Smartphone with Dual-Screen Redesign
Of course, hitting a path without a handler is a bug, a resource which doesn't exist is a normal thing.
That's making a giant assumption that Tim Sweeney cares if he has 10 billion or 20 billion. I've followed his career for decades, and I doubt he would sell out his control for so cheap.
Planned communities, organized by the rich and powerful around the latest and greatest in technology or political change, are not novel in the slightest and certainly not unique to tech billionaires.

https://en.wikipedia.org/wiki/Planned_community We've been doing this for about the history of humankind, and many of the world's capitals are planned cities. Sometimes it works well and sometimes it does not. For example Brasilia was a planned utopia built around the great innovations and delights of the 20th century - such being planned around motor traffic. And upon reaching a state of overpopulation, it became well known as a dystopia instead.
TCP Observability with TCPDog at Scale
I don't have as negative sentiment as grandparent comment but I was disappointed by some parts.

C++20 added niebloids. Not exactly template trickery, but still another concept introduced to fix problems, caused by other complicated feature, introduced to deal with other features problems.
Python is widely considered to be very expressive and very readable.

You can write unreadable code in virtually any language but that's besides the point.
Put it is way, it might make it easier to write the reverse system that convert a (machine generated) noisy input text to a succinct list of facts :).
>planted by actors in the US, like Li-Meng Yan

She isn't an actor. She's a bit of a conspiracy theorist type from Hong Kong on the Wuhan lab leak stuff. I'm not sure how that's relevant to anything much here beyond that it pays to check your sources.
> It's conjuring, for example "after weeks of hard work" from thin air.

I think this is not that dissimilar from a human writer. Recruiter email's come to mind as an example of this as well.
Reverse Engineered Grand Theft Auto source code taken down by DMCA request
I don't believe there is any named virus where we have reached herd immunity without a vaccine.

Herd immunity was defined by the theory that it would prevent the spread of measles. It only did so with any measurable effect after universal vaccination was introduced.
> You just need to write it like C++, with memory management in mind at each stage of development.

Having worked on a 'low latency' trading system written in Java, this is true. Ultimately you end up using a flyweight pattern over shared memory, and you have to be aware of alignment and cache sizes. Then there are other tricks like zero GC, or pushing the collection back to once a day.

You also spend a fair amount of time analyzing performance to the nanosecond looking for, and eliminating, jitter.

I've also written the same in C++, and it's a similar exercise, along with dashes of [[unlikely]], template specialization, and far too much time inside godbolt.org looking at assembler to see if gcc/clang has "optimized" something in the latest release.
Context matters. The school board wants to keep schools closed. There is no science to back this decision at all. Many states have schools reopened for many many months. The school board not only wants to keep schools closed based on purely politics. Now they are attacking parents in closed group discussion? These are horrible human beings and they definitely should not be on the school board.
It seems the variants are arising in places where people have been mixing and not socially-distancing.
This is a vast oversimplification on my part, but I suspect what you observed was because the European cities are run by governments that are more inclined to serve the needs of citizens, and US cities are run by governments that are more inclined to serve business interests.
Proposal: include the short list of facts as the first paragraph.
I'd recommend the opposite, as with a versioned URL you can very easily route stuff to different machines by simple URL inspection and have a very clean separation between versions.
As if educating children is not one of the most important tasks on the planet.

Of course educating children is important but the current method of doing so is not the only possible one, and arguably prioritises the lifestyle of so-called teachers over that of children, parents, and taxpayers in general.

What if the lesson of COVID is that MOOCs are actually better? Or homeschooling is actually better? Why should we go on paying teachers who, despite their bleating, are actually very well compensated for what they do (when they bother to show up).
Here's the problem with hiring a pro.

The workhorse NIH grant[0] is a R01 with a $250,000/year x 5 years "modular" budget. Most labs have, at most, one. Some have two, and a very few have more than that. This covers everything involved in the research: salaries (including the prof's), supplies, publication fees, etc. Suppose you find a programmer for $75k. With benefits/fringe (~31% for us, all-in), that's nearly $100k/year. If the principal investigator (prof, usually) takes a similar amount out of the grant, there's very little money left to do the (often very expensive) work. In contrast, you can get a student or postdoc for far less--and they might even be eligible for a training grant slot, TAship, or their own fellowship, making their net cost to the lab ~$0.

This would be easy to fix: the NIH already has a program for staff scientists, the R50. However, they fund like two dozen per year; that number should be way higher.

[0] Other mechanisms exist at the NIH--and elsewhere--but NSF (etc) grants are often much smaller.
Structured Text: Notion-like editor for DatoCMS
True, but you have to pay your taxes anyway. Would you like to do it from the comfort of your home in whatever time you like or would you rather do it in person, standing in line for maybe hours and dealing with sour clerks?

I know which option I would go for.
> - Allow filtering, sorting, and pagination: yes, good luck coming up with the right query structure and sticking to it.

I believe that treating RESTful APIs as a smart data storage that can do advanced querying is a mistake, or rather REST is not the proper solution for this use case, and you did well to move on from it. Personally I've never failed to use REST successfully as long as I was willing to do proper caching, sorting and filtering in the API consumer. REST is plenty if you need presenting collections of things with key-set pagination and proper caching headers.

In the days of HTTP2+, it's easy to fire 100 concurrent requests to a key-set RESTFUL API and load all the data that you could ever need. :)
SARS was more lethal and people actually took public health measures seriously.
Not a new thing of course, but there is a big difference between trying to build a utopia and building a city to house workers
FWIW, there's actually a large amount of industry experience in ultra-low-latency Java kicking around the ATS/exchange/HFT space. Island's ECN was Java, and that incubated a lot of this kind of talent.

It's absolutely not your everyday java (I've heard the answer to "how do you handle gc's" is just "don't allocate memory") but it's a Thing.
I believe Spanish naming conventions are usually paternal last name followed by maternal, making it perhaps more appropriate to refer to him as Álvarez, but this is not without exception (notably Pablo Ruiz Picasso).
Is the use case for this mainly IDEs or is it intended to replace traditional lexer and parser generators too?
Lockdowns were never going to work, and any strategy that relied on them was doomed to fail.

A strategy that involves convincing every country, and every little province, to destroy their local economies, all at the same time. I can’t believe it didn’t work! Maybe if we just keep trying.
You can't pay your utility bill with Apple stock, or buy groceries with crude oil ETFs. You have to convert them into money first. Does this mean that they are not a store of value?
It's over-collaterized, so if you fall below the 150% minimum collateral ratio, maker smart contract could liquidate the asset to cover the loan and then return the remaining 50%-liquidation fees back to you. As long as you're conservative in your borrowing (as in you borrow up to 25%-50% of your holding), your chances of getting liquidated are pretty slim.
Show HN: Scroll – A New Way to Publish
Read a lot of books, start with Intelligent Investor, but also learn active trading ideas. Remember most people are selling snake oil when it comes to trading courses. Just stick with cheap books with a lot of reviews/sales. Hopefully, after a lot of reading, you will have more confidence in investing and/or trading.

I just put everything in SPY and ARKK.
The WSJ editorial section's track record on COVID based information has been, to put it kindly, not good. Why are we taking it with any kind of authority NOW?
As a general matter, I think Utopianism is a bad idea, and I don’t think we should be sinking huge amounts of resources into giant leaps like this. I’d rather see incremental tweaks in the right direction first, as I think those are far more effective at bringing lasting change.

Fundamentally, we’re really bad at predicting the future. Utopian projects involve making big bets on what the future might hold, which makes them high risk high reward. I think making smaller, incremental bets allows us to not only wager fewer resources, but to also begin getting feedback sooner on the outcome of our decisions rather than hoping that we’re spot on in 20 years.

More specifically, I’d like to see a lot less “we built a city for autonomous cars and hyperloops” and more “we added some bike lanes and bike parking, and converted commercial streets to pedestrian only.” These are changes we can make today to improve our quality of life, and they practically cost very little.
Maybe someone has more "real" experience than me on this, but the article says :

> Since IDE support for Java is much more advanced than for C++, most environments (Eclipse, IntelliJ, IDEA) will be able to refactor Java. This means that most IDEs will allow you to optimize code to run with low latency, a capability that is still limited when working with C++.

He cites IntelliJ IDEA as a powerful Java IDE, but JetBrains does have a C++ IDE which is quite advanced (CLion) and whose refactor function always impressed me. I'm sure Visual Studio has some pretty impressive refactoring capabilities by itself or with JetBrains plugins. Is it really that bad and I've just not worked on large enough projects ?
Agreed, low latency Java is very far from standard Java programming.

> or have to do heap allocation

FYI, heap allocation in Java is much cheaper (~11 cycles) than in C++ as it's just a bump-the-pointer in TLAB.

https://stackoverflow.com/a/38298326/1278647
There are a bunch of elitists on here who get off on hating popular things.

I find it amusing that some of the comments are basically "Why use graphql when I can combine these 5 other technologies to do the same thing?"
I really am struggling to see the practical value here. You have to provide collateral worth more than your borrowed amount. The rates are HORRIBLE for borrowers. Straight up predatory.

The anonymity part is cool, but if I want to borrow to get a mortgage how exactly does this help me? I do not have $500,000 in crypto laying around and a traditional lender will give me a 2% interest rate instead of 15%
Have a low population density.

The largest metro area in Atlantic Canada is Halifax, and it's 2/3rd the population of Madison, WI.
Cases of the British variant are in exponential growth, current lockdown measures are not effective against it.

Not in Britain.

https://coronavirus.data.gov.uk
Human After All was already on the downturn.

To me RAM sounds like an Air album, not a Daft Punk album. I don't consider that a bad thing though.
> Any ideas on how to detect being the subject of such a simulation without prior knowledge that the upload would happen, or that uploading even exists?

https://en.wikipedia.org/w/index.php?title=Eternity_(novel)&...
One of the things that I think will need to be sorted out once less people start wearing masks is who has gotten the covid vaccination.

For instance, I don't think it would be too hard for an entire group of people to say "we got the vaccination, that's why we're not wearing a mask" and just further spread it to the majority of the population who hasn't gotten the vaccine.
Furthermore, if all your competitors have to incur the same fixed latency, then this is irrelevant. Just because one system is 200mics and another is 201mics doesn’t mean the 201mic one is good enough. HFTs are competing on what they can control, because if that trade comes with 199mics of network latency, it means the first firm will make a good trade every time, and the second will be shut out.
Yes, I realize this arguments cuts both ways. One way is that you can write all these theorems in constructive logic, so there is no need for classical axioms. And the other way, is that users should freely use classical axioms because they can be mechanically removed.

Myself, I've never seen an automated theorem prover that will perform this sort of translation automatically. I have, on rare occasion, gone through by hand to remove uses of classical axioms in Coq proofs of theorems than ought not to be using them. Usually the uses are pretty superficial.
Looks like every other text file I've seen from hacking groups over the last 25 years, which is the aesthetic they're going for.
LSP supports semantic highlighting: https://microsoft.github.io/language-server-protocol/specifi...

Though AIUI the basic syntax highlighting is done by the editor (e.g. VSCode uses Textmate grammar support).
It didn't start that way in NY, but now they have that option precisely because nobody can recognize them, right?
Tree Sitter is amazing. The parsing is fast enough to run on every keystroke. The parse tree is extremely concise and readable. It resembles an AST more than a parse tree (ie no 11 levels of binary op precedence rules in the tree). The parse tree emits specific ERROR nodes, so you can get a semi-functional tree even with broken syntax.

I can't wait for the tools to get built with this. Paredit for TypeScript. Syntax-tree based highlighting (vs regex highlighting). A command to "add an arg to current function" which works across languages. A command to add a CSS class to the nearest JSX node, or to walk up the tree at the className="| ..." position, adding a new className if it doesn't exist.

There's a nicely documented Emacs package for this [1]. The documentation is at [2]. The parse trees work great. There's syntax highlighting support and tree-walking APIs. There's a bit of confusion about TSX vs typescript langs but it's fixable with some config change [3].

[1]: https://github.com/ubolonton/emacs-tree-sitter
[2]: https://ubolonton.github.io/emacs-tree-sitter/
[3]: https://github.com/ubolonton/emacs-tree-sitter/issues/66#iss...
Vinge's line on this, from A Fire Upon the Deep:

This innocent's ego might end up smeared across a million death cubes, running a million million simulations of human nature.
What the Heck, z-index?? Understanding Stacking Contexts in CSS
Considered "very readable" by whom? It's pretty well accepted that dynamic/weakly typed languages are more difficult to deal with at scale.
First human case of bird flu H5N8 detected in Russia
Show HN: Plasmic.ai – AI-powered video platform
This

> It does drive me slightly crazy that this system JUST INJECTS NOISE.

is actually an important service. What is noise to the sender is generally not noise to the reader. It would be awesome if at some point in the next few decades we only have to provide information that we need to think about and the computer could find a way to compile it into what the reader is looking for. In other words, if the computer could do what most every secretary was doing in the 1960s.
Huh, I was familiar with this trope from the Black Mirror episode that explores the same theme, down to Star Trek-esque uniforms and ship layout, had no idea it was based off of an actual Star Trek episode.
I still remember seeing the Alive set at a festival in France. They were headlining but I didn't really care about them anymore back then. I went to the concert anyway as it was the last of the night. The whole show blew my mind! The stage, the lights, the mashups that made the old songs feel like new and made the new songs don't feel so new.
I can tell you the 30+K people attending the concert that evening were almost all in trance during and after the show. I cared again about them after that!

I also remember listing to the live record (which is the Paris recording if I'm not mistaken) after it came out and it was very different of the one I saw. So definitely some live creation happened during that tour, or some in-between sets work maybe (if you don't believe in magic).

Side note and personal opinion, I think "Veridis Quo" would be the perfect soundtrack for this announcement, and is one of my all time favorites of them.
Here's to a bright future for both of them hopefully!
All such cases of pogroms, ethnic cleansing and so on in recorded human history, happened because of systems that openly, tacitly or implicitly accepted or promoted racist views, laws and sentiments. In some cases the inaction of the system allowed them to happen, in other cases the system directly inflamed them to happen. In others yet, the system (by extension the military and others directly under command of the system) directly perpetrated these acts.

I say the root cause is systemic, you say the root cause is individual. One cannot exist without the other, but I say it all boils down to a systemic issue causing the individual issues.
> It's common sense

So when should schools be opened according to this?
Aung San Suu Kyi Charged with Importing Walkie-Talkies
Some RDBMSes like Oracle let you give hints about how you want things joined, which is usually what you mean when you say you want to specify the query plan.

I think I would like to see that in Postgres, but I don't think it's a common requirement. Usually you can just update the statistics to get the planner on the same page as you. I just like to have options in the toolbox, just in case I need them.
As a practical matter training can make cyclists more efficient by improving aerodynamics even if their psychological efficiency doesn't change. It takes quite a bit of muscular endurance and body awareness to hold an optimal aero position through a long ride.
The question is, one you are no longer writing anything close to idiomatic java, does the (sketchy) argument that Java is easier to write than C++ still holds?
I thought Get Lucky’s quality was more a reflection of Pharrell and Rogers’ talent than DP. The rest of that album was a whiff.

That said, GL the song and video were great and no hiding the string of classics. I remember hearing Around the World on the radio for the first time and pulling my car over. I was in high school.

A few notes on this video:

1. I wonder if this was delayed due to the bomber in Nashville. Still seems almost too soon.

2. Obviously has black rock vibes, looks like one continuing on to the mythic show at the trash fence.

3. Suggests one member wanted to keep daft punk going, where the other had enough. Otherwise I would have expected a mutually assured destruction.

The symmetric hands around the dates suggest amicable closure prior to conflict of ruin, which would be for the best in any partnership.