I just discovered there is/will be SQLite 4. It won’t be a replacement to SQLite3. Instead it will be in addition to SQLite3 with the following differences (quoted from their website):
- SQLite4 is a complete, relational, transactional, ACID, SQL database database engine contained in a compact library that links into a larger application. There is no server. I/O is direct to disk.
- The source code for SQLite4 is available to anyone for any purpose. There are no restrictions on copying, distribution, or publication of sources or compiled binaries. There are no viral licenses to worry over.
- Dynamic typing is used, rather than the rigid static typing of most other SQL database engines.
- The (default) on-disk database image is a single disk file with a well-documented and stable file format, making the SQLite4 library suitable for use as an application file format.
- SQLite4 will be fast and reliable and require no administrator attention. It just works.
- The implementation of SQLite4 has minimal external dependencies so that it is easy to incorporate into embedded systems or other unusual runtime environments.
I can’t wait for the SQLite4 VAPI! Maybe I should start that…