sqlite 3.7.7.1
An SQL Database Engine in a C Library
Packager: Gökçen Eraslan
License: as-is
Actions
Binary packages
Release history
| Release | Release date | Version | Updater | Comment |
|---|---|---|---|---|
| 26 | 2011-08-04 | 3.7.7.1 | Gökçen Eraslan | Version bump to latest release: * Fix a bug causing PRAGMA case_sensitive_like statements compiled using sqlite3_prepare() to fail with an SQLITE_SCHEMA error. * Add support for URI filenames * Add the sqlite3_vtab_config() interface in support of ON CONFLICT clauses with virtual tables. * Add the xSavepoint, xRelease and xRollbackTo methods in virtual tables in support of SAVEPOINT for virtual tables. * Update the built-in FTS3/FTS4 and RTREE virtual tables to support ON CONFLICT clauses and REPLACE. * Avoid unnecessary reparsing of the database schema. * Added support for the FTS4 prefix option and the FTS4 order option. * Allow WAL-mode databases to be opened read-only as long as there is an existing read/write connection. * Added support for short filenames. * Fix a problem with WAL mode which could cause transactions to silently rollback if the cache_size is set very small (less than 10) and SQLite comes under memory pressure. |
| 25 | 2010-10-21 | 3.7.3 | Gökçen Eraslan | Version bump to 3.7.3 |
| 24 | 2010-04-15 | 3.6.23.1 | Onur Küçük | Version bump to 3.6.23.1 Force readline usage to make it is detected correctly Force NDEBUG and O3 flags |
| 23 | 2010-04-15 | 3.6.22 | İşbaran Akçayır | sqlite should be compiled with thread safety option for subversion compatibility. one needs --pre-1.6-compatible parameter to create new svn workspace in current situation. (svnadmin create) added --enable-threadsafe to configure options, i guess threadsafety option was forgotten in commit #66289 |
| 22 | 2010-04-13 | 3.6.22 | Ozan Çağlayan | - Fix a problem with queries that have a WHERE clause of the form (x AND y) OR z where x and z come from one table of a join and y comes from a different table, - Fix a problem where the use of the CAST operator in the WHERE clause can lead to incorrect results, - A 12% reduction in the number of CPU operations (as measured by valgrind). |
| 21 | 2010-01-25 | 3.6.20 | Eren Türkay | * Add SQLITE_SECURE_DELETE compile-time option. Even if the data is deleted with sqlite query, the traces of the deleted data still remains in the file but cannot be seen with sqlite query. However, it can be seen by opening the file with a text editor. SQLITE_SECURE_DELETE overwrites written data with zeros. #12137 http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=566326 |
| 20 | 2009-11-10 | 3.6.20 | Faik Uygur | * Optimizer enhancement: prepared statements are automatically re-compiled when a binding on the RHS of a LIKE operator changes or when any range constraint changes under SQLITE_ENABLE_STAT2. * Various minor bug fixes and documentation enhancements. |
| 19 | 2009-10-30 | 3.6.19 | Gökçen Eraslan | * Version bump to latest stable version, at least 3.6.16 is needed by Firefox 3.5.4: * 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. * 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]). * 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. * 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. |
| 18 | 2009-06-16 | 3.6.15 | Gökçen Eraslan | Version bump to latest stable version |
| 17 | 2009-05-04 | 3.6.13 | Gökçen Eraslan | Version bump to latest stable version |
| 16 | 2009-01-27 | 3.5.9 | Gökçen Eraslan | - Improve NaN testing to work with divisions on highly optimized x86 code. This fixes empty results when doing e.g. "select 30.3/22" (LP: #254228). |
| 15 | 2008-07-15 | 3.5.9 | Gökçen Eraslan | Stable update |
| 14 | 2007-12-18 | 3.5.4 | İsmail Dönmez | Stable update |
| 13 | 2007-12-06 | 3.5.3 | İsmail Dönmez | Stable update |
| 12 | 2007-11-07 | 3.5.2 | İsmail Dönmez | Version bump |
| 11 | 2007-08-17 | 3.4.2 | İsmail Dönmez | Stable update |
| 10 | 2007-07-23 | 3.4.1 | İsmail Dönmez | Stable update |
| 9 | 2007-06-21 | 3.4.0 | İsmail Dönmez | Stable update |
| 8 | 2007-05-07 | 3.3.17 | İsmail Dönmez | Stable update |
| 7 | 2007-04-22 | 3.3.16 | İsmail Dönmez | Stable update |
| 6 | 2007-02-21 | 3.3.13 | İsmail Dönmez | Stable update |
| 5 | 2007-02-01 | 3.3.12 | İsmail Dönmez | Stable update |
| 4 | 2007-01-11 | 3.3.10 | İsmail Dönmez | Stable update |
| 3 | 2006-10-24 | 3.3.8 | İsmail Dönmez | Version bump |
| 2 | 2006-04-07 | 3.3.5 | S.Çağlar Onur | Version bump |
| 1 | 2005-11-11 | 3.2.7 | S.Çağlar Onur | First release. |