Ask HN: Any other databases on single disk file like SQLite exist?

8 points by cliffordfajardo 4y ago ↗ HN

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)?

8 comments

[ 3.5 ms ] story [ 24.2 ms ] thread

robertknight 4y ago ↗

What are your requirements (data model, non-functional priorities, data size, data types)?

cliffordfajardo 4y ago ↗

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)

the_autobot 4y ago ↗

There's duckdb which seems very similar. I haven't actually used it for anything yet so YMMV.

pwg 4y ago ↗

Berkeley DB and variants:

https://en.wikipedia.org/wiki/Berkeley_DB

billconan 4y ago ↗

https://ejdb.org/

standalone nosql

andrewl 4y ago ↗

Firebird, maybe:

https://firebirdsql.org/manual/fbint-structure.html

thijsvandien 4y ago ↗

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.

Something1234 4y ago ↗

Apache H2, and Apache Derby. There's quite a few that are available if you only need them to be supported on the JVM.