./databases/sqlite3, SQL Database Engine in a C Library

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]

Branch: CURRENT, Version: 3.31.1, Package name: sqlite3-3.31.1, Maintainer: pkgsrc-users

SQLite is a C library that implements an SQL database engine. Programs
that link with the SQLite library can have SQL database access without
running a separate RDBMS process. The distribution comes with a standalone
command-line access program (sqlite) that can be used to administer an
SQLite database and which serves as an example of how to use the SQLite

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.

This is sqlite3, the current stable version.

Required to build:

Package options: fts

Master sites:

SHA1: 0c30f5b22152a8166aa3bebb0f4bc1f3e9cc508b
RMD160: da0b2c10c0a1132c91375a1d9b3a4e8909f9a1f3
Filesize: 2819.573 KB

Version history: (Expand)

CVS history: (Expand)

   2020-03-23 20:37:54 by Mindaugas Rasiukevicius | Files touched by this commit (1)
Log message:
sqlite3: add 'deserialize' option.
   2020-01-29 09:33:12 by Adam Ciarcinski | Files touched by this commit (6) | Package updated
Log message:
sqlite3: updated to 3.31.1

SQLite Release 3.31.1:

Revert the data layout for an internal-use-only SQLite data structure. \ 
Applications that use SQLite should never reference internal SQLite data \ 
structures, but some do anyhow, and a change to one such data structure in \ 
3.30.0 broke a popular and widely-deployed application. Reverting that change in \ 
SQLite, at least temporarily, gives developers of misbehaving applications time \ 
to fix their code.
Fix a typos in the sqlite3ext.h header file that prevented the \ 
sqlite3_stmt_isexplain() and sqlite3_value_frombind() interfaces from being \ 
called from run-time loadable extensions.
   2020-01-26 10:05:19 by Adam Ciarcinski | Files touched by this commit (6) | Package updated
Log message:
sqlite3: updated to 3.31.0

SQLite Release 3.31.0:

Add support for generated columns.
Add the sqlite3_hard_heap_limit64() interface and the corresponding PRAGMA \ 
hard_heap_limit command.
Enhance the function_list pragma to show the number of arguments on each \ 
function, the type of function (scalar, aggregate, window), and the function \ 
Add the aggregated mode feature to the DBSTAT virtual table.
Add the SQLITE_OPEN_NOFOLLOW option to sqlite3_open_v2() that prevents SQLite \ 
from opening symbolic links.
Added the "#-N" array notation for JSON function path arguments.
Added the SQLITE_DBCONFIG_TRUSTED_SCHEMA connection setting which is also \ 
controllable via the new trusted_schema pragma and at compile-time using the \ 
-DSQLITE_TRUSTED_SCHEMA compile-time option.
Added APIs sqlite3_filename_database(), sqlite3_filename_journal(), and \ 
sqlite3_filename_wal() which are useful for specialized extensions.
Add the sqlite3_uri_key() interface.
Upgraded the sqlite3_uri_parameter() function so that it works with the rollback \ 
journal or WAL filename in addition to the database filename.
Provide the ability to tag application-defined SQL functions with new properties \ 
Add new verbs to sqlite3_vtab_config() so that the xConnect method of virtual \ 
tables can declare the virtual table as SQLITE_VTAB_INNOCUOUS or \ 
Faster response to sqlite3_interrupt().
Added the uuid.c extension module implementing functions for processing RFC-4122 \ 
The lookaside memory allocator is enhanced to support two separate memory pools \ 
with different sized allocations in each pool. This allows more memory \ 
allocations to be covered by lookaside while at the same time reducing the heap \ 
memory usage to 48KB per connection, down from 120KB.
The legacy_file_format pragma is deactivated. It is now a no-op. In its place, \ 
the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config() is \ 
provided. The legacy_file_format pragma is deactivated because (1) it is rarely \ 
useful and (2) it is incompatible with VACUUM in schemas that have tables with \ 
both generated columns and descending indexes.
   2020-01-04 03:32:13 by David H. Gutteridge | Files touched by this commit (1) | Package updated
Log message:
sqlite3: remove a workaround that's no longer needed

There have been multiple version updates to this package since that was
added and it was already fixed upstream.
   2019-10-11 17:37:10 by Adam Ciarcinski | Files touched by this commit (6) | Package updated
Log message:
sqlite3: updated to 3.30.1

SQLite Release 3.30.1:
Fix a bug in the query flattener that might cause a segfault for nested queries \ 
that use the new FILTER clause on aggregate functions.
Cherrypick fixes for other obscure problems found since the 3.30.0 release.
   2019-10-05 10:03:56 by Adam Ciarcinski | Files touched by this commit (6) | Package updated
Log message:
sqlite3: updated to 3.30.0

SQLite Release 3.30.0

Add support for the FILTER clause on aggregate functions.
Add support for the NULLS FIRST and NULLS LAST syntax in ORDER BY clauses.
The index_info and index_xinfo pragmas are enhanced to provide information about \ 
the on-disk representation of WITHOUT ROWID tables.
Add the sqlite3_drop_modules() interface, allowing applications to disable \ 
automatically loaded virtual tables that they do not need.
Improvements to the .recover dot-command in the CLI so that it recovers more \ 
content from corrupt database files.
Enhance the RBU extension to support indexes on expressions.
Change the schema parser so that it will error out if any of the type, name, and \ 
tbl_name columns of the sqlite_master table have been corrupted and the database \ 
connection is not in writable_schema mode.
The PRAGMA function_list, PRAGMA module_list, and PRAGMA pragma_list commands \ 
are now enabled in all builds by default. Disable them using \ 
Add the SQLITE_DBCONFIG_ENABLE_VIEW option for sqlite3_db_config().
Added the TCL Interface config method in order to be able to disable \ 
SQLITE_DBCONFIG_ENABLE_VIEW as well as control other sqlite3_db_config() options \ 
from TCL.
Added the SQLITE_DIRECTONLY flag for application-defined SQL functions to \ 
prevent those functions from being used inside triggers and views.
The legacy SQLITE_ENABLE_STAT3 compile-time option is now a no-op.
   2019-07-12 12:04:27 by Adam Ciarcinski | Files touched by this commit (6) | Package updated
Log message:
sqlite3: updated to 3.29.0

SQLite Release 3.29.0:
sqlite3_db_config() for activating and deactivating the double-quoted string \ 
literal misfeature. Both default to "on" for legacy compatibility, but \ 
developers are encouraged to turn them "off", perhaps using the \ 
-DSQLITE_DQS=0 compile-time option.
-DSQLITE_DQS=0 is now a recommended compile-time option.

Improvements to the query planner:
Improved optimization of AND and OR operators when one or the other operand is a \ 
Enhancements to the LIKE optimization for cases when the left-hand side column \ 
has numeric affinity.
Added the "sqlite_dbdata" virtual table for extracting raw low-level \ 
content from an SQLite database, even a database that is corrupt.

Enhancements to the CLI:
Add the ".recover" command which tries to recover as much content as \ 
possible from a corrupt database file.
Add the ".filectrl" command useful for testing.
Add the long-standing ".testctrl" command to the ".help" menu.
Added the ".dbconfig" command
   2019-04-18 12:10:03 by Adam Ciarcinski | Files touched by this commit (8) | Package updated
Log message:
sqlite3: updated to 3.28.0

SQLite Release 3.28.0:

Enhanced window functions:
Add support the EXCLUDE clause.
Add support for window chaining.
Add support for GROUPS frames.
Add support for "<expr> PRECEDING" and "<expr> \ 
FOLLOWING" boundaries in RANGE frames.
Added the new sqlite3_stmt_isexplain(S) interface for determining whether or not \ 
a prepared statement is an EXPLAIN.
Enhanced VACUUM INTO so that it works for read-only databases.
New query optimizations:
Enable the LIKE optimization for cases when the ESCAPE keyword is present and \ 
PRAGMA case_sensitive_like is on.
In queries that are driven by a partial index, avoid unnecessary tests of the \ 
constraint named in the WHERE clause of the partial index, since we know that \ 
constraint must always be true.
Enhancements to the TCL Interface:
Added the -returntype option to the function method.
Added the new bind_fallback method.
Enhancements to the CLI:
Added support for bound parameters and the .parameter command.
Fix the readfile() function so that it returns an empty BLOB rather than \ 
throwing an out-of-memory error when reading an empty file.
Fix the writefile() function so that when it creates new directories along the \ 
path of a new file, it gives them umask permissions rather than the same \ 
permissions as the file.
Change --update option in the .archive command so that it skips files that are \ 
already in the archive and are unchanged. Add the new --insert option that works \ 
like --update used to work.
Added the fossildelta.c extension that can create, apply, and deconstruct the \ 
Fossil DVCS file delta format that is used by the RBU extension.
Added the SQLITE_DBCONFIG_WRITABLE_SCHEMA verb for the sqlite3_db_config() \ 
interface, that does the same work as PRAGMA writable_schema without using the \ 
SQL parser.
Added the sqlite3_value_frombind() API for determining if the argument to an SQL \ 
function is from a bound parameter.
Security and compatibilities enhancements to fts3_tokenizer():
The fts3_tokenizer() function always returns NULL unless either the legacy \ 
application-defined FTS3 tokenizers interface are enabled using the \ 
sqlite3_db_config(SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER) setting, or unless the \ 
first argument to fts3_tokenizer() is a bound parameter.
The two-argument version of fts3_tokenizer() accepts a pointer to the tokenizer \ 
method object even without the \ 
sqlite3_db_config(SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER) setting if the second \ 
argument is a bound parameter
Improved robustness against corrupt database files.
Miscellaneous performance enhancements