Theocacao: SQLite 3.1

SQLite 3.1

Below are some highlights from the SQLite 3.1 alpha release notes. The content is basically taken from the official notes, but the emphasis is mine:

Faster Inserts: The b-tree balancing algorithm has been tuned for the common case of inserting new entries at the end of a table. Inserts are now typically 25% faster and - due to tighter data packing - result in a database file that is perhaps 10% smaller.

Faster Selects: On a table lookup that uses an index, if SQLite can get all of the information it needs from just the index, it never bothers to look at the actual table. This roughly doubles the speed of some queries.

Built-in Dates: CURRENT_TIME, CURRENT_DATE, and CURRENT_TIMESTAMP. These keywords resolve into ISO-8601 time strings. You can use them anywhere but they are especially useful as the default value for columns in a table definition.

The beta is scheduled for Jan 31 (my birthday!). The official release will probably be called 3.1.2 and is scheduled for Feb 14.

Official release notes

SQLite 3.1
Posted Jan 23, 2005 — 3 comments below

Dale — Jan 24, 05 73

Hopefully this will make it into the Core Data/Tiger build! It may be a little late though, even though I don't expect Tiger to ship till April - June.

Scott Stevenson — Jan 24, 05 74

I'd be very surprised if Tiger shipped with a 3.0.x version of SQLite, particularly considering these improvements.

John A — Apr 27, 05 146

According to this thread ,

10.4 ships with (at least) 3.1.3

Comments Feed

Comments Temporarily Disabled

I had to temporarily disable comments due to spam. I'll re-enable them soon.