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

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


Branch: CURRENT, Version: 3.33.0nb1, Package name: sqlite3-3.33.0nb1, 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
library.

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:
[pkgtools/cwrappers]

Package options: fts

Master sites:

SHA1: d63f3ce52cb295d62d09fc2ad8f2d29c35e1645f
RMD160: ee7e02714f9c1b70eac1eb7256d2010a939cb1dd
Filesize: 2845.468 KB

Version history: (Expand)


CVS history: (Expand)


   2020-11-05 10:09:30 by Ryo ONODERA | Files touched by this commit (1814)
Log message:
*: Recursive revbump from textproc/icu-68.1
   2020-08-19 07:48:37 by Adam Ciarcinski | Files touched by this commit (6) | Package updated
Log message:
sqlite3: updated to 3.33.0

SQLite Release 3.33.0

Support for UPDATE FROM following the PostgreSQL syntax.
Increase the maximum size of database files to 281 TB.
Extended the PRAGMA integrity_check statement so that it can optionally be \ 
limited to verifying just a single table and its indexes, rather than the entire \ 
database file.
Added the decimal extension for doing arbitrary-precision decimal arithmetic.
Enhancements to the ieee754 extension for working with IEEE 754 binary64 numbers.
CLI enhancements:
Added four new output modes: "box", "json", \ 
"markdown", and "table".
The "column" output mode automatically expands columns to contain the \ 
longest output row and automatically turns ".header" on if it has not \ 
been previously set.
The "quote" output mode honors ".separator"
The decimal extension and the ieee754 extension are built-in to the CLI
Query planner improvements:
Add the ability to find a full-index-scan query plan for queries using INDEXED \ 
BY which previously would fail with "no query solution".
Do a better job of detecting missing, incomplete, and/or dodgy sqlite_stat1 data \ 
and generates good query plans in spite of the misinformation.
Improved performance of queries like "SELECT min(x) FROM t WHERE y IN \ 
(?,?,?)" assuming an index on t(x,y).
In WAL mode, if a writer crashes and leaves the shm file in an inconsistent \ 
state, subsequent transactions are now able to recover the shm file even if \ 
there are active read transactions. Before this enhancement, shm file recovery \ 
that scenario would result in an SQLITE_PROTOCOL error.
   2020-06-19 09:31:08 by Adam Ciarcinski | Files touched by this commit (6) | Package updated
Log message:
sqlite3: updated to 3.32.3

3.32.3:
Various minor bug fixes
   2020-06-05 09:48:07 by Adam Ciarcinski | Files touched by this commit (8) | Package updated
Log message:
sqlite3: updated to 3.32.2

3.32.2:
Fix a long-standing bug in the byte-code engine that can cause a COMMIT command \ 
report as success when in fact it failed to commit.
   2020-06-02 10:25:05 by Adam Ciarcinski | Files touched by this commit (1689)
Log message:
Revbump for icu
   2020-05-26 14:50:53 by Adam Ciarcinski | Files touched by this commit (6) | Package updated
Log message:
sqlite3: updated to 3.32.1

Changes in version 3.32.1:

Fix two long-standing bugs that allow malicious SQL statements to crash the \ 
process that is running SQLite. These bugs were announced by a third-party \ 
approximately 24 hours after the 3.32.0 release but are not specific to the \ 
3.32.0 release.

Other minor compiler-warning fixes and whatnot.
   2020-05-23 09:38:01 by Adam Ciarcinski | Files touched by this commit (9) | Package updated
Log message:
sqlite3: updated to 3.32.0

SQLite Release 3.32.0:

Added support for approximate ANALYZE using the PRAGMA analysis_limit command.
Added the bytecode virtual table.
Add the checksum VFS shim to the set of run-time loadable extensions included in \ 
the source tree.
Added the iif() SQL function.
INSERT and UPDATE statements now always apply column affinity before computing \ 
CHECK constraints. This bug fix could, in theory, cause problems for legacy \ 
databases with unorthodox CHECK constraints the require the input type for an \ 
INSERT is different from the declared column type. See ticket 86ba67afafded936 \ 
for more information.
Added the sqlite3_create_filename(), sqlite3_free_filename(), and \ 
sqlite3_database_file_object() interfaces to better support of VFS shim \ 
implementations.
Increase the default upper bound on the number of parameters from 999 to 32766.
Added code for the UINT collating sequence as an optional loadable extension.
Enhancements to the CLI:
Add options to the .import command: --csv, --ascii, --skip
The .dump command now accepts multiple LIKE-pattern arguments and outputs the \ 
union of all matching tables.
Add the .oom command in debugging builds
Add the --bom option to the .excel, .output, and .once commands.
Enhance the .filectrl command to support the --schema option.
The UINT collating sequence extension is automatically loaded
The ESCAPE clause of a LIKE operator now overrides wildcard characters, so that \ 
the behavior now matches what PostgreSQL does.
   2020-04-12 10:29:21 by Adam Ciarcinski | Files touched by this commit (956) | Package updated
Log message:
Recursive revision bump after textproc/icu update