aergolite

Postgres is better in the I-need-concurrency case -- I think it's the greatest RDBMS that's ever been made and would like someone to prove me wrong some day. SQLite's amazing too though, when you don't need concurrency (and most websites don't really -- especially the ones that should be scaling vertically instead of horizontally). Anyway here's some cool SQLite stuff: - https://github.com/CanonicalLtd/dqlite - https://github.com/rqlite/rqlite - https://datasette.readthedocs.io/en/stable/ - https://www.sqlite.org/rtree.html - https://github.com/sqlcipher/sqlcipher - https://github.com/benbjohnson/litestream - https://github.com/aergoio/aergolite - https://sqlite.org/lang_with.html#rcex3 - https://github.com/sql-js/sql.js - https://www.gaia-gis.it/fossil/libspatialite/index - https://github.com/h3rald/litestore - https://github.com/adamlou

With no sense of overstatement here, SQLite is one of my favorite creations in the entire world, so I have a bunch of links some of you might find interesting if you want to dig further: https://github.com/sql-js/sql.js - SQL.js lets you run SQLite within a Web page as it's just SQLite compiled to JS with Emscripten. https://litestream.io/blog/why-i-built-litestream/ - Litestream is a SQLite-powered streaming replication system. https://sqlite.org/lang_with.html#rcex3 - you can do graph-style queries against SQLite too (briefly mentioned in the article). https://github.com/aergoio/aergolite - AergoLite is replicated SQLite but secured by a blockchain. https://github.com/simonw/datasette - Datasette (mentioned at the very end of the OP article) is a tool for offering up an SQLite database as a Web accessible service - you can do queries, d