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-3390200.zip 0010683207 10.2 MB
sqlite-src-3390000-func7-pg-181.patch 0000001030 1.01 KB
sqlite-src-3390200.zip 0013403722 12.8 MB
sqlite3.changes 0000152922 149 KB
sqlite3.spec 0000006988 6.82 KB
Revision 26 (latest revision is 36)
Sergey Kondakov's avatar Sergey Kondakov (X0F) committed (revision 26)
- update to 3.39.2:
  * Fix a performance regression in the query planner associated
    with rearranging the order of FROM clause terms in the
    presences of a LEFT JOIN.
  * Apply fixes for CVE-2022-35737, Chromium bugs 1343348 and
    1345947, forum post 3607259d3c, and other minor problems
    discovered by internal testing. [boo#1201783]

- update to 3.39.1:
  * Fix an incorrect result from a query that uses a view that
    contains a compound SELECT in which only one arm contains a
    RIGHT JOIN and where the view is not the first FROM clause term
    of the query that contains the view
  * Fix a long-standing problem with ALTER TABLE RENAME that can
    only arise if the sqlite3_limit(SQLITE_LIMIT_SQL_LENGTH) is set
    to a very small value.
  * Fix a long-standing problem in FTS3 that can only arise when
    compiled with the SQLITE_ENABLE_FTS3_PARENTHESIS compile-time
    option.
  * Fix the initial-prefix optimization for the REGEXP extension so
    that it works correctly even if the prefix contains characters
    that require a 3-byte UTF8 encoding.
  * Enhance the sqlite_stmt virtual table so that it buffers all of
    its output. 

- update to 3.39.0:
  * Add (long overdue) support for RIGHT and FULL OUTER JOIN
  * Add new binary comparison operators IS NOT DISTINCT FROM and 
    IS DISTINCT FROM that are equivalent to IS and IS NOT, 
    respective, for compatibility with PostgreSQL and SQL standards
Comments 0
openSUSE Build Service is sponsored by