New Features of SQLite 3 (alpha)

The source of inspiration mentioned the release of sqlite3. Before his blog, I am reading new features of sqlite3, because we are using SQLite in actual projects. I used to reply to the blog. I thought about it later. I 'd better post it myself.

Access blob is already supported, but there is no public interface. The database format and API changes should be the biggest change this time. Originally, all changes were converted to ASCII storage. Currently, non-string types are read and written in binary format, this is also a reason for the decrease in database size.

The new version of the API is much better, similar to the Windows API, for example, taking the error message, and sqlite3_prepare and sqlite3_bind _.... it can also be set later like the ADO command (through? Or: N :)

The enhanced concurrent processing will greatly change the physical file design of the SQLite database. In order to support better concurrency, multiple tables in the original database may be separated into multiple database files.

By the way, SQLite is typeless and now becomes manifest typing. SQLite will perform simple type processing, but it can accommodate any data as before. It is estimated that later versions will gradually become strong data types.

Another new feature is the support for custom character comparison. In addition, the database encryption that has been in the plan is still not supported in 3.0.

We currently use 2.8.13, modified the interface to make it accessible to VB, encapsulated SQLite access with COM, and added Database Password support.