Absolute Database. Optimizer, SQL Query

Single file Delphi database with comprehensive SQL support, strong encryption,
BLOBs and multiuser mode support. This BDE alternative is fully compatible with
standard and third-party database components and reporting engines. Absolute DB
does not require any DLLs, drivers or Windows updates. It compiles right into EXE
file and works on any version of Windows from 98 to Vista. Absolute DB is written
completely in Delphi, full source code is available. Absolute DB is a great BDE
replacement.

Key Features: No BDE; no DLLs; SQL'92 (DDL & DML) support; Single-user and
multi-user mode (file-server); Single database file; Unmatched ease-of-use; 100%
compatibility with standard and third-party 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, RIGHT, 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; Data types conversion by function CAST; SQL
scripts; Parameters in queries; 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; Low memory consumption.