3 ms·
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
by simonw 3y ago
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 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 https://datasette.io
I've also written a ton of stuff about SQLite on my two blogs:
- https://simonwillison.net/tags/sqlite/ https://simonwillison.net/tags/sqlite/
- https://til.simonwillison.net/sqlite https://til.simonwillison.net/sqlite
- jamietanna 3y agoYour excellent work around SQLite led me to building https://dmd.tanna.dev https://dmd.tanna.dev and some other projects with it recently, and it's been such a game changer for me, so thank you
- simonw 3y agoThis is really neat! Found your live demo: https://dependency-management-data-example.fly.dev/datasette/datasette/dmd/dependabot?_facet=repo&_facet=package_manager#facet-package_manager https://dependency-management-data-example.fly.dev/datasette... Blogged it: https://simonwillison.net/2023/Aug/11/dependency-management-data/ https://simonwillison.net/2023/Aug/11/dependency-management-...
- jamietanna 3y agoOh 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
- naikrovek 3y agoTWO blogs? you're pretty prolific, even with blogging. I have ADHD, I can barely finish a sentence