Small. Fast. Reliable.
Choose any three.

This information is obsolete. You are looking at the CVSTrac source management system display for SQLite that was replaced by Fossil on 2009-08-11. The information shown here has not been updated since that cut-over. These pages are retained for historical reference only.

Here is a list of things that the core SQLite developers want to work on in the near future. These items are in no particular order.


  • SAVEPOINT and nested transactions
  • Enforce foreign key constraints.
    • Omit support for deferred constraints
    • Omit support for CASCADE
  • Rewrite the VDBE to be a 3-address machine rather than a stack-based machine
  • Use merge-sort like algorithms to make large inserts into indexed tables run faster
  • Provide a new routine (perhaps called sqlite3_error_detail()) that provides enhanced information for file I/O errors.


  • Split up the API documention into separate sections for the Core interface, Auxiliary interfaces, and interfaces used for extending SQLite.
  • Provide a requirements document
  • Provide a mapping between test cases and requirements