News for hackers. Stuff that matters.
Re:Do you even need a database? by oliviergg on Wednesday April 15, 2026 @01:25PM (#47782240)
Please … Every few years the pendulum swings. First it was “relational databases are too rigid, just use NoSQL.” Then “NoSQL is a mess, just go back to Postgres.” Now: “do you even need a database at all, just use flat files.” Each wave is partially right. But… each wave is about to rediscover, the hard way, exactly why the previous generation made the choices they did. SQLite is the answer to every painful lesson learned, every scar from long debug night the last time someone thought “a JSON file is basically a database.”
Re:Do you even need a database? by debo_ on Wednesday April 15, 2026 @01:42PM (#47782537)
Michael Stonebraker used to write long, scathing critiques of modern data storage/retrieval fads, and how they were forgetting important historical lessons.

They were terrific reads; his writing on object-oriented databases was the most fun technical reading I did in grad school. And I even learned a lot!

Re:Do you even need a database? by kevstev on Wednesday April 15, 2026 @03:58PM (#47784420)
Where was this? I would like to read. I have read his papers and they are great, and usually surprisingly readable.
Re:Do you even need a database? by debo_ on Wednesday April 15, 2026 @04:04PM (#47784505)
It has been a long time, but I think we were reading out of various editions of the Red Book

http://www.redbook.io/

Re:Do you even need a database? by goerch on Wednesday April 15, 2026 @01:43PM (#47782544)
Yes, but you are probably a bit too polite. And I'm not sure how to do justice to SQLite, Postgres and my new favourite toy DuckDB.
Re:Do you even need a database? by mdp on Wednesday April 15, 2026 @02:48PM (#47783473)
I've been really happy with DuckDB, and I love that fact that it can operate directly on things like JSON an JSONL. It's become my data swiss army knife.