What are other databases like SQlite, which dont require spinning up a server & save data to disk instead? Does such a thing exist for specialized databases on a single disk (elastic search etc)?
Ask HN: Any other databases on single disk file like SQLite exist?
1–9 of 9 posts
Re: Ask HN: Any other databases on single disk file like SQLite exist?
#2What are your requirements (data model, non-functional priorities, data size, data types)?
Re: Ask HN: Any other databases on single disk file like SQLite exist?
#3There's duckdb which seems very similar. I haven't actually used it for anything yet so YMMV.
Re: Ask HN: Any other databases on single disk file like SQLite exist?
#4Berkeley DB and variants:
Re: Ask HN: Any other databases on single disk file like SQLite exist?
#5What are your requirements (data model, non-functional priorities, data size, data types)?
Nothing super particular at this time, but generally:
In the past I've wanted to spin up something like ElasticSearch in a desktop or mobile app. I really love the SQLite model of a simple file. This type of just dealing with a file has grown in popularity recently. See [rqlite](https://github.com/rqlite/rqlite) and [HN:Consider SQLite](https://news.ycombinator.com/item?id=29727707)
Re: Ask HN: Any other databases on single disk file like SQLite exist?
#6https://ejdb.org/
standalone nosql
Re: Ask HN: Any other databases on single disk file like SQLite exist?
#7Firebird, maybe:
Re: Ask HN: Any other databases on single disk file like SQLite exist?
#8Apache H2, and Apache Derby. There's quite a few that are available if you only need them to be supported on the JVM.
Re: Ask HN: Any other databases on single disk file like SQLite exist?
#9Firebird, maybe: https://firebirdsql.org/manual/fbint-structure.html
Firebird can be used either with or without a server. It's also possible to switch from one to the other while keeping the exact same database file.