Key features include:

No BDE; no DLLs; SQL'92 (DDL & DML) support; single-user and mutli-user mode (file-server); single database file; encryption; BLOB compression; full source code available; royalty-free; free for personal use; no special installation or configuration required; database engine compiles right into EXE; single-file database format; cache management and buffering architecture; SQL query and filter optimizer; optimized database engine for temporary results of SQL queries; 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 COUNT, SUM, MIN, MAX, AVG; most of SQL'92 arithmetic, logical, date-time and string functions and operators; data type conversion by function CAST; SQL scripts (multiple commands separated by ';'); parameters in queries; small database file size achieved by customizable page size, compression of table metadata and other means; short indexes for string fields.