[flagged]
- https://github.com/simonw/sqlite-history-json
- https://github.com/simonw/sqlite-ast
- https://github.com/simonw/showboat - 292 stars
- https://github.com/simonw/datasette-showboat
- https://github.com/simonw/rodney - 290 stars and 4 contributors who aren't me or Claude
- https://github.com/simonw/chartroom
Noting the star counts here because they are a very loose indication that someone other than me has found them useful.
It does use transactions in the form of savepoints which means they can be nested: https://github.com/simonw/sqlite-history-json/blob/53e66b279...
Transactions are tested here: https://github.com/simonw/sqlite-history-json/blob/53e66b279...
I lead with sqlite-history-json because I think it's the most impressive of the bunch - it solves a difficult problem in an elegant way with code I would have been proud to write by hand.
I wouldn't call these toys either. If you want toys take a look at most of https://tools.simonwillison.net/ - these six are all real projects on GitHub with tests and documentation and release notes.
Asking for "amazing" open source projects in this case is not asking out of genuine curiosity or want for debate, it is a rhetorical question asked out of frustration at the general trajectory of AI and who profits off of it -- namely the boot-wearers.