SQLite stuff

Knowledge base / Microblog about software development related things by Hans-Peter Störr

SQLite stuff

Created 30-05-2024, last change 30-05-2024

SQLite is a nice database for small projects; I know it especially since Simon Willison uses it for lots of projects like LLM. Here is just some stuff I collected to deal with sqlite databases.

I installed the sqlite3 command line tool (brew install sqlite) and Simon Willisons sqlite-utils (brew install sqlite-utils), jq is for json formatting.