SQLite-Utils 4.1.1 Released with Critical Transaction Fix

The latest version of SQLite-Utils, a popular Python library for working with SQLite databases, has been released to address an edge case that could silently delete or modify data during table transformations.

Key Changes in Version 4.1.1

• Transaction Safety: When using table.transform() with foreign keys and destructive ON DELETE actions (CASCADE, SET NULL, or SET DEFAULT), the function now raises a TransactionError if called while a transaction is open.
• Improved Documentation Cross-Referencing: The CLI and Python API documentation have been updated to link to each other, providing users with comprehensive information about both interfaces.

The fix addresses issue #794, which was discovered by Claude AI during testing of the 4.1 release.