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.


  1. SAVEPOINT and nested transactions
  2. Enforce foreign key constraints.
    • Omit support for deferred constraints
    • Omit support for CASCADE
  3. Rewrite the VDBE to be a 3-address machine rather than a stack-based machine. DONE - version 3.5.5
  4. Use merge-sort like algorithms to make large inserts into indexed tables run faster
  5. Provide a new routine (perhaps called sqlite3_error_detail()) that provides enhanced information for file I/O errors.
  6. 100% code path coverage in the test suite


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