Absolute Database

Описание

Absolute Database — Delphi database system. No BDE, no DLLs, SQL, strong encryption, BLOBs compression, single-file database, high-speed, embedded database. This BDE alternative is free for personal use. 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 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