SQLite Version 3 Overview
| Editorial Note: This document was written in 2004 as a guide to programmers who were transitioning from SQLite2 to SQLite3. It is retained as part of the historical record of SQLite. Modern programmers should refer to more up-to-date documentation on SQLite available elsewhere on this website. |
SQLite Version 3 Overview
SQLite version 3.0 introduces important changes to the library, including:
- A more compact format for database files.
- Manifest typing and BLOB support.
- Support for both UTF-8 and UTF-16 text.
- User-defined text collating sequences.
- 64-bit ROWIDs.
- Improved Concurrency.
This document is a quick introduction to the changes for SQLite 3.0 for users who are already familiar with SQLite version 2.8.
Naming Changes
SQLite version 2.8 will continue to be supported with bug
