sqlite

sqlite 3.6.23.1

An SQL Database Engine in a C Library

http://www.sqlite.org/

Packager: Faik Uygur

License: as-is

Actions

Build files

Bug reports

Binary packages

sqlite

Release history

ReleaseRelease dateVersionUpdaterComment
232010-06-083.6.23.1Ozan ÇağlayanAdd readline dependency.
222010-04-293.6.23.1Mehmet Emre AtaseverActionsapi enhancement
212010-02-043.6.20Mehmet Emre AtaseverPort of Pardus-ARM (ARM7 Cortex-a8)
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