News for hackers. Stuff that matters.
Re:SQLite Index Visualization by graemep on Thursday November 14, 2024 @12:39PM (#42138785)
> SQLite isn't competing with other databases. It's competing with JSON and XML files for persistent storage

It competes with both. its clearly used for local persistent storage. SO are quite a lot of other things. It also competes with other RDBMSes where a separate server process is not a requirement.

That does mean it serves very different requirements, its just that its use case are a lot wider than just replacing JSON and XML files and similar.

Re:SQLite Index Visualization by threatofrain on Thursday November 14, 2024 @03:42PM (#42140986)
> It also competes with other RDBMSes where a separate server process is not a requirement.

If you casually list off the top DB's either by usage or by recent hotness then almost all of them will have a server, but you'll also find they're basically all not embedded DB's with exception to RocksDB.

Re:SQLite Index Visualization by e28eta on Friday November 15, 2024 @10:14AM (#42147626)
I’m familiar with this embedded DB, used in Quickbooks desktop: https://en.m.wikipedia.org/wiki/SQL_Anywhere

So… large usage, but probably not very high on the hotness scale

Re:SQLite Index Visualization by akx on Tuesday November 26, 2024 @01:03PM (#42248153)
https://duckdb.org/ begs to differ.