skysight-inc/HackerNews huggingface dataset:
How many people are actually using raw SQL on the backend? I thought people got tired of maintaining strings of raw SQL and migrated to query builders or ORMs.

> I usually end up with a bunch of Lodash (groupBy, filter, map, reduce) to shape the data I get from the server.

I mean, we are also doing the same thing with ORMs on the backend.
I am an Indian. I can attest that a lot indians are extremely corrupt and will abuse the system as as possible for their own benefit. I am so ashamed of being an indian. Indians are the people who don’t put the shopping cart back in its place and just leave it in the parking lot and the rest of the people can’t park their cars. They unload the cart into car and don’t bother that traffic is backing up.
We do precisely what bacteria does, albeit at a much more complicated level. And I'd argue bacteria does what basic particles do, albeit at a much more complicated level. There are vast number of parallels in the behavior of systems from the microscopic to the macroscopic.
Seems like reporting a phone as lost without losing it would be the equivalent of lying about income, which is generally recognized as tax fraud, not business acumen.
This article doesn't say what is in the title. This might be better:

https://www.theverge.com/2021/4/15/22385240/tsmc-chip-shorta...

To that point, this issue is already painful for anyone making electronics, and is going to hurt the small electronics manufacturers more (if you aren't in a position to buy a million parts, good luck getting any priority as things come back on line).
The state national convention route is the most likely route to work if you really want to reign in Congress.
Because individual motivation and macro-behavior aren't necessity aligned, individual understanding might not be enough to changes behavior of the system as a whole. Maybe individual bacteria understand the impact they might have on a host system and are concerned about outcomes as well.

I sometimes think that it is a valid mental model to think of us as not much different from ants in a hive who think they possess more control and freedom than they do
Damn, at this point I might just wait until zen 4 stuff comes out before replacing my current desktop (circa 2012) since it still seems fine for most stuff.
My problem with the data and how it's given is that it's quite useless and the result, while not the null hypothesis, is the expected result.

Namely, it can be expected that no man would find a speaker dumber with superior audio, so let us assume that only 1% of the sample found the speaker more intelligent with superior audio, and for 99% it makes no difference, then the “average result” is still that “people” as a collective average find a speaker with better audio more intelligent, even though 99% of people don't.

This is my problem with such research. — I am far more interested in the percentage of “people” onto whom this has an effect or how large the effect is in distribution. It goes without saying that this effect exists with some “people”, but I would like to know what percentage.

It's entirely possible that the effect only exists with 20% of “people” and 80% are not biased, but the research is incapable of showing this.

Such research, which does not, and cannot due to it's methodology make any claim as to the percentage of “people” it applies is often taken to apply to all “people”.
That’s fine, people will probably just gain immunity to that, like when they realized that train on a movie is not gonna run over them, or when they realized that the king of Sweden isn’t actually wearing silly hats.
I think the insider trading laws don't require motive - just that they had private information or used their position of influence and that they benefited from a related trade. The rules for executives at companies usually requires them to file any trade plans related to their company stock prior to actually making the trade, which would at least prevent the short term plays like the Pelosi example. Even tech people at trading companies are subject to restrictions in what they can trade, even if they aren't looking at the financial data.
> complaining about things as loudly as possible about every single perceived injustice

What you describe here is how the American right caricatures people who make change in the US. Civil rights activists did more than "complain"; indeed, if they had only complained, it's hard to see how they would have been able to overcome white supremacists in business, law enforcement and government.

Just look at the Montgomery Bus Boycott, or the lesser-known Freedom Riders. These were campaigns organized by a coalition of local folks in the South (mostly, but not entirely Black) as well as anti-racists in the North. These activists were successful because they were strategic (the Freedom Riders forced the Kennedy Administration to enforce existing anti-segregation laws on US highways...) and incredibly brave (...and they endured having their bus firebombed by white supremacists while the police stood by watching).[0]

Much like organized labor, Civil Rights activists created a power base among the disenfranchised in the face of state sanctioned violence, up to and including assassination.[1]

It's fair to say that some progressives caricature the accomplishments of Amazon, which, on a technical level, are tremendous yet difficult for a non-technical person to appreciate. But this comment comes close to saying that ordinary people have no right to criticize the great men of industry like Jeff Bezos and Henry Ford. This is particularly ironic because Ford published and distributed anti-semitic propaganda to the extent that he was personally honored by Adolph Hitler[2]; Ford also hired armed thugs to intimidate and attack union organizers.[3]

There's a particular tendency on HN to lionize successful (rich) founders and CEOs to the point of obscuring their exploitation of labor. This includes Elon Musk, who literally purchased the title of "Founder" for Tesla, and whose factories had, at one point, accumulated more OSHA fines than the next ten car manufacturers put together.[4]

I'm not saying we shouldn't appreciate the staggering achievements of companies like Amazon or Tesla; I personally think Tesla has the only big vision worth pursuing in all of Silicon Valley. But nor should we ignore the human cost of what they do. Jeff Bezos and Elon Musk are among the two richest men in the world right now, and they got that wealth in no small part through the exploitation and human misery of their most vulnerable employees.

0. https://en.wikipedia.org/wiki/Freedom_Riders#:~:text=Freedom....

1. https://en.wikipedia.org/wiki/Category:Assassinated_American...

2. https://www.pbs.org/wgbh/americanexperience/features/henryfo...

3. https://www.thehenryford.org/collections-and-research/digita...

4. https://www.forbes.com/sites/alanohnsman/2019/03/01/tesla-sa...
What would you like to see done differently in the Canadian government?
why doesn't someone create an index fund that just track congressional trades?
> Their problem is that people are going to want a single interface to view everything through. If you actually subscribe to three different services, you want to turn on your TV and see everything available to you.

Google's & Apple's TV interfaces do that now. Search for a show, it tells you which streaming apps have it, including a CTA to maybe buy / subscribe one you don't have. There is a recommended show stream on the front page for google that is service agnostic too.

Yes you still have to download and login to an app, but people are used to downloading and logging into an app for their phones already and it's only a 15 minute procedure every 5 years you buy a TV, if that.
This sounds very interesting and possibly important. I would like a better explanation of what kind of "rotation" they are talking about. Is this a literal rotation in the sense of linear algebra ? If so in what space and how does that space map to neural networks ? Unfortunately the original article is pay-walled.
While I don't disagree, you're not exactly a spectator. If you're on a computer in a western country, you are in the top percentage of the world contributing not so insignificantly to this problem.

People sitting in traffic complaining about traffic or cancer cells complaining about the devastation caused by cancer sounds a bit silly.
As many SQL Injection issues (and various other injection forms, including Javascript) as we have with backend code, fuck no we don't want SQL being issued from the frontend.

For one, permissions around SQL are already crap. It takes the smallest screwup to expose data in co-mingled databases. No need to make it even worse.

For two, at least if the SQL is on the backend, a fix for an exponential query DDOSing your DB is fairly quick; you don't have to worry about some client keeping a cached copy of the frontend around for months at a time.

Finally, if you let the frontend send SQL, you have lost any and all ability to do a static audit against the queries that will be run against your database - because you have no control over what the client does.
It's weird to me that they even considered banning it. How would you enforce that?
I’m basically doing this for an app - each endpoint is just a parametrized query and RLS in the database enforces security/auth constraints.

The middleware doesn’t do anything except populate query parameters and do a bit of sanity checking.
It's impossible.

Who watches the watchmen?

And Democratic party believes that bigger gov't is the solution to many of our problems.
I hear the performance and memory usage of WebKitGTK is much worse than WebKit on macOS.
Build a Jina neural search with Streamlit
Schneier on Security: The Security Mindset (2008)
you can already find plenty of chinese in code for ml papers.
People (at least in the developed world) already have created all the value that they need. They have enough food, safety and shelter. Majority of the effort now goes into creating virtual goods. If you’re planning to be alive in 20 years, you’re better off making sure you hire robots with good work ethics.
I think your fundamental issue might be expecting a phone to be a decent multimedia capture device (phones == content consumption, not content creation). If it's an iPhone and you just care about speech, air pods will be hard to beat.
Given other comments in this post, I think at this point it's not safe to assume that.
I'm having a little trouble understanding this - are you writing SQL to do the window function, or does the ORM provide a non-sql way to do the window function?
From your user page: "My name is actually CyberRabbit. I made a typo when I made this account and HN won’t let me edit my user name."

There is no user "CyberRabbit" by the way, maybe dang would rename your account if you ask him?
>> verbiage chosen by the long dead.

Look at the average age of the people writing laws. I'd say that 90% or more of current law was created by people now "long dead".
then why the Fed was assigned the job of keeping prices stable?

All the other parameters in the economy such as the stock market, real estate, interest rate are free to fluctuate but the Fed can use its powers to keep prices stable and people employed.

It's clearly a political entity
We understand it but humans are composed of a variety of minds and what the rational one wants isn’t necessarily what we do.

Although conservation probably has more to do with reality looking different depending on your own local observations, to a Brazilian cattle rancher or Indonesian logger at the frontlines of the biodiversity crisis, things look different. For a consumer of those goods and materials, they likely don’t realize the connection.
You are getting downvoted but the internet has a very short memory.

Ethereum's DAO fork and the ETC debacle is why your OG's don't support Ethereum.
I can't find any way to get it to work with the Quest on my Mac. (Short of installing Bootcamp that is.)
SQLite does have a spatial extension in Spatialite. Whether it's enough for you is up to you to decide. FTS5 does seem to have some trigram matching function that again may or may not be sufficient for you.
If you assume total consumption is a problem, and you assume that total consumption will not go down because consumption per capita will not go down, then the conclusion you end up with is overpopulation.
Do you know what liquid democracy is?

It's a form of representative democracy, so it should be able to avoid the issues of oligarchy (being centralized and easy to corrupt) as well as the issues of full democracy (where every idiot has a say worth any experts)
Visualising every single person vaccinated in US
You should look up what the US did for Russian election. The US was deeply involved.

> Russia invaded Ukraine

The Crimea was part of Russian empire for 100s of years and even in the Soviet Union it was part of Russia, not Ukraine. It was a pure political move to increase his own power in the central comity by Khrushchev to move it into Ukraine. This was done without any asking the population. Then it defaulted to Ukraine because of the way the Soviet Union broke up.

It should be part of Russia. Now the way it happened is certainty sub-optimal and warrants a political response and negotiation but the US should not exclude recognition of Crimea as a diplomatic option.

> Yeah we do cyber attacks and many other fairly inexcusable things. But to claim USA is the aggressor in this cause is highly debatable.

I was playing devils advocates. But seriously, if you are Russian its easy to construct a case.

And from my Swiss perspective who the good guy is, very much depends on the situation, I don't just default to USA good, Russia bad. Both governments do a whole lot of evil stuff.

> And I’m not saying appeasement will cause ww3, I’m saying it’s had a past history of not working in a spectacular fashion, so it’s weird to default to it.

But that's the point. The US did not 'default' to it. The US took major actions that were directly against opposed to multiple signed treaties with Soviet Union and Russia. When Russia tried to argue the point, they were dismissed and ignored. Despite strong objections by Russia and multiple red lines, NATO still went ahead with expansion and would have continued if Russia had not responded.

What would the US do if Russia attempted to put a nuclear cover over Cube, Mexico and Hawaii? I think we know.
Indirection is the price of scale. As a system grows, you need breaking points, boundaries. These often result in adding one more level of indirection.

But we're also moving in the other direction, for example Java is introducing value types ("inline classes") and low-level memory allocation/manipulation APIs. That's a big step for a language that started with the idea of everything is an object (and an object is an indirection).
>Financial elites have been gambling for decades. They seem to be really upset that the plebs now can also do it.

Hardly. They make money from the commissions
> I find it interesting that these are missing in the Nakamoto Institute's quotes on scaling.

Here's a source directly from Mike Hearn

https://bitcointalk.org/index.php?topic=149668.msg1596879#ms...
I did write a go application that gives full querying capability to the clients for their own Sqlite3 instances, maybe I should open source it (Just wanted to see if there's any interest).
It was not useless and worked very well because you had an arbiter. If I did not give the money to him, Local Bitcoins would release the escrow back. Indeed, resolving a argument could get messy. But it worked well enough.
There are way more things that can go wrong, not just drivers.

I've run a ThinkServe machine with CentOS and ZFS for several years. Kernel and ZFS updates would break it regularly, requiring tinkering to make it work again (my favorite: zfs#8885).

Nowadays I prefer when somebody else did the integration work.
Yes it's the definition of conflict of interest. It's insane that this is allowed
The growth of Dubai is crazy, as well as most major Chinese cities. What are some interesting, less obvious things to look at with this feature?
DJI Air 2s
Because they sell Apple TV that do not require your phone to us Apple Fitness +
This doesn't help with optimistic UI updates though.

The article is less about remotely executing SQL, but more about having a relational data model as a cache in the frontend.

However, when sending the query through to the backend on a cache miss, would be useful to only allow queries that have been extracted like so.

Its similar to how Apollo does query [caching][1].

I really like it!

[1]: https://www.apollographql.com/docs/apollo-server/performance...
Why doesn't Apple just buy Peloton and add it to the vast network of Apple products that they can slowly kill and release a better version like they did with Beats?
It only 'really failed' Puerto Rico.

Airlines have similar rules, yet I never see people grousing that you can't take an Air Malay flight from Chicago to LA.
Yep. No @#$@ing way am I going to pay a rental fee on a device I just bought, whether or not it has a TV built in.
A problem like a traffic jam needs systemic coordinated action though to be able to solve. Complaining about the lack of perceived ability to get everyone acting is legitimate.
Yes he offered but I don’t use email and cannot contact him that way.
I get the reference, but it seems like either a non-sequitur or a joke I'm not getting.
I just finished a 300 page book on Dart which took all night to read. I've been hunting for an alternative to RN and heard about flutter and it definitely is as close as you're going to get. Overall, Dart gets the job done with the modern features you would expect and Flutter reminds me of SwiftUI. So I definitely have to second Flutter, but I guess the proof is in the pudding.
My thought was that they (and immediate family) would have to put their assets into a blind trust could be disolved upon their leaving office. They should have no ability to make personal investment decisions while they are in a position of such influence and insider knowledge.
Ad networks often show us ads we don't want to see, and don't show us ads we want to see.

One of the problems I see with is FLoC is that giving the user direct control over their cohort ID.
Starcraft/Starcraft 2
Among Us
Chess
Poker

I sorta like Rimworld too, but more of a resource management with a bit of strategy.
If anything, this is quite welcome as it allows for plausible deniability if one's private nudes were leaked or other such matters.
We've done this with octo-cli and OpenFaaS now.

Legacy codebases are hard to remove because it's difficult but once you turn every SQL call into an HTTP call... the remaining part is the logic which can be rewritten into something more modern.
When in the private sector those of us that even get a whiff of MNPI are told we can’t trade individual names at all.
We are currently settling for something in between: EQL (using Pathom resolvers)

This gives front-end devs the flexibility of GraphQL, composability for free (EQL's DSL is just a data-structure you can manipulate easilty) and is database agnostic.

In fact, Pathom makes it easy to link different datasources and make them available in a uniform way to the front-end devs.
All the while, resolvers (running on the backend) keep control and prevent malicious clients from doing harm.

Same issues you would have with GraphQL though: N+1 queries need special consideration when writing resolvers.
You can say the same thing about ant colonies. I think it's probably just what anything that groups and branches around resource deposits looks like. If I recall slime molds are optimal planners regarding surrounding resources so it just sounds like a natural optimality to me.

I'd be more interested in what you think it "should" look like for an "advanced" species besides optimal?

Looking at it is disparagingly is weird to me, when the conclusion is maybe humans in aggregate are optimal with regards to finding and using resources to grow.

Not that we're growing unbounded either because that would be bad, we're in population decline across many major nations right now and are working towards a greener future in multiple industries to avoid resource collapse.

The level of doom and gloom and misanthropy is generally unwarranted if you look around at the steps we're taking to better ourselves as a species and every time I read things like this I can't help but think people revel in the supposed helplessness of our potential destruction and inability as some perverted pleasure.
> It's all obvious in retrospect... isn't it?

Not sure. In fact, I invested in bitcoin some 8 years ago, just like Brian Armstrong I was optimistic about bitcoin not as a popular speculative eccentric store of value, but as the standard for digital money that would drive substantial portions of global finance.

That hasn't materialised at all. If I could see the number of merchants accepting bitcoin and their effective average turnover paid in bitcoin, the number of business to business transactions in bitcoin, the amount of loans being issued in bitcoin, remittance etc, 13 years after launch, today... I'd certainly not have invested in bitcoin or Coinbase, in retrospect, with the information today.

That's the crazy thing, and even with this new attention, I still haven't seen anything exciting around the corner. All price increases are now purely speculative, instead of changes in functionality or use.
Rules of online social engagement I wish I knew in 1999
If true, an interesting move; failing to account for the possibility of the iPad dominating the tablet market essentially sunk Peloton President William Lynch's run at Barnes & Noble when they invested too heavily in the production of first party Nook tablets. Those Nook tablets were actually a great product, far superior to the Fire tablets Amazon was eventually able to muscle in to their own niche, but it didn't ultimately mean that much in the face of Apple's domination.
A bit later. Not now for sure. I'd love to see the core APIs completed first.
This is brilliant. This should be illegal. CEOs and anyone with insider info have trade "windows", or are put onto "program" trading. This should absolutely be happening to these servants.
I don't see the point ... One can easily spell any french word, there are hard rules.
I think it was more of they were already going to refurbish the ship. I doubt extending a brand new ship would make any sense.
I've gotten some good mileage out of sqlite-utils[0] lately. It and it's parent project datasette[1] are a wonderful contribution to the sqlite community.

[0] https://sqlite-utils.datasette.io/en/stable/cli.html#transfo...
[1] https://datasette.io/
Eh, some explorers do show op_return data in ASCII, so you could definitely see messages in a browser without too much work or a 'custom client'.

From an example thats in the article, click on details and look at OP_RETURN: https://mempool.space/tx/0540b5dda23ee870330c6b1e18a88c592cf...
If you want to get rich go into politics.
man, I did this when I was a little kid. used the collect call in NYC to call friends to come open the door.
> I sometimes think that it is a valid mental model to think of us as not much different from ants in a hive who think they possess more control and freedom than they do

I think it is the opposite. We are different from ants, and have a lot of control and freedom, so we know that if others will not make the sacrifice, why should we?

In an ant colony, I imagine the orders are being given top down and they do not think about what others are or are not sacrificing.