Overview

Charles Leifer has released cysqlite, a ground-up Cython rewrite of Python’s sqlite3 module that fixes transaction handling issues and adds support for custom virtual tables. The driver is now ready for testing after years of development.

View Original

Breaking Changes

  • (v0.1.4) Transaction handling completely rewritten - removes sqlite3’s two variants and implements proper SQLite autocommit mechanism

Changes by Version

v0.1.4

  • Added custom virtual tables support - create Python-based virtual tables directly in SQLite
  • Fixed transaction handling - implements proper SQLite autocommit mechanism instead of sqlite3’s confusing variants
  • Added WebAssembly support - runs in browser environments via Pyodide
  • Added upgraded SQLite versions - easier access to newer SQLite features than standard library
  • Added Cython-based implementation - ground-up rewrite for better performance