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.

*Code*

*: 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.

*Documentation*

*: Split up the {link: /capi3ref.html 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