./databases/sqlite3-docs, SQL Database Engine in a C Library (docs package)

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


Branch: CURRENT, Version: 3.38.5, Package name: sqlite3-docs-3.38.5, 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 package contains the documentation, which is shipped separately.


Required to build:
[pkgtools/cwrappers]

Master sites:

Filesize: 10390.809 KB

Version history: (Expand)


CVS history: (Expand)


   2022-05-08 10:10:27 by Adam Ciarcinski | Files touched by this commit (6) | Package updated
Log message:
sqlite3: updated to 3.38.5

3.38.5 (2022-05-06):

Fix a blunder in the CLI of the 3.38.4 release.
   2022-05-05 19:26:42 by Adam Ciarcinski | Files touched by this commit (6) | Package updated
Log message:
sqlite3: updated to 3.38.4

3.38.4 (2022-05-04):

Fix a byte-code problem in the Bloom filter pull-down optimization added by \ 
release 3.38.0 in which an error in the byte code causes the byte code engine to \ 
enter an infinite loop when the pull-down optimization encounters a NULL key.
   2022-04-27 19:12:18 by Adam Ciarcinski | Files touched by this commit (8) | Package updated
Log message:
sqlite3: updated to 3.38.3

changes in version 3.38.3 (2022-04-27):

Fix a case of the query planner be overly aggressive with optimizing \ 
automatic-index and Bloom-filter construction, using inappropriate ON clause \ 
terms to restrict the size of the automatic-index or Bloom filter, and resulting \ 
in missing rows in the output. Forum thread 0d3200f4f3bcd3a3.
Other minor patches. See the timeline for details.
   2022-03-28 21:38:27 by Adam Ciarcinski | Files touched by this commit (6) | Package updated
Log message:
sqlite3: updated to 3.38.2

Additional changes in version 3.38.2 (2022-03-26):

Fix another user-discovered problem with the new Bloom filter optimization that \ 
might cause an incorrect answer when doing a LEFT JOIN with a WHERE clause \ 
constraint that says that one of the columns on the right table of the LEFT JOIN \ 
is NULL. See forum thread 031e262a89b6a9d2.
Other minor patches. See the timeline for details.
   2022-03-14 11:01:19 by Adam Ciarcinski | Files touched by this commit (6) | Package updated
Log message:
sqlite3: updated to 3.38.1

3.38.1 (2022-03-12):

Fix problems with the new Bloom filter optimization that might cause some \ 
obscure queries to get an incorrect answer.
Fix the localtime modifier of the date and time functions so that it preserves \ 
fractional seconds.
Fix the sqlite_offset SQL function so that it works correctly even in corner \ 
cases such as when the argument is a virtual column or the column of a view.
Fix row value IN operator constraints on virtual tables so that they work \ 
correctly even if the virtual table implementation relies on bytecode to filter \ 
rows that do not satisfy the constraint.
Other minor fixes to assert() statements, test cases, and documentation.
   2022-02-23 18:07:37 by Adam Ciarcinski | Files touched by this commit (6) | Package updated
Log message:
sqlite3: updated to 3.38.0

SQLite Release 3.38.0 On 2022-02-22

Added the -> and ->> operators for easier processing of JSON. The new \ 
operators are compatible with MySQL and PostgreSQL.
The JSON functions are now built-ins. It is no longer necessary to use the \ 
-DSQLITE_ENABLE_JSON1 compile-time option to enable JSON support. JSON is on by \ 
default. Disable the JSON interface using the new -DSQLITE_OMIT_JSON \ 
compile-time option.
Enhancements to date and time functions:
Added the unixepoch() function.
Added the auto modifier and the julianday modifier.
Rename the printf() SQL function to format() for better compatibility. The \ 
original printf() name is retained as an alias for backwards compatibility.
Added the sqlite3_error_offset() interface, which can sometimes help to localize \ 
an SQL error to a specific character in the input SQL text, so that applications \ 
can provide better error messages.
Enhanced the interface to virtual tables as follows:
Added the sqlite3_vtab_distinct() interface.
Added the sqlite3_vtab_rhs_value() interface.
Added new operator types SQLITE_INDEX_CONSTRAINT_LIMIT and \ 
SQLITE_INDEX_CONSTRAINT_OFFSET.
Added the sqlite3_vtab_in() interface (and related) to enable a virtual table to \ 
process IN operator constraints all at once, rather than processing each value \ 
of the right-hand side of the IN operator separately.
CLI enhancements:
Columnar output modes are enhanced to correctly handle tabs and newlines \ 
embedded in text.
Added options like "--wrap N", "--wordwrap on", and \ 
"--quote" to the columnar output modes.
Added the .mode qbox alias.
The .import command automatically disambiguates column names.
Use the new sqlite3_error_offset() interface to provide better error messages.
Query planner enhancements:
Use a Bloom filter to speed up large analytic queries.
Use a balanced merge tree to evaluate UNION or UNION ALL compound SELECT \ 
statements that have an ORDER BY clause.
The ALTER TABLE statement is changed to silently ignores entries in the \ 
sqlite_schema table that do not parse when PRAGMA writable_schema=ON.
   2022-01-07 22:06:28 by Adam Ciarcinski | Files touched by this commit (6) | Package updated
Log message:
sqlite3: updated to 3.37.2

Changes in version 3.37.2:

Fix a bug introduced in version 3.35.0 (2021-03-12) that can cause database \ 
corruption if a SAVEPOINT is rolled back while in PRAGMA temp_store=MEMORY mode, \ 
and other changes are made, and then the outer transaction commits. Check-in \ 
73c2b50211d3ae26
Fix a long-standing problem with ON DELETE CASCADE and ON UPDATE CASCADE in \ 
which a cache of the bytecode used to implement the cascading change was not \ 
being reset following a local DDL change. Check-in 5232c9777fe4fb13.
Other minor fixes that should not impact production builds.
   2021-12-30 21:31:51 by Adam Ciarcinski | Files touched by this commit (8) | Package updated
Log message:
sqlite3: updated to 3.37.1

version 3.37.1

Fix a bug introduced by the UPSERT enhancements of version 3.35.0 that can cause \ 
incorrect byte-code to be generated for some obscure but valid SQL, possibly \ 
resulting in a NULL-pointer dereference.
Fix an OOB read that can occur in FTS5 when reading corrupt database files.
Improved robustness of the --safe option in the CLI.
Other minor fixes to assert() statements and test cases.