Release of the SQLite 3.32 DBMS. The DuckDB project develops a variant of SQLite for analytical queries.

Publicerad utgivning SQLite 3.32.0, en lättviktsdatabas som presenteras som ett plugin-bibliotek. Koden för SQLite distribueras som allmän egendom (public domain), vilket betyder att den kan användas utan begränsningar och kostnadsfritt för alla ändamål. Utvecklarna av SQLite får ekonomiskt stöd från ett särskilt konsortium, som inkluderar företag som Adobe, Oracle, Mozilla, Bentley och Bloomberg.

Huvud för:

• Implementerad approximated a variant of the ANALYZE command that allows for partial statistics collection without a full index scan in very large databases. The limit on the number of records when scanning a single index is set using a new directive "PRAGMA analysis_limit«.
• A new virtual table "bytecode" has been added, which provides information about bytecode of prepared statements (prepared statement).
• A VFS layer has been added checksum, which adds 8-byte checksums at the end of each data page in the database and checks them upon each read from the database. This layer helps detect database corruption due to accidental bit distortion in storage devices.
• A new SQL function iif(X,Y,Z), returns value Y if expression X is true, or Z otherwise.
• In INSERT and UPDATE statements, column types are now always använder column affinity) preserved before evaluating conditions in theCHECK block. The limit on the number of parameters has been increased from 999 to 32766..
• An extension has been added
• UINT collating sequence with the implementation of a sorting sequence that considers integers in text for sorting this text in numerical order. In the command-line interface, the command ".import" has added options "—csv", "—ascii", and "—skip". In the command ".dump", the usage of multiple LIKE patterns with merging of all tables matching the specified masks is allowed. A command ".oom" has been added for debug builds. Options "—bom" have been added to the commands ".excel", ".output", and ".once". An option "—schema" has been added to the command ".filectrl."
• The expression ESCAPE specified with the LIKE operator now overrides wildcard characters, which corresponds to the behavior in PostgreSQL.
• Additionally, it is worth noting the development of a new DBMS

DuckDB , where a variant of SQLite optimized for executinganalytical queries is being developed. In addition to the SQLite shell code, the project uses a separate library parser from PostgreSQL, the Date Math component from.
MonetDB , its own implementation of window functions (based on the Segment Tree Aggregation algorithm), a vectorized query execution engine (based on the Hyper-Pipelining Query Execution algorithm), and a regular expression processor based on theRE2 library., egna frågeoptimerare och MVCC-mekanismen för hantering av samtidig exekvering av uppgifter (Multi-Version Concurrency Control).
Projektkod sprids under MIT-licensen. Utvecklingen är fortfarande på stadiet av formation experimentella utgåvor.

Källa: opennet.ru