Discussion :

[Community Management]

SQLite version 3.6.3 is now available for download from the website

http://www.sqlite.org/download.html

Version 3.6.3 fixes several bugs in version 3.6.2, most notably the
problem with DISTINCT.


D. Richard Hipp

[Yogui]

SQLite 3.6.4

Téléchargement : http://www.sqlite.org/download.html

Cette version est considérée stable. La mise à jour n'est pas obligatoire.

[Yogui]

SQLite 3.6.5

Téléchargement : http://www.sqlite.org/download.html

N'hésitez pas à remonter les problèmes à la liste sqlite-users@sqlite.org ou en envoyant un ticket : http://www.sqlite.org/cvstrac/tktnew

[Yogui]

SQLite 3.6.6

Téléchargement : http://www.sqlite.org/download.html

Cette version est principalement un correctif de bug pour le moteur de recherche full-text FTS3. Vous devriez effectuer la mise à jour si vous utilisez FTS3 ou un autre moteur de stockage virtuel.

[Yogui]

Un bug complexe à reproduire a été découvert dans les versions 3.6.4 à 3.6.6, il est donc déconseillé de les utliser en production. Cependant, en développement il ne devrait pas y avoir de problème. Une version 3.6.7 devrait arriver bientôt pour corriger ce problème.

[Yogui]

Un bug complexe à reproduire a été découvert dans les versions 3.6.4 à 3.6.6, il est donc déconseillé de les utliser en production. Cependant, en développement il ne devrait pas y avoir de problème. Une version 3.6.7 devrait arriver bientôt pour corriger ce problème.

La version 3.6.6.1 disponible depuis aujourd'hui devrait résoudre ce problème ainsi que quelques bugs mineurs. Tous les utilisateurs sont encouragés à migrer vers la version 3.6.6.1 à la place des versions 3.6.4, 3.6.5 ou 3.6.6.

[Yogui]

SQLite 3.6.6.2 corrige le bug mentionné précédemment : http://www.sqlite.org/download.html

[Yogui]

SQLite 3.6.7

Cette version corrige des bugs dont la probabilité d'occurence est très faible.
Elle contient un nettoyage du pilote Unix ainsi qu'une amélioration des performances avec le système de fichiers AFP.

Téléchargement : http://www.sqlite.org/download.html

[Yogui]

SQLite version 3.6.11

Voici les nouveautés :

• fonctionnalité de sauvegarde et de restauration ;
• amélioration des diagrammes d'explication de l'enchaînement des commandes ;
• corrections de bugs.

SQLite version 3.6.11 is now available from the SQLite website:

http://www.sqlite.org/

Version 3.6.11 adds support for a new live-backup API which enables
applications to make backup copies of SQLite databases while the
database is in use. There are also improvements to the documentation
and various obscure bug fixes.

As always, please let us know if you encounter any difficulties.

D. Richard Hipp

[Emmanuel Lecoester]

SQLite version 3.6.16

Nouveautés :
* Fix a bug (ticket #3929) that occasionally causes INSERT or UPDATE operations to fail on an indexed table that has a self-modifying trigger.
* Other minor bug fixes and performance optimizations.

2009-Jun-27 - Version 3.6.16

SQLite version 3.6.16 is another general maintenance relase containing performance and robustness enhancements. A single notable bug was fixed (ticket #3929). This bug cause cause INSERT or UPDATE statements to fail on indexed tables that have AFTER triggers that modify the same table and index.

[TheBlackReverand]

SQLite version 3.6.17

SQLite Release 3.6.17 On 2009 Aug 10 (3.6.17)

Changes associated with this release include the following:

* Expose the sqlite3_strnicmp() interface for use by extensions and applications.
* Remove the restriction on virtual tables and shared cache mode. Virtual tables and shared cache can now be used at the same time.
* Many code simplifications and obscure bug fixes in support of providing 100% branch test coverage.

[Emmanuel Lecoester]

SQLite Release 3.6.18 On 2009 Sep 11 (3.6.18)

Changes associated with this release include the following:

* Versioning of the SQLite source code has transitioned from CVS to Fossil.
* Query planner enhancements.
* The SQLITE_ENABLE_STAT2 compile-time option causes the ANALYZE command to collect a small histogram of each index, to help SQLite better select among competing range query indices.
* Recursive triggers can be enabled using the PRAGMA recursive_triggers statement.
* Delete triggers fire when rows are removed due to a REPLACE conflict resolution. This feature is only enabled when recursive triggers are enabled.
* Added the SQLITE_OPEN_SHAREDCACHE and SQLITE_OPEN_PRIVATECACHE flags for sqlite3_open_v2() used to override the global shared cache mode settings for individual database connections.
* Added improved version identification features: C-Preprocessor macro SQLITE_SOURCE_ID, C/C++ interface sqlite3_sourceid(), and SQL function sqlite_source_id().
* Obscure bug fix on triggers ([efc02f9779]).

[Emmanuel Lecoester]

SQLite Release 3.6.19 On 2009 Oct 14 (3.6.19)

Changes associated with this release include the following:

* Added support for foreign key constraints. Foreign key constraints are disabled by default. Use the foreign_keys pragma to turn them on.
* Generalized the IS and IS NOT operators to take arbitrary expressions on their right-hand side.
* The TCL Interface has been enhanced to use the Non-Recursive Engine (NRE) interface to the TCL interpreter when linked against TCL 8.6 or later.
* Fix a bug introduced in 3.6.18 that can lead to a segfault when an attempt is made to write on a read-only database.

[COGAN]

SQLite Release 3.6.23.1 On 2010 March 30 (3.6.23.1)

Changes associated with this release include the following:

• Fix a bug in the offsets() function of FTS3
• Fix a missing "sync" that when omitted could lead to database corruption if a power failure or OS crash occurred just as a ROLLBACK operation was finishing.

[Flaburgan]

On en est maintenant à la 3.7.4 :

SQLite Release 3.7.4 On 2010 December 08 (3.7.4)

• Added the sqlite3_blob_reopen() interface to allow an existing sqlite3_blob object to be rebound to a new row.
• Use the new sqlite3_blob_reopen() interface to improve the performance of FTS.
• VFSes that do not support shared memory are allowed to access WAL databases if PRAGMA locking_mode is set to EXCLUSIVE.
• Enhancements to EXPLAIN QUERY PLAN.
• Added the sqlite3_stmt_readonly() interface.
• Added PRAGMA checkpoint_fullfsync.
• Added the SQLITE_FCNTL_FILE_POINTER option to sqlite3_file_control().
• Added support for FTS4 and enhancements to the FTS matchinfo() function.
• Added the test_superlock.c module which provides example code for obtaining an exclusive lock to a rollback or WAL database.
• Added the test_multiplex.c module which provides an example VFS that provides multiplexing (sharding) of a DB, splitting it over multiple files of fixed size.
• A very obscure bug associated with the or optimization was fixed.

[tourlourou]

3.8.7.3 hier !