Possibly heretical view: SQLite (with foreign keys) and WAL mode for concurrent writers and filesystem snapshots for backup. Do that until you can't, that way

Possibly heretical view: SQLite (with foreign keys) and WAL mode for concurrent writers and filesystem snapshots for backup. Do that until you can't, that way you'll actually have some idea where your database is going before you pick an actual server.