Embeddable SQL Database Engine

Edit Package sqlite3

SQLite is a C library that implements an embeddable SQL database
engine. Programs that link with the SQLite library can have SQL
database access without running a separate RDBMS process.

SQLite is not a client library used to connect to a big database
server. SQLite is a server and the SQLite library reads and writes
directly to and from the database files on disk.

SQLite can be used via the sqlite command line tool or via any
application that supports the Qt database plug-ins.

Refresh
Refresh
Source Files
Filename Size Changed
baselibs.conf 0000000105 105 Bytes
sqlite-doc-3260000.zip 0009321276 8.89 MB
sqlite-src-3260000.zip 0011939787 11.4 MB
sqlite3-btree02-100.patch 0000001640 1.6 KB
sqlite3.changes 0000123190 120 KB
sqlite3.spec 0000006211 6.07 KB
Revision 19 (latest revision is 36)
Sergey Kondakov's avatar Sergey Kondakov (X0F) committed (revision 19)
- btree02.test depended on Tcl internals that changed in 8.6.9.
  (sqlite3-btree02-100.patch)

- SQLite 3.26.0:
  * Optimization: When doing an UPDATE on a table with indexes on
    expressions, do not update the expression indexes if they do
    not refer to any of the columns of the table being updated.
  * Allow the xBestIndex() method of virtual table implementations
    to return SQLITE_CONSTRAINT to indicate that the proposed query
    plan is unusable and should not be given further consideration.
  * Added the SQLITE_DBCONFIG_DEFENSIVE option which disables the
    ability to create corrupt database files using ordinary SQL.
  * Added support for read-only shadow tables when the
    SQLITE_DBCONFIG_DEFENSIVE option is enabled.
  * Added the PRAGMA legacy_alter_table command, which if enabled
    causes the ALTER TABLE command to behave like older version of
    SQLite (prior to version 3.25.0) for compatibility.
  * Added PRAGMA table_xinfo that works just like PRAGMA table_info
    except that it also shows hidden columns in virtual tables.
  * Added the explain virtual table as a run-time loadable
    extension.
  * Add a limit counter to the query planner to prevent excessive
    sqlite3_prepare() times for certain pathological SQL inputs.
  * Added support for the sqlite3_normalized_sql() interface, when
    compiling with SQLITE_ENABLE_NORMALIZE.
  * Enhanced triggers so that they can use table-valued functions
    that exist in schemas other than the schema where the trigger
    is defined.
  * Improvements to the ".help" command in the CLI.
  * The SQLITE_HISTORY environment variable, if it exists,
Comments 0
openSUSE Build Service is sponsored by