SQLite

Links

3 links submitted so far. Submit your own links.

News

Edit RSS feeds.

Version 3.5.9

Posted about 1 month ago

Version 3.5.9 adds a new experimental
PRAGMA:
journal_mode.
Setting the journal mode to PERSIST can provide performance improvement
on systems where deleting a file is expective. The PERSIST journal
mode is still ... [More] considered experimental and should be used with caution
pending further testing.

Version 3.5.9 is intended to be the last stable release prior to
version 3.6.0. Version 3.6.0 will make incompatible changes to the

sqlite3_vfs VFS layer in order to address deficiencies in the original
design. These incompatibilities will only effect programmers who
write their own custom VFS layers (typically embedded device builders).
The planned VFS changes will be much smaller
than the changes that occurred on the

3.4.2 to 3.5.0 transaction that occurred last
September.

This release of SQLite is considered stable and ready for production use. [Less]

Version 3.5.8

Posted 3 months ago

Version 3.5.8 includes some important new performance optimizations
in the virtual machine code generator, including constant subexpression
factoring and common subexpression elimination. This release also
creates new public ... [More] interfaces:

sqlite3_randomness() provides access to SQLite's internal
pseudo-random number generator,
sqlite3_limit() allows size
limits to be set at run-time on a per-connection basis, and

sqlite3_context_db_handle() is a convenience routine that allows
an application-defined SQL function implementation to retrieve
its
database connection handle.

This release of SQLite is considered stable and ready for production use. [Less]

Version 3.5.7

Posted 4 months ago

Version 3.5.7 fixes several minor and obscure bugs, especially
in the autoconf-generated makefile. Upgrading is optional.
This release of SQLite is considered stable and ready for production use.

Version 3.5.6

Posted 5 months ago

Version 3.5.6 fixes a minor regression in 3.5.5 - a regression that
had nothing to do with the massive change ove the virtual machine
to a register-based design.
No problems have been reported with the new virtual machine. This
release of SQLite is considered stable and ready for production use.

Version 3.5.5

Posted 5 months ago

Version 3.5.5 changes over 8% of the core source code of SQLite in order
to convert the internal virtual machine from a stack-based design into
a register-based design. This change will allow future optimizations
and will avoid ... [More] an entire class of stack overflow bugs that have caused
problems in the past. Even though this change is large, extensive testing
has found zero errors in the new virtual machine and so we believe this
to be a very stable release. [Less]

Read all SQLite articles…