I'd like to use an embedded database management system within my Java app that should store all data in one single portable file.
I know already that H2 and SQLite databases seem to fit my needs, but I'd like to see if there are other solutions that are embeddable and are able to save the whole database in a single-file.
I don't insist on relational databases, NoSQL solutions are welcome. For example, if ElasticSearch or Solr could be tweaked to save data in a single file, that would be fine, too.
The solution could include both open source software or commercial software. If it's OSS, it should allow commercial use. The license costs of proprietary software should not be higher than USD 10.000 and the license should permit to distribute the database engine along with my app for an unlimited number of installations.
The database engine should be able to run on:
- Windows, Mac OS and Linux systems as well as
- Android and iOS ("nice to have").