Embeddable SQL Database Engine
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.
- Developed at server:database
- Sources inherited from project openSUSE:Factory
-
8
derived packages
- Download package
-
Checkout Package
osc -A https://api.opensuse.org checkout openSUSE:Factory:Rebuild/sqlite3 && cd $_ - Create Badge
Refresh
Refresh
Source Files
| Filename | Size | Changed |
|---|---|---|
| baselibs.conf | 0000000105 105 Bytes | |
| sqlite-autoconf-3150000.tar.gz | 0002490473 2.38 MB | |
| sqlite-doc-3150000.zip | 0005456115 5.2 MB | |
| sqlite-fts5-link.patch | 0000000437 437 Bytes | |
| sqlite3.changes | 0000098148 95.8 KB | |
| sqlite3.spec | 0000005203 5.08 KB |
Revision 92 (latest revision is 153)
Dominique Leuenberger (dimstar_suse)
accepted
request 435535
from
Ismail Dönmez (namtrac)
(revision 92)
- SQLite 3.15.0
* Added support for row values.
* Allow deterministic SQL functions in the WHERE clause of a
partial index.
* Added the "modeof=filename" URI parameter on the unix VFS
* Added support for SQLITE_DBCONFIG_MAINDBNAME.
* Added the ability to VACUUM an ATTACH-ed database.
* Enhancements to the command-line shell:
+ Add the ".testcase" and ".check" dot-commands.
+ Added the --new option to the ".open" dot-command,
causing any prior content in the database to be purged
prior to opening.
* Enhance the fts5vocab virtual table to handle "ORDER BY term"
efficiently.
* Miscellaneous micro-optimizations reduce CPU usage by more than
7% on common workloads. Most optimization in this release
has been on the front-end (sqlite3_prepare_v2()).
* The multiply operator now correctly detects 64-bit
integer overflow and promotes to floating point in all
corner-cases. Fix for ticket 1ec41379c9c1e400.
* Correct handling of columns with redundant unique indexes
when those columns are used on the LHS of an IN operator.
Fix for ticket 0eab1ac759.
* Skip NULL entries on range queries in indexes on expressions.
Fix for ticket 4baa46491212947.
* Ensure that the AUTOINCREMENT counters in the sqlite_sequence
table are initialized doing "Xfer Optimization" on
"INSERT ... SELECT" statements. Fix for ticket 7b3328086a5c116c.
* Make sure the ORDER BY LIMIT optimization (from check-in 559733b09e)
works with IN operators on INTEGER PRIMARY KEYs.
Comments 0