Delphi

Absolute Database v7.95 Single User Full Source (D4-D12 Athens)

Absolute Database is a Delphi database engine which lets you forget the Borland Database Engine (BDE). This BDE replacement is the compact, high-speed, robust and easy-to-use database engine. With Absolute Database you will not need special installation and configuration, it compiles right into your EXE. Make your application faster and smaller with Absolute Database BDE alternative!

An individual may use Absolute Database Personal in a project if he / she is the only user of this project. If your project is public or if you represent a company, you must order commercial edition of Absolute Database.

Key Features:

No BDE; no DLLs

Single-file database

SQL'92 (DDL & DML) support

Compatible with standard and third-party database controls

Single-user and multi-user mode (file-server)

Works great on all versions of Windows - from 98 to the latest, doesn't require any updates or service packs

Ultra-fast in-memory tables

Unmatched ease-of-use

Strong encryption

BLOB compression

Free for personal use

Full source code available

Royalty-free distribution

Features

Ease of Deployment

No BDE, no DLLs

No special installation or configuration required

Database engine compiles right into EXE

Single-file database format

Database file could be merged with the application EXE file

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

In-memory tables for fast operations with data loaded into memory

Optimization for read-only databases, such as databases on CD

High-concurrency design for multi-threaded applications

Ultra-fast in-memory tables

Multi-User

Zero-admin file-server

Automatic record and table locking

Automatic detection of changes made by other users

Configurable limit of concurrent connections

Easy switching between single-user and multi-user mode

Full transactions support with ReadCommited isolation...

Description

Absolute Database is a Delphi database engine which lets you forget the Borland Database Engine (BDE). This BDE replacement is the compact, high-speed, robust and easy-to-use database engine. With Absolute Database you will not need special installation and configuration, it compiles right into your EXE. Make your application faster and smaller with Absolute Database BDE alternative!

An individual may use Absolute Database Personal in a project if he / she is the only user of this project. If your project is public or if you represent a company, you must order commercial edition of Absolute Database.

Key Features:

No BDE; no DLLs

Single-file database

SQL'92 (DDL & DML) support

Compatible with standard and third-party database controls

Single-user and multi-user mode (file-server)

Works great on all versions of Windows - from 98 to the latest, doesn't require any updates or service packs

Ultra-fast in-memory tables

Unmatched ease-of-use

Strong encryption

BLOB compression

Free for personal use

Full source code available

Royalty-free distribution

Features

Ease of Deployment

No BDE, no DLLs

No special installation or configuration required

Database engine compiles right into EXE

Single-file database format

Database file could be merged with the application EXE file

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

In-memory tables for fast operations with data loaded into memory

Optimization for read-only databases, such as databases on CD

High-concurrency design for multi-threaded applications

Ultra-fast in-memory tables

Multi-User

Zero-admin file-server

Automatic record and table locking

Automatic detection of changes made by other users

Configurable limit of concurrent connections

Easy switching between single-user and multi-user mode

Full transactions support with ReadCommited isolation level

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, EXISTS 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 statements separated by ';')

Parameters in queries

SELECT from several databases in one query

Correlated and non-correlated subqueries

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

Automatic free space recycling for data records, index pages, and BLOB blocks

Fast BLOB data compression

Short indexes for string fields

Low memory consumption

Compatibility

Support of most of TTable field data types, including BLOB fields

Full compatibility with standard DB-aware visual controls such as QuickReport, DBGrid, DBNavigator, DBImage, DBMemo, DBRichEdit and others

Calculated and lookup fields

Most of TDatabase, TQuery and TTable properties, methods and events

Support for the IProvider interface (TClientDataSet)

Functionality

Unicode support in String and Memo fields

Multiple-fields indexes with descending, ascending, case-sensitive and insensitive options

Shareable tables

Default values support

Min, max and not null constraints on field values

Export to SQL script (reverse engineering)

Security

Strong encryption of database file

Variety of supported encryption algorithms: Rijndael, the Advanced Encryption Standard (AES) winner 128 bit key, Rijndael 256 bit key, Blowfish 448 bit key, Twofish 128 bit key, Twofish 256 bit key, Square, Single DES and Triple DES

Reliability

Repair database in case of hardware failure or operating system error caused by another application

Auto-detect of database corruption and automatic repair of database file

Convenience

Table restructuring being performed in the easiest way keeping all the existing data

Data importing from and exporting to any dataset

Internationalization / localization support by use of current system locale

Displaying progress during potentially slow operations with the tables and databases

Utilities

DBImportExport utility to transfer your existing tables from database systems with BDE driver, such as Paradox, Interbase, Access, Oracle, SQL Server to Absolute Database format and vice versa.

Absolute Database Manager to manage a database easily and to perform all supported operations with tables and database file

With Absolute Database Manager you could also easily execute SQL queries

All utilities come with full source code and can be used as an advanced examples

Ease of Development

Full compatibility with TTable, TQuery, TSession and TDatabase components

Extensive Developer's Manual covering every development issue.

Large number of demos illustrating wide range of use cases

Prompt and responsive technical support

Cost-Effectiveness

100% royalty-free, i.e. there is no additional licensing fees no matter how many times you deploy the application

Flexible licensing: source code and no source code versions, multi-developers licenses

Target Development Environment:

Delphi 4

Delphi 5

Delphi 6

Delphi 7

Delphi 2005

Delphi 2006

Delphi 2007

Delphi 2009

Delphi 2010

Delphi XE

Delphi XE2 (32 and 64 bit)

Delphi XE3 (32 and 64 bit)

Delphi XE4 (32 and 64 bit)

Delphi XE5 (32 and 64 bit)

Delphi XE6 (32 and 64 bit)

Delphi XE7 (32 and 64 bit)

Delphi XE8 (32 and 64 bit)

Delphi 10 (32 and 64 bit)

Delphi 10.1 (32 and 64 bit)

Delphi 10.2 (32 and 64 bit)

Delphi 10.3 (32 and 64 bit)

Delphi 10.4 (32 and 64 bit)

Delphi 11 (32 and 64 bit)

Delphi 12 (32 and 64 bit)

Turbo Delphi Professional

C++ Builder 4

C++ Builder 5

C++ Builder 6

C++ Builder 2006

C++ Builder 2007

C++ Builder 2009

C++ Builder 2010

C++ Builder XE

C++ Builder XE2

C++ Builder XE3

C++ Builder XE4

C++ Builder XE5

C++ Builder XE6

C++ Builder XE7

C++ Builder XE8

C++ Builder 10

C++ Builder 10.1

C++ Builder 10.2

C++ Builder 10.3

C++ Builder 10.4

C++ Builder 11

C++ Builder 12

Turbo C++ Professional

Trial and Personal editions of Delphi are not supported

Additional Information