Roadmap
This roadmap outlines the development plan for rapsqlite.
Current Status
Current Version (v0.3.1) — Phase 1 Complete, Phase 2 Complete, Phase 3 Complete:
Phase 1 Complete: * ✅ Connection lifecycle management (async context managers) * ✅ Transaction support (begin, commit, rollback) * ✅ Type system improvements (proper Python types: int, float, str, bytes, None) * ✅ Enhanced error handling (custom exception classes matching aiosqlite) * ✅ API improvements (fetch_one, fetch_optional, execute_many, last_insert_rowid, changes) * ✅ Cursor API (execute, executemany, fetchone, fetchall, fetchmany) * ✅ aiosqlite compatibility (connect function, exception types) * ✅ Connection pooling (basic implementation with reuse) * ✅ Input validation and security improvements * ✅ Type stubs for IDE support
Phase 2 Complete: * ✅ Parameterized queries (named and positional parameters, execute_many with binding) * ✅ Cursor improvements (fetchmany size-based slicing, result caching, state management) * ✅ Connection configuration (PRAGMA settings, connection string parsing, constructor parameters) * ✅ Pool configuration (pool_size and connection_timeout getters/setters) * ✅ Row factory compatibility (dict/tuple/callable support) * ✅ Transaction context managers * ✅ Advanced SQLite callbacks (enable_load_extension, set_progress_handler, create_function, set_trace_callback, set_authorizer) * ✅ Database dump (iterdump) * ✅ Database backup (backup) * ✅ Schema operations and introspection (9 methods) * ✅ Database initialization hooks (init_hook parameter) * ✅ Prepared statements & performance optimization * ✅ Drop-in replacement validation (aiosqlite compatibility features) * ✅ Documentation & benchmarking
Phase 3 Complete (v0.3.1): * ✅ API completeness (execute_fetchall, execute_insert, Cursor properties, savepoints, Connection.stop(), Cursor.execute/executemany/executescript return self) * ✅ init_hook fixes (run after transaction active; use transaction connection during init_hook) * ✅ True Async DBAPI (rapsqlite.dbapi), SQLAlchemy dialect (sqlite+rapsqlite) * ✅ Test isolation (xdist_group, loadgroup, optional test deps) * ✅ Query helpers (paginate, analyze_query_plan, transaction_with_timeout, set_slow_query_threshold) * ✅ Framework integration (FastAPI, Starlette, aiohttp examples and docs) * ✅ FTS5 and JSON1 tests and docs * ✅ Type adapters and converters (register_adapter, register_converter; per-connection, sqlite3-style) * ✅ Custom aggregates and collations (create_aggregate, create_collation)
Goal
Achieve drop-in replacement compatibility with aiosqlite to enable seamless migration with true async performance.
Future Enhancements
Future enhancements may include:
Dynamic pool sizing
Deadlock detection and automatic retry
Pass 100% of aiosqlite test suite
For the complete roadmap, see the ROADMAP.md file in the repository (canonical source).