News

DISQLite3 5.36.2
- Patch release to fix problems that were discovered shortly after the previous release:
  - Fix a problem with growing databases in the Append VFS extension.
  - Ensure that date/time functions with no arguments (which generate responses that depend on the current time) are treated as non-deterministic functions.
  - Limit the new UNION ALL optimization so that it does not try to make too many new subqueries.

DISQLite3 5.36.1
- Fix a bug in the new ALTER TABLE DROP COLUMN feature when used on columns that are indexed and that are quoted in the index definition.

DISQLite3 5.36.0
- New language features:
  - Support for ALTER TABLE DROP COLUMN.
  - support for RETURNING clause on DELETE, INSERT, and UPDATE statements.
  - Built-in math functions.
  - Generalized UPSERT.
  - MATERIALIZED hint on common table expressions.
- Query planner optimizations to UNION ALL subqueries, the IN operator, and IS NOT NULL expressions.

DIZipWriter 6.7.0
- New TYuXzCompressor: Compress using the XZ compression algorithm, with secure data integrity check.

SQLiteSpy 1.9.15
- Update built-in DISQLite3 engine to SQLite 3.35.1.
- Add bytecode*() table-valued function.
- Add tables_used*() table-valued function.
- Add the uint collation sequence.
- Add decimal extension functions for arbitrary-precision decimal arithmetic.

YuXMLSec 0.1.0 Beta New!
- Initial public release of YuXMLSec, which provides major XML Security standards for Delphi:
  - XML Signature Syntax and Processing (XMLDSIG).
  - XML Encryption Syntax and Processing (XMLENC).
  - Security Assertion Markup Language (SAML).

YuOpenSSL 0.5.0 Beta
- Convert some C macros to Pascal for better ICS (Internet Component Suite) support.
- Fix wrong type in Indy (Internet Direct).
- Add Synapse thread demo to illustrate thread memory cleanup.

DISQLite3 5.35.1
- Fix a potential use-after-free bug when processing a a subquery with both a correlated WHERE clause and a “HAVING 0” clause and where the parent query is an aggregate.
- Fix minor problems in extensions.

YuOpenSSL 0.4.0 Beta
- Add ICS 8.65 files modified to use YuOpenSSL instead of the OpenSSL DLLs.

YuOpenSSL 0.3.0 Beta
- Update to OpenSSL 1.1.1i, with fix for a high risk potential NULL pointer de-reference in GENERAL_NAME_cmp.
- Add more than 150 new OpenSSL API functions.
- New Synapse TCP/IP and serial library support.

YuPcre2 1.15.0
- Improve the List, List2, Replace, and Replace2 methods so that the OnFormatVariable Sender argument can be queried for MatchedStr, SubStr, etc.
- Work around compiler bugs from Delphi 7 to Delphi 2009 which resulted in “Internal Error” under certain conditions.
- Fix inifinite loop with invalid UTF-8 mode enabled.
- Fix multiple JIT problems, including character ranges optimization, character set matching, and word boundary check.

DISQLite3 5.35.0
- New TDISQLite3UniDirQuery.IntegerPrimaryKeyField option to work around potential data loss due to the 32-bit limitation of Delphi's ftAutoInc DataType.
- Query planner enhancements.
- Multiple recursive SELECTS in recursive common table expressions.
- Better error messages from CHECK constraint failures.

YuOpenSSL 0.1.0 Alpha New!
- Initial public release of YuOpenSSL, the first implementation of OpenSSL for Delphi that does not require OpenSSL DLLs. YuOpenSSL.pas contains over 5000 OpenSSL functions, procedures, constants and types in a single Delphi unit. It compiles directly into executables, with no external dependencies. Works with ICS Internet Component Suite, adjusted source code included.

YuOpenSSL 0.2.1 Alpha
- Add EVP_VerifyInit(), EVP_VerifyInit_ex(), and EVP_VerifyUpdate(), ported from OpenSSL macros.
- Fix memory leaks in ICS (Internet Component Suite).

YuStemmer 5.4.0
- New Yiddish stemmer.
- Fix decoding of 4-byte UTF-8 sequences.

YuBrotli 2.2.0
- Based on Brotli v0.9.0 release: Fix a decoder “integer overflow” problem where an input size (chunk size) larger than 2GiB may cause a crash.
- Raise an exception if decoder wrapper functions run out of input. Previously, this data error was silently ignored.
- Many improvements and bug fixes.

YuOpenSSL 0.2.0 Alpha
- Update to OpenSSL 1.1.1h.
- Add many new OpenSSL API functions, procedures, types, and constants.
- Indy support, plus basic demos. The Indy OpenSSL 1.1.1 IOHandler is still in development. Until stable, consider this a proof of concept and use with great care.
- New demos to create certificates.

DISQLite3 5.34.0
- Support for UPDATE FROM following the PostgreSQL syntax.
- Increase the maximum size of database files to 281 TB.
- Extended PRAGMA integrity_check so it can run on a single table only.
- Add the decimal extension for arbitrary-precision decimal arithmetic.
- Query planner improvements.