sqlite3-devel - Embeddable SQL Database Engine

Property Value
Distribution openSUSE Tumbleweed
Repository openSUSE Oss all
Package filename sqlite3-devel-3.27.2-1.1.i586.rpm
Package name sqlite3-devel
Package version 3.27.2
Package release 1.1
Package architecture i586
Package type rpm
Category Development/Libraries/C and C++
Homepage http://www.sqlite.org/
License SUSE-Public-Domain
Maintainer -
Download size 176.07 KB
Installed size 577.81 KB
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 the server. 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 which supports the Qt database plug-ins.


Package Version Architecture Repository
sqlite3-devel-3.28.0-232.1.i586.rpm 3.28.0 i586 Database
sqlite3-devel-3.28.0-232.1.x86_64.rpm 3.28.0 x86_64 Database
sqlite3-devel-3.27.2-1.1.x86_64.rpm 3.27.2 x86_64 openSUSE Oss
sqlite3-devel - - -


Name Value
/usr/bin/pkg-config -
glibc-devel -
libsqlite3-0 = 3.27.2


Name Value
pkgconfig(sqlite3) = 3.27.2
sqlite-devel = 3.27.2
sqlite3-devel = 3.27.2-1.1
sqlite3-devel(x86-32) = 3.27.2-1.1


Name Value
sqlite-devel < 3.27.2


Type URL
Mirror widehat.opensuse.org
Binary Package sqlite3-devel-3.27.2-1.1.i586.rpm
Source Package sqlite3-3.27.2-1.1.src.rpm

Install Howto

Install sqlite3-devel rpm package:

# zypper install sqlite3-devel




2019-03-10 - Andreas Stieger <andreas.stieger@gmx.de>
- SQLite 3.27.2:
* Add the VACUUM INTO command
* Issue an SQLITE_WARNING message on the error log if a
double-quoted string literal is used
* Add the remove_diacritics=2 option to FTS3 and FTS5.
* Add  the SQLITE_PREPARE_NO_VTAB option to sqlite3_prepare_v3().
Use that option to prevent circular references to shadow tables
from causing resource leaks.
* Enhancements to the sqlite3_deserialize() interface
* Enhancements to the CLI, mostly to support testing and debugging
of the SQLite library itself
* Increased robustness against malicious SQL that is run against
a maliciously corrupted database
- drop sqlite3-btree02-100.patch
2019-01-17 - Reinhard Max <max@suse.com>
- btree02.test depended on Tcl internals that changed in 8.6.9.
2018-12-05 - malte.kraus@suse.com
- 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
* 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
* 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
* 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,
specifies the name of the command-line editing history file.
* The --deserialize option associated with opening a new database
in the CLI cause the database file to be read into memory and
accessed using the sqlite3_deserialize() API. This simplifies
running tests on a database without modifying the file on disk.
2018-10-06 - astieger@suse.com
- SQLite 3.25.2:
* Add the PRAGMA legacy_alter_table=ON command that causes the
"ALTER TABLE RENAME" command to behave as in 3.24.0 and earlier
* Fix issue with some expressions with windows functions in views
- includes changes from SQLite 3.25.1:
* Avoid false-positive error checks on ALTER TABLE
* Further ORDER BY LIMIT optimization fixes for window functions
2018-09-16 - astieger@suse.com
- SQLite 3.25.0:
* Add support for window functions
* Add support for renaming columns within a table
* Query optimizer improvements
* slightly better concurrency in multi-threaded environments
* The ORDER BY LIMIT optimization might have caused an infinite
loop in the byte code of the prepared statement under very
obscure circumstances, due to a confluence of minor defects in
the query optimizer
2018-06-30 - avvissu@yandex.by
- Enable the FTS3 extension
2018-06-29 - mpluskal@suse.com
- Run tests during build
2018-06-08 - guillaume.gardet@opensuse.org
- Use 'src' archive instead of 'amalgamation' to be able to use
- Remove 'sqlite-fts5-link.patch' since patched file is not
availaible in 'src' archive. Add '-lm' flag to LIBS var instead

See Also

Package Description
sqlite3-doc-3.27.2-1.1.noarch.rpm Documentation for sqlite3
sqlitebrowser-3.10.1-2.3.i586.rpm Spreadsheet-like interface to SQLite databases
sqlitebrowser-3.10.1-2.3.x86_64.rpm Spreadsheet-like interface to SQLite databases
sqliteman-1.2.2-3.4.i586.rpm An Sqlite3 manager
sqliteman-1.2.2-3.4.x86_64.rpm An Sqlite3 manager
sqliteodbc-0.9996-1.1.i586.rpm ODBC driver for SQLite
sqliteodbc-0.9996-1.1.x86_64.rpm ODBC driver for SQLite
sqliteodbc-doc-0.9996-1.1.i586.rpm Documentation for sqliteodbc
sqliteodbc-doc-0.9996-1.1.x86_64.rpm Documentation for sqliteodbc
sqtop-2015.02.08-1.6.i586.rpm 'top' for Squid proxy process
sqtop-2015.02.08-1.6.x86_64.rpm 'top' for Squid proxy process
squashfs-4.3-12.1.i586.rpm A Read-Only File System with Efficient Compression
squashfs-4.3-12.1.x86_64.rpm A Read-Only File System with Efficient Compression
squid-4.6-1.1.i586.rpm Caching and forwarding HTTP web proxy
squid-4.6-1.1.x86_64.rpm Caching and forwarding HTTP web proxy