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 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