sqlite

sqlite 3.7.7.1

An SQL Database Engine in a C Library

http://www.sqlite.org/

Packager: Gökçen Eraslan

License: as-is

Actions

Build files

Bug reports

Binary packages

sqlite

Release history

ReleaseRelease dateVersionUpdaterComment
262011-08-043.7.7.1Gökçen EraslanVersion 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.
252010-10-213.7.3Gökçen EraslanVersion bump to 3.7.3
242010-04-153.6.23.1Onur KüçükVersion bump to 3.6.23.1
Force readline usage to make it is detected correctly
Force NDEBUG and O3 flags
232010-04-153.6.22İşbaran Akçayırsqlite 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
222010-04-133.6.22Ozan Ç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).
212010-01-253.6.20Eren 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
202009-11-103.6.20Faik 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.
192009-10-303.6.19Gö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.
182009-06-163.6.15Gökçen EraslanVersion bump to latest stable version
172009-05-043.6.13Gökçen EraslanVersion bump to latest stable version
162009-01-273.5.9Gö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).
152008-07-153.5.9Gökçen EraslanStable update
142007-12-183.5.4İsmail DönmezStable update
132007-12-063.5.3İsmail DönmezStable update
122007-11-073.5.2İsmail DönmezVersion bump
112007-08-173.4.2İsmail DönmezStable update
102007-07-233.4.1İsmail DönmezStable update
92007-06-213.4.0İsmail DönmezStable update
82007-05-073.3.17İsmail DönmezStable update
72007-04-223.3.16İsmail DönmezStable update
62007-02-213.3.13İsmail DönmezStable update
52007-02-013.3.12İsmail DönmezStable update
42007-01-113.3.10İsmail DönmezStable update
32006-10-243.3.8İsmail DönmezVersion bump
22006-04-073.3.5S.Çağlar OnurVersion bump
12005-11-113.2.7S.Çağlar OnurFirst release.

Patches