Earlier quoted context omitted.
Here are a few of mine from the past month - for all of them 90%+ of the code written by Claude Code: - 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…
I quickly read through the `sqlite-history-json` project and it's only a few hundred lines of code and the code doesn't use transactions which means that it can fail and leave the state of the code and database in an inconsistent state.
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.