-
I like the idea of SQLite, even more with tools like Litestream [0] when the database is replicated - in this case, just continuously backup to S3 (and from S3 during startup). I found often for my and my friend's hobby projects, single server instances can be optimized easily enough to handle small and medium traffic. In such cases, I don't even bother with a fully managed database because SQLite covers all the needs and when it's located on the same machine as the server is extremely fast [1].
[0] https://litestream.io/
-
InfluxDB
InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
-
SQLite is not competing with RDMBSes. SQLite is competing with fopen().
There are of course solutions which wrap this fopen() replacement in a network/cluster-aware tools, e.g. https://github.com/rqlite/rqlite - these are competing with postgres.
-
uDjango
A single file Django micro project created for demonstration purposes to be used in the same way as other Python frameworks.
https://coltrane.readthedocs.io/en/latest/#other-minimal-dja... has a list of a few options, but the most recent is https://github.com/pauloxnet/uDjango.
-
I haven't tried it with git pluggable diff tools yet, but I wrote a tool that lets me convert a SQLite database into a bunch of plain text files so I can manage them in git: https://github.com/simonw/sqlite-diffable
