Hacker Newsnew | past | comments | ask | show | jobs | submit | UltraSane's commentslogin

SQLite also gets really slow at around 50 million rows.

Seems fine at billions of rows in my experience.

what are your pragmas?

:cache_size 1562

:page_size 4096

:journal_mode "WAL"

:synchronous "NORMAL"

:temp_store "MEMORY"

:busy_timeout 5000

(Synchronous FULL in context where it matters)

But, it depends on the shape of your data, your indexes, how much of the data you care about is filling up a page. If your distribution is more even you sometimes need more cache than a more Pareto distributed data set etc. Things like not caching prepared statements costs you more (you should almost always be caching prepared statements per connection with sqlite).

You have to give things more thought at a billion sure. Partial indexes are your friend. You'll also want more cache to prevent thrashing etc.

- https://andersmurphy.com/2025/12/02/100000-tps-over-a-billio...


These articles are weird because rationing consumption based on price is one of the most fundamental concepts in economics.

Starship is currently a money pit.

I truly do not understand why anyone believes anything Musk says anymore.

could it be that those people don't actually believe him and just appreciate the genuine shit-show he puts up enabling them to laugh at people who get sad about what he says, and their eagerness to believe

“Pretending” to be a fan of a troll because he tries to troll people who think he’s a troll is a good thing…?

They should really hire him.

A small increase in exponential growth will have a huge effect after 400 years

Comments like this by people who know exactly what they are talking about are why I love Hackernews

Maybe he strongly supports UBI or a national dividend and understands how automation makes these much easier.

The author explains his opinion in a blog post, and it's not that: https://www.jasonwu.ink/signals/2026-05-27-permanent-upper-c...

It's simply: saving yourself (by getting rich or whatever) before AI puts us all out of a job is not good, because the majority of the world will suffer and that's not good for anyone.


CPU sleep states are normally disabled on servers because CPU demand can increase faster than the CPU speed can increase. It is much better to have a $20,000 CPU running at max MHz at all times.

They go into extreme detail about DNSsec root key security

https://blog.apnic.net/2021/10/12/dns-security-and-key-cerem...


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: