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