SQLite

:sql:

SQLite as a document database

• https://dgl.cx/2020/06/sqlite-json-support
• https://antonz.org/generated-columns/
• https://antonz.org/sqlite-is-not-a-toy-database/

SQLite (read-only) running on a static site https://phiresky.github.io/blog/2021/hosting-sqlite-databases-on-github-pages/

Bashing JSON into Shape with SQLite https://christine.website/blog/sqlite-json-munge-2022-01-04

SQLite is a tcl extension: https://www.tcl.tk/community/tcl2017/assets/talk93/Paper.html

Replication:

• https://litestream.io/getting-started/
• https://fly.io/docs/litefs/

Browsers:

• https://sqlitebrowser.org/ - what i have used in the past
• https://sqlitestudio.pl/ - something newer and nicer?
• https://www.visidata.org/ - tui data swiss army knife (learning curve)

sqlar: SQLite Archive, like zip or tar

• https://www.sqlite.org/sqlar.html

The SQLite project has been pretty clear on its goal. It is not to be a client/server database alternative, it’s to be an ad-hoc application data file alternative. But it is software and with a bit of hard work, you can make software do amazing things.

Siren Call of SQLite on the Server

https://pid1.dev/posts/siren-call-of-sqlite-on-the-server/

Simple declarative schema migration for SQLite

https://david.rothlis.net/declarative-schema-migration-for-sqlite/