6 ms·
Ask HN: Any other databases on single disk file like SQLite exist?
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)?
- the_autobot 5y agoThere's duckdb which seems very similar. I haven't actually used it for anything yet so YMMV.
- robertknight 5y agoWhat are your requirements (data model, non-functional priorities, data size, data types)?
- cliffordfajardo 5y agoNothing 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 https://github.com/rqlite/rqlite) and [HN:Consider SQLite](https://news.ycombinator.com/item?id=29727707 https://news.ycombinator.com/item?id=29727707)
- pwg 5y agoBerkeley DB and variants: https://en.wikipedia.org/wiki/Berkeley_DB https://en.wikipedia.org/wiki/Berkeley_DB
- billconan 5y agohttps://ejdb.org/ https://ejdb.org/ standalone nosql
- andrewl 5y agoFirebird, maybe: https://firebirdsql.org/manual/fbint-structure.html https://firebirdsql.org/manual/fbint-structure.html
- thijsvandien 5y agoFirebird 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 5y agoApache H2, and Apache Derby. There's quite a few that are available if you only need them to be supported on the JVM.