Absolute Database - Delphi database system. This BDE alternative is free for personal use. Key Features: No BDE; no DLLs; SQL'92 (DDL & DML) support; Single-user and mutli-user mode (file-server); Single database file; Unmatched ease-of-use; 100% compatibility with standard DB-aware controls; Strong encryption; BLOB compression; Full source code available; Royalty-free; Free for personal use; Ease of Deployment; No BDE, no DLLs; No special installation or configuration required; Database engine compiles right into EXE; Single-file database format; High Speed; Advanced cache management and buffering architecture; Sophisticated SQL query and filter optimizer; Special optimized database engine for temporary results of SQL queries; Fast B*-Tree indexes with high-speed on thousands and on millions of records; Buffered transactions for batch inserts, updates and deletes; Optimization for read-only databases, such as databases on CD; SQL support; SELECT with DISTINCT, INNER LEFT, RIGTH, FULL and OUTER JOIN, GROUP BY and ORDER BY clauses; CREATE TABLE, DROP TABLE, ALTER TABLE statements; CREATE INDEX, DROP INDEX statements; INSERT, UPDATE, DELETE statements; BETWEEN, IN, LIKE, IS NULL operators; Aggregate functions COUNT,SUM,MIN,MAX,AVG; Most of all SQL'92 arithmetic, logical, date-time and string functions and operators; Data types conversion by function CAST; SQL scripts (multiple commands separated by ';'); Parameters in queries; Compactness; Small size of code added into the application by the database engine units; Small database file size achieved by customizable page size, compression of table metadata and other special means; Fast BLOB data compression; Short indexes for string fields; Low memory consumption