3 ms·
The - now free - Datomic (https://www.datomic.com https://www.datomic.com) or the open source XTDB (https://www.xtdb.com https://www.xtdb.com) can provide insta
by onetom 3y ago
The - now free - Datomic (https://www.datomic.com https://www.datomic.com) or the open source XTDB (https://www.xtdb.com https://www.xtdb.com) can provide instant access to your data at any point in time. Even to different points in time within a single query, without the concept of a "DB restore" operation.
So if your main use-case of restoring a DB from the past is to run analytical queries on it, then you should probably consider these solutions instead.
These systems rely on other databases to store their data, so they inherit the backup capabilities of those databases.
Would be interesting to consider, if they could benefit from using SQLite as a backend instead of H2DB/DynamoDB/Postgres or RocksDB/LMDB/Xodus/JDBC.