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