News

DISQLite3 5.32.0
- INSERT and UPDATE statements now always apply column affinity before computing CHECK constraints.
- Added the iif() SQL function.
- The ESCAPE clause of a LIKE operator now overrides wildcard characters, so that the behavior now matches what PostgreSQL does.
- Added support for approximate ANALYZE using the PRAGMA analysis_limit command.
- New extensions: bytecode virtual table, checksum VFS, UINT collation sequence.
- New functions to better support of VFS shim implementations: sqlite3_create_filename(), sqlite3_free_filename(), and sqlite3_database_file_object().

YuPcre2 1.13.0
- Capturing groups that contain recursive backreferences to themselves are no longer automatically atomic.
- New option for pcre2_substitute: PCRE2_SUBSTITUTE_LITERAL, PCRE2_SUBSTITUTE_MATCHED, PCRE2_SUBSTITUTE_REPLACEMENT_ONLY.
- If PCRE2_UCP is set without PCRE2_UTF, Unicode character properties are used for upper/lower case computations on characters whose code points are greater than 127.
- Updated to Unicode 13.0.0.

YuNetSurf 4.0.1.
- CSS parser bug fix for selectors without ruleset.
- CSS property handling bug fixes.

DIRegEx 8.12.0
- JIT compiler update.
- Avoid potential integer overflow after (?C.

YuPdf 2.6.1
- Improve PDF/A-1a conformance to silence errors reported by recent validators.

SQLiteSpy 1.9.14
- Package includes SQLiteSpy.exe Win32 and Win64 executables.
- Update built-in DISQLite3 engine to SQLite 3.31.1.
- New extensions: BLOBIO, DBDATA, FOSSILDELTA, URIFUNCS, and UUID.
- Add redo to SQL edit.
- Automatic column widths of result grid take column caption into account.

DISQLite3 5.31.1
- Improve UTF-16 to UTF-8 conversions (and vice versa) so include Unicode Code Points from $100000 to $10FFFF (Supplemental Planes).
- Fix incomplete parameter renaming which caused a compile error in Delphi 2007 and before.

DISQLite3 5.31.0
- Add support generated columns.
- Add security properties for application-defined SQL functions.
- More efficient lookaside memory allocator.
- New UUID and urifuncs extensions.
- Optimizations and bug fixes.

DITidy 6.3.0
- Add support for DATA element.
- Keep case of anchors for HTML5.

YuStemmer 5.2.0
- New Serbian stemmer.
- Minor optimisation to Dutch Kraaij Pohlmann stemmer.

YuBrotli 2.0.0
- Drop “custom dictionary” support.
- New “Large Window Brotli” feature.
- New encoding and decoding options.
- Improved compression for small and tiny data.
- Bug fixes.

YuPcre2 1.12.0
- Support for matching in invalid UTF strings.
- Non-atomic positive lookarounds are implemented in the interpreter, but not in JIT.
- Upgraded to Unicode 12.1.0.
- Other enhancements and bugfixes.

DIXml 5.15.0
- XPath improvements: optional recursion limit, filter evaluation, and error propagation.
- xsl:template requires name and match attributes.
- Fix xsl:number performance regression.
- Fix memory leaks, invalid pointer dereferences, integer overflows, and uninitialized memory accesses.
- Avoid potential stack overflows by making functions non-recursive.

DIContainers 5.0.1, DIFileFinder 6.11.1, DIHtmlParser 8.0.1, and DIZipWriter 6.5.1
- Delphi compilers with support for the inline directive (starting with Delphi 2005) failed to compile *.bpl packages for the Demo and Commercial editions. They generated a “[dcc32 Fatal Error] DIUtils: F2051 Unit DIContainers was compiled with a different version of DIUtils.StrSameIW”. Regular *.exe applications compiled without problems. The Source Code also compiled to both *.bpl packages and *.exe applications with no problems.

DISQLite3 5.30.0
- Add support for the NULLS FIRST and NULLS LAST clauses on ORDER BY SQL statements.
- Add support for FILTER SQL clauses on all aggregate functions.
- Miscellaneous performance enhancements.

Unicode 7.0.0 and DIHtmlParser 8.0.0
- Enhance Unicode processing to support to the full range of Unicode Code Points up to $10FFFF.
- DIContainers, DIFileFinder, DIGoogleReader, DIHtmlLabel, DIRegEx, DIZipWriter have received compatibility updates.

DISQLite3 5.29.0
- New option to activate and deactivate the double-quoted string literal misfeature.
- Query planner improvements: AND, OR, and LIKE optimizations.
- New sqlite_dbdata virtual table extension to extract raw low-level database content

Delphi Inspiration