| |
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
|
