2 ms·
HSQLDB does that, but 1. ew, Java, and 2. there are reasons people don't do that. The major problem with text formats is that it means either you have to rewri
by o11c 3y ago
HSQLDB does that, but 1. ew, Java, and 2. there are reasons people don't do that.
The major problem with text formats is that it means either you have to rewrite the whole file on every change ... or else you have to append arbitrarily and be able to survive that (if you're committing to git you probably are capable of dealing with the storage, at least).
If the former is feasible for you (because incremental updates are rare), just use your favorite database's load/dump around every session, and do some fsync testing (or just keep full backups).
If the latter compromise is acceptable there might be something you can do with streaming logical replication on some DBs, but again there's a reason people generally don't.