I've baked a ton of different SQLite tricks - including things like full-text indexing support and advanced alter table methods - into my sqlite-utils CLI tool and Python library: https://sqlite-utils.datasette.io

My Datasette project provides tools for exploring, analyzing and publishing SQLite databases, plus ways to expose them via a JSON API: https://datasette.io

I've also written a ton of stuff about SQLite on my two blogs:

- https://simonwillison.net/tags/sqlite/

- https://til.simonwillison.net/sqlite

Your excellent work around SQLite led me to building https://dmd.tanna.dev and some other projects with it recently, and it's been such a game changer for me, so thank you

This is really neat! Found your live demo: https://dependency-management-data-example.fly.dev/datasette...

Blogged it: https://simonwillison.net/2023/Aug/11/dependency-management-...

Oh wow, thanks very much :D yes Datasette was _so_ useful with making my organisation able to be more productive with understanding the data, made it much nicer than folks writing SQL locally, huge props for building it

TWO blogs? you're pretty prolific, even with blogging.

I have ADHD, I can barely finish a sentence

I think this parquet virtual table extension is a pretty neat example of the power of extension https://cldellow.com/2018/06/22/sqlite-parquet-vtable.html