Hacker News Reader

> 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.

View on HN

> 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.

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

https://duckdb.org/ begs to differ.

Reply on news.ycombinator.com