sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25)

The release of sqlite-utils 4.0rc2 marks a significant update to the library, primarily focused on refining its transaction handling model. The development process for this release was largely driven by the AI coding agent Claude Fable, which identified and resolved critical bugs, including a major issue where certain delete operations failed to commit and inadvertently poisoned database connections.

The core change in this version is that all write operations, such as inserts, updates, and deletes, now automatically commit to the database upon completion. This ensures that data is saved to disk immediately without requiring manual commit calls. The update also introduces explicit transaction management through new methods like db.begin, db.commit, and db.rollback, providing users with more control when grouping multiple operations.

Beyond transaction logic, the release includes several breaking changes and improvements. These include updated error handling, where invalid API calls now raise ValueError instead of AssertionError, and stricter validation for upsert operations. Additionally, the library now explicitly rejects connections configured with Python 3.12+ autocommit settings, as these conflict with the library's internal transaction management.

This release is notable for its reliance on agentic engineering, with the author using AI models to perform deep code reviews, document new features, and identify edge cases. The process highlights the effectiveness of using AI to manage complex library refactoring, resulting in a more stable and well-documented codebase for the upcoming 4.0 stable release.