DISQLite3 v. 1.5.2 has been released and is available for download: http://www.yunqa.de/delphi/doku.php/products/sqlite3/ DISQLite3 implements a self-contained, embeddable, zero-configuration SQL database engine for Borland / CodeGear Delphi. Features include: * ACID transactions, even after system crashes and power failures. * Zero-configuration no setup or administration needed. * Implements most of SQL-92. * A complete database is stored in a single disk file. * Supports terabyte-sized databases and gigabyte-sized strings and blobs. * Self-contained: no external dependencies, no DLLs. * Small footprint: less than 300 KB code space only. * Full Text Search with customizable tokenizer and prefix matching. * Database AES encryption with SHA256 key generator. * Db.pas is not required, which allows DISQLite3 to compile with all flavours of Delphi, including Delphi Standard and Delphi Personal. * Faster than popular database engines for most common operations. * Simple, easy to use API. * Database files created with DISQLite3 can also be accessed by Linux and MacOS using the SQLite3 libraries. List of changes since the last release: * Always open files using FILE_FLAG_RANDOM_ACCESS under windows. * The 3rd parameter of the built-in SUBSTR() function is now optional. * Bug fix: do not invoke the authorizer when reparsing the schema after a schema change. * Virtual machine stores 64-bit integer and floating point constants in binary instead of text for a performance boost. * Add the NEAR/x operator to FTS3. * Handle "IS NULL" constraints on virtual table scans. IS NULL constraints are not passed to the virtual table layer. * Fix some minor problems with malloc failure and in-memory databases. * New DISQLite3ZLib.pas unit which implements the SQL functions COMPRESS() and UNCOMPRESS(). _______________________________________________ Delphi Inspiration mailing list yunqa@xxxxxxxxxxxxx //www.freelists.org/list/yunqa