skysight-inc/HackerNews huggingface dataset:
When I learned there was a DHS Privacy and Integrity Advisory Committee a decade or so ago, I took a look at the members who were 'advising' congress on tech legislation, perhaps even writing the laws. They were a motley collection of privacy lawyers(don't assume pro-privacy lawyers), ex-industry lobbyists and a few token academics, for good measure. One of the early members that still stands out in my mind was the lead attorney for the Gator Wallet scourge. Is it any surprise our laws do the exact opposite of 'protect privacy'? What was once illegal and eschewed, is now ordinary & embraced. Like a MS exec once said to the DefCon audience (circa ~ 2003), "Surreptitious spying is all the rage! Everyone's doing it."
If you consider the design space, “resetting the state every time” is exactly how basically every other “fiddle” app works. If JSFiddle were just duplicating your code into the javascript VM each time you hit run, you’d be overwhelmed with pointless errors about duplicate identifiers immediately. The idea is to let you build up a reproducible, shareable outcome. So, if you want to share a demo of how you might create a few tables and perform join queries, you can easily and interactively assemble that if the state resets to zero each time you run the set of queries.

It’s probably a completely different way to use the application than you were considering if you don’t see the point of it, but I’ve actually used another tool exactly like this in a job interview that involved testing SQL knowledge.

Would it be useful for manipulating an existing SQLite database? Probably not. (Unless it reset to the state the database had when you imported it, instead of clearing it? It might work…)

> However, the app now has a button to nuke the db.

Awesome!

> In related news: if any text in the input field is currently highlighted, only that text is submitted via the Run button or ctrl-/shift-enter.

That would certainly be helpful towards the use case I’m describing, although I can imagine that UX being difficult to discover on purpose (and confusingly easy to discover on accident when you get weird errors as SQLite tries in vain to execute some invalid SQL fragment you accidentally had selected before you hit the run button).
I realize Spotify was started in Europe but they opened an office in the US in 2010. That's 8 years before they went public. And within a year they had a mega office. They were regularly in the NYC real estate news for the next couple of years after as well for adding and outgrowing existing office space. Statista shows the US presence has almost double the Swedish employees.[1]

[1] https://www.statista.com/statistics/813906/spotify-number-em...
Where do you gather the floor plans for each building? I've had similar ambitions but didn't know where to start
title truncated: thousands of workers demand salesforce stop working with NRA
> By accounting for every moment of their working lives, and defining each moment as either “billable” or, regrettably, “non-billable”, lawyers were being tugged inexorably towards an unhappy, unhealthy attitude to the way they spent their time. Not all lawyers, of course. And not only lawyers, either.

We fetish precision at the expense of humanity.

Organic life is messy, sloppy, and imprecise. Wisdom is understanding that diminishing returns sets in at the 80% solution. We don't need to Automate All The Things until the Orwellian social credit system leads to complete demographic cratering and the human race dies off.

As XKCD points out[1], you're OK at around four significant figures. Breath.

[1] https://xkcd.com/2170/
"negative engineering" is when you delete things :)
Thank you for putting software engineering into the soft skill bucket, but I think the word soft skill sort of means social/interpersonal skills. What you describe is more the difference between open and closed problems.
To be fair - many people in the billionaire class don’t sell any of their shares. The reason being that they can open pledged asset lines using those stocks - and never have to pay taxes as long as they never get called on their lines.
Canadian indie ISPs warned CRTC decision would kill them
>Great product positioning. I hope their follow-up is better than typical Google.

Looks like AlloyDB is a result of the influx of Oracle and SAP database people into GCP.
Can they do that? I mean they could buy things on the open market sure, but force sellers to sell (at presumably a lower price since if ambulance manufacturers aren't winning bids now they probably aren't paying the most) to particular consumers and not others.

People might start asking who John Galt is.
Soft technical skills would mostly be the architect who creates structure to the software project, or the scientists who solves previously unsolved problems. Hard technical skills would be things like knowing a specific programming language, mastery of a framework, or having a degree, or other things you can put down as a checkbox.

What you are talking about are people who mix hard technical skills with social skills, that is also valuable but it is a different thing. Soft skills as a concept was invented to show that even skills you couldn't put in a checkbox could also be valuable, and is mostly for HR because for them it is easy to just rank candidates by which boxes they check.
> In what use cases would it make sense to transfer the entire db file over the network, then pluck out the relevant rows into JSON, versus just doing that server side and transfer the JSON back?

Lots of dbs are small - a few hundred kb, maybe a meg. Many sites, by comparison, serve _megabytes_ of CSS and/or JS (minified!). i just hit imdb dot com for example's sake: 7MB of Stuff to load the front page, with something like 1MB of it being JS code.

In addition, this type of app permits the user to inject a copy of a client-local db with no network traffic. In developing fiddle we've seen it work with dbs of approximately 80mb (haven't tested anything larger), but those limits are going to be very browser-/environment-dependent.

> Is the trade off that the server does less computation, but then pay for network bandwidth fees?

That's one tradeoff. Another is less coding effort needed to implement the client/server halves of the interaction. In conventional apps, every client-side operation on data results in a call to a server-side counterpart of that client-side operation. That needn't be the case for this style of app. For some apps, all of the code can now be client-side. For some, data might be synced/pushed to the server after changes are made, but there need not be a continual back-and-forth between the client and server.

Another point is data privacy: this sort of app need not send the db to anyone. The db can stay entirely on the client, so they can use private databases without any concern that the server might squirrel away a copy or leak a copy to other folks.

That said: the wasm approach, with a client-embedded db, is most definitely not a one-size-fits-all solution. It will serve a certain niche of applications, but not the majority of web app data needs.
I think you missed a step:

metal coin usd -> paper usd -> digital usd (closed, permissioned system) -> crypto usd (transparant, permissionless system)

The jump is a lot less between digital and crypto should be small.
I think you'll find many mathematicians agree with it.

For example, The Abel Prize [1] does interviews with their award winners every year and quite often they are asked about this question, and most of them agree that as a mathematician your peak "mathematical powers" so to speak and energy are at their highest in your 20s and 30s, while afterwards you have to rely more on experience to make up for it as you grow older.

[1]: https://www.youtube.com/c/TheAbelPrize1/videos
We've built upon the collective knowledgebase, true. But it is as hard for a person today to do arithmetic and logical reasoning as it was in the 1800s.
Ones without aluminum based ingredients - there was some science that indicated aluminum caused Alzheimer's but I think the evidence has shifted towards other things enough that they're fine. The alternatives were brands like Tom's that just didn't function like the real thing.
I think a better way to look at stuff, is to think of the Pareto Principle or the 80/20 rule.

I would guess, with deliberate practice and hard work, many people are able to hit the 80th percentile of skill at something. Going beyond that likely takes some natural talent or luck.

The thing is, that getting to the 80th percentile in multiple areas makes you more valuable, than if you just spent the time getting to 95th percentile in a single area.

So if you 80th percentile programmer, maybe you shift and study writing and communication and you become an 80th percentile writer. Now as an individual contributor you are 96th percentile (1 - (.2*.2)). You study some management and work on becoming an 80th percentile manager, and now you are a 99th percentile employee (1 - (.2 * .2 *.2)).

Programming skills are for the most part table stakes. Once you reach a certain level of proficiency, work on communication and leadership.
What does the upstream means?
true, revolutionary (compared to even digital usd) as in It shouldn't require a third party (aka bank etc) for 2 individuals to transact.
Effects of Saffron Extract on Mood (2020)
How did the timeline work with Vertica and Paraccel? I know Paraccel was around the same time, but I'm not sure who was really first, or if it's even an important distinction.
I was an exchange student in rural Japan in the early 2000’s and I think that was the final moment you could see the world like this. There were no smartphones yet or ubiquitous internet. I had some guide books but they were very general.

My host family didn’t speak English at all. Every day was like a puzzle: what does this building do? What are these tickets people have? What is this strange food, is it even food? How does this toilet even work? My only contact with home was an email I sent every month, because I had to go to a special place a different city that had internet. There were so many snacks, books, products, clothes, TV shows that no one at home had ever heard of.

I went back in the 2010’s and everything had changed. The security of your phone makes the feeling of isolation, risk, and adventure disappear. You can look everything up, it’s been documented, you’ve heard of it already. You’re still texting and talking to your normal friends on social. Everything is everywhere, you don’t really detach from home.

It really was a special window of time.
Too much.

You fix a PSU cause you know what you're doing and have the time, not because it's economical to do for someone else
Not really, no. The founding colonies were mostly corporations - the startups of the gunpowder era. The religious outcasts came because they were ostracized and chased out for being assholes, but were only a small number overall. The actual revolution was mostly about taxes, and a lot of distrust in autocratic rule from on high.
It is hard to overstate how poorly optimized the Postgres architecture is for modern analytical workloads on modern hardware. It is an OLTP engine with 1990s design assumptions. You can modify it heavily to make it adequate for analytics but it won't be anything close to optimal due to architectural limitations. And I say that as a big fan of Postgres.

There is a longstanding heuristic that, outside of the workload for which Postgres was designed, a state-of-the-art database implementation will be 100x faster on the same hardware. That heuristic is well-grounded in reality in my experience; I often measure new database kernel implementations relative to Postgres. Postgres is still great for classic OLTP workloads and you will find that the gap is smaller there. For analytical processing, 100x gain is pretty straightforward.

No one should read this as reflecting poorly on Postgres. Database architecture and the hardware it runs on has evolved enormously in the decades since Postgres was designed. Most people have no sense of just how fast and scalable a modern database kernel is compared to the designs from 20+ years ago.
Divide that by 10--that's Andy's 10 year RSU grant, not his annual comp.
>One possible explanation for the complexity and heft of Apple’s self repair toolkit is that iPhones are intricate devices, ... There is nothing Apple can do to make such repairs quick or easy.

ESH, The tools are not to fix the phone, they are to open the phone. Replacing a battery is not an academically challenging proposition. I'm not altering the hardware, I'm playing with legos.

The difficulty arises because Apple has glued the legos together, and John Gruber thinks that this is an absolutely mandatory feature of the device for, as far as I can tell, the reason of being having paid to argue this, or worse, parroting someone who was paid to argue it.
A society that has individuals whose behavior (in a retribution-based society) calls for retribution will also always be unhealthy. Avoiding retribution won't heal it.
I hated the rioting of 2020 as much as the next guy, but it’s worth remembering that the bad apples doing the rioting because another group of bad apples kept killing black people and getting away with it.

You do have a point about the flattening of everyone who came to Washington on January 6th down into a caricature of the worst of them. That happens a lot in the media these days. See also, protestors, Antifa, Black Lives Matter, etc. One side highlights the worst of each group, and the other selectively highlights the best.

Sucks, but apparently everyone decided we have to pick sides about everything, and stick to them at all costs.
There are so many Go and Rust TUI apps that I've used that look so much better than this. This reminds me of something straight out of MS-DOS.

I've also yet to find a single .NET application that wasn't sluggish on Linux. Jellyfin, Emby, Jackett, etc all take like 5 seconds to start while Go apps take a few milliseconds.
I mean, considering that those who don’t know it are doomed to repeat it…
The 50-Square-Mile Zone Where the Constitution Doesn't Apply
Path trace of continental drift for chosen point, across some time window?
This is inspiring. It reminds of DHH's idea for Rails 7 as a one person framework to compress the complexity of modern web apps (https://world.hey.com/dhh/the-one-person-framework-711e6318).

Replicache does the same thing but for a different domain from Rails: local-first web apps.

Tools like these will be appreciated during the forthcoming economic slowdown.
Ford does not need to iterate and refine its way to a truck that is suitable for real work, they've had that down for a long time. Plus they have a massive network.

Tesla can certainly get a hold in the pickup market but man do they have one ugly truck.
as in you run the bitmap through QOI and then compress that output with LZ4? Or am i misremembering how QOI works and it uses LZ4 internally? PNG uses LZ, doesn't it?
I also had the same problem. It's a bad lead in.
Some firms take fixed-fee work, but it is looked down upon at most top tier firms. When the economy tanks, all firms open up to these "alternative billing arrangements".
No bank involved, but for every transaction you burn down an unspecified amount of the Amazon rainforest. But hey, you win some, you lose some.
It is not necessary to have a single monopoly company if our goal is to distribute messages globally.

Certainly not easy, but one would think that HN would have some understanding of the powerful capabilities of advanced types of protocols.
What I really want to know is, why is this flagged? HN full of low quality BS semi-technical Medium articles, but once something about crypto comes up it gets flagged.
There might be some things between isolated Micronesian island and queueing behind 20k people to walk around the Taj Mahal.
Shit like that should really be illegal.
Databricks/Spark is overpriced garbage for Python-toting data scientists/engineers/analysts who don't know how to model data or write SQL. Exactly like Hadoop was 15 years ago for the Java-toting data scientists/engineers.
Meh, I keep multiple electron apps, node processes, and chrome windows and tabs open at the same time, and they're really not at all CPU intensive (except for node running tsc builds or tests). It's the RAM usage that is annoying, and even that isn't too terrible.

Edit: of course, I'm running swaywm on linux, so my environment is generally pretty light as it is compared to Windows.
They can be helpful if you have services that need to call other services on behalf of a user request.

For instance, user A calls Product service for Product information but that response also includes Recommended Products and Advertisements from those two services. Product service can pass the JWT from the client to Recommended Products and Advertisements which removes the need to establish trust between those internal services (since authentication and authorization info are just passed around from what the client provided).

You can also use them in federated auth schemes where the issuing system is separate from the recipient. I think the use cases are pretty similar to SAML for this type of system but with a smaller "auth token" size.

Just because you're accessing a database on a request doesn't mean you're accessing the database that stores the authorization and authentication info.
I’m fairly sure the bog-standard consumer Rocket Lake processors had AVX-512.
Im not sure they hire or anything but freecodecamp changed my life for the better and I think they also helped a lot of people out there, some of them are friends of mine.
China offering ten nations help to run their cyber-defenses and networks
Clearly the 0.01% of people who have even opened a PSU are going to chime in and say it’s necessary.

I’ve torn mine apart and replaced fans in them and such but I’ve never had to resolder any parts onto them. If a PSU dies - it tended to do it violently and was so cheap that it wasn’t worth doing it. All the name brand ones I’ve had never had any issues and same for the dozens of other people I knew. (Or computers I worked on or built or sold to others… or when I did IT and saw literally thousands of computers…)
Psychology is more like a set of disciplines. Some hard, some soft. Some real and some woo. Lots of great stuff to learn from cognitive psychology, especially for the AI-interested in this forum. Evolutionary psych, though, is a bunch of post facto "just so stories," with my apologies to Kiplng for the comparison.

And no, we can't stop seeming to clam no true Scotsman. That's because there are things masquerading as legitimate. And we're on HN. So any time someone points out the divide, those accusations are inevitable.
How virtual hearings opened Indian courts to public
> You would need a nation to adopt it

That's what I thought until El Salvador did that, although I don't know much of the details there. Did they not really adopt it? I would guess the economy would have tanked with the recent drops.
Cookies are a storage and transport mechanism and JWTs are signed JSON blobs. You could put a JWT inside a cookie.
I think it's more of an amyloid-B as scar tissue thing. Whats causing the insult to create scar tissue in the first place, and if the body didn't make amyloid-B, what worse thing would happen?
> I mean it's not like most consumer hardware has to be on the latest nodes.

Maybe developers should take some responsibility and stop fucking writing code that's slow as shit and unusable on anything past their company-paid for macbook pros.

In an ideal society programmers would be sat down and given a seven year old mid-range laptop and threatened that if their program lags in the slightest they would be fired and blacklisted from the industry.
> If you consider the design space, “resetting the state every time” is exactly how basically every other “fiddle” app works.

This app's design space is exposing the sqlite3 shell app via the web, not to emulate every other fiddle environment. sqlite shell app's doesn't (with very good reason) behave that way and the fiddle frontend is just passing state between the user and that app.

> The idea is to let you build up a reproducible, shareable outcome.

Because this app has no server-side state, we have no way of _sharing_ the outcome. Large fiddle sites give you a short URL which refers to state in their server-side storage. This app completely lacks that (and we're definitely not going to add server-side state to this app). What we _might_ eventually do is offer the ability to base64-encode the SQL into a URL argument which can be shared, but URL length limits are very server-dependent so it would be impossible to portably share "large" fiddles that way.

> (and confusingly easy to discover on accident when you get weird errors as SQLite tries in vain to execute some invalid SQL fragment you accidentally had selected before you hit the run button).

There's a comment in the initial example SQL explaining that feature, so it'll _hopefully_ be noticed by people new to the app. (Noting that that's not, as of this writing, yet deployed on the production server.) Another feature under consideration is having it intermittently spit out random tips/reminders to the output area (when the db is not working - the app knows when that's happening), and the exec-selection feature would be one such tip.
Ultimately the MWI is saying “believe the math - configuration space is physical reality”. So you are on solid ground when you give arguments that are mathematical, however the metaphysical stuff about the self is basically talking past the MWI, which specifically does not acknowledge that as valid form of argument. I also agree with the post above that arguments about “branch counting” are bunk because you cannot count in a continuous space (see: banach-tarski and related paradoxes).
Whether ROI is positive or negative is not the correct thing to consider. Opportunity Cost is more important. Why would they create an Elixir client if there is something else they could do which has higher positive impact?
What deems the ERP necessary that you can't do custom?
it's the capital requirements or capital to risk weighted assets ratio that restrict lending, not reserve requirements. reserve requirements are to protect runs by depositors and capital requirements are to protect the bank against bad loans.

at the end of every month and especially every quarter the bank submits its capital ratio and a bunch of other calculations to the regulators. if the ratio isn't good it has to increase capital reserves. if the ratio is good it can do share buybacks and dividends.

https://en.wikipedia.org/wiki/Basel_III
Probably the JIT, I expect this will improve with ahead of time compiling in the newer dotnet sdks.
The key is in "derived from". Very few people would say NT is derived from some random drivers that nobody at Microsoft had a hand in writing. Taking existing code and having it form the foundation of a new kernel and claiming it as all closed source is quite a bit more obviously derived from that existing code open source code. "Derived from" is the core concept in the GPL; it actually doesn't use the word "link" at all.

Additionally they didn't publish the source to even the GPLed drivers they shipped as binaries, before even talking about the core hypervisor itself.
I'm always surprised how charming this kind of thing is. Inspired to do something like this too.
The NYT review[0] of the tools included this funny bit:

>The process was then so unforgiving that I destroyed my iPhone screen in a split second with an irreversible error

Which translates to "I forgot to remove the screws holding in the screen before I tried to pry off the glass".

[0] https://www.nytimes.com/2022/05/25/technology/personaltech/a...
Here’s to hoping for titanium rated power supplies becoming the norm like GaN chargers - and for a reasonable price!