EasyTable: BDE Alternative Single File Delphi Database

EasyTable: BDE Replacement
Single-File Delphi Database

Features and benefits

Compactness
High performance
Functionality
Compatibility
Security
Reliability
Convenience
Utilities

Compactness

Short compiled code with approximate size 500 Kb, no external drivers (such as BDE) required. EasyTable supports storing multiple tables inside the single database file or even inside the executable file. EasyTable database system is especially designed for portable applications.
Compact database format. EasyTable allows you to store your data in a very compact form, especially when database was created with DatabaseFileMode property of TEasyDatabase set to dfmCompact (less than 10 Kb in size for a database file containing simple table). Incredible compactness is achieved by using advanced technologies, such as Single File System, automatic BLOB headers compression and small size indexes (less than 4 bytes per single record).
Fast BLOB data compression. Your large data fields will need the less possible disk space. EasyTable compresses data on the fly. The data packing / unpacking process is not appreciable compared to the disk write / read process. The compression routines used in the EasyTable are much faster than most of popular archivers like PKZip, WinRar, Arj.
Automatic reducing of the database file size in case of deleting data from the end of file.

High performance

Fast search engine. At the moment EasyTable is one of the fastest existing databases for Delphi and C++ Builder. EasyTable is faster than many popular database systems created by world software industry leaders.
High-speed I/O performance is achieved by means of using read-ahead and write buffering as well as by specially optimized algorithms.
In-memory mode assigned to speeding up the working process in case when all the data may be stored in RAM.
Fast operations with strings. EasyTable compares strings up to 3 times faster than standard Delphi string routines. High performance is achieved by using a special library written in Assembler and an advanced sorting algorithm.

Functionality

A subset of SQL'92 & DDL operators is supported by TEasyQuery component. With EasyTable you can create SQL scripts for creating databases and tables, inserting, editing and deleting records, retrieving data by SELECT command. See full list of supported commands.
Advanced search engine. EasyTable supports 'LIKE' operator with wildcards '%' and '_', as well as 'IS NULL' and 'IS NOT NULL' in filters and queries.
Single file format. Multiple tables can be stored inside the single database file.
Support for executable databases. Database file can be integrated into the application file (*.EXE). Thus you can distribute only single EXE file and either use database in read-only mode (when application will be started OS locks executable file) or copy it to any directory and use in any access mode. Database file can be linked to the application file by calling MakeEXEDatabase function of TEasyDatabase component.
Full multiple index support, i.e. numerous fields in a table may comprise an index. EasyTable provides descending and ascending indexes, case-sensitive and insensitive indexes for string fields.
Shareable in-memory tables. EasyTable supports simultaneous access to a table by multiple TEasyTable components within a single application.

Compatibility

EasyTable supports most of TTable field data types, including BLOB fields, moreover it allows to create string and wide string fields of any fixed length.
EasyTable is fully compatible with standard DB-aware visual controls such as QuickReport, DBGrid, DBNavigator, DBImage, DBMemo, DBRichEdit, as well as with third party products supporting TDataset descendant components - FastReport, DBFlyTreeView and others.
Calculated and lookup fields can be used in the same way as TTable.
Most of TTable functions are supported including Key and Range methods.

Security

EasyTable provides encryption of the entire database contents as well as encryption of the single table. These two encryption levels can be used simultaneously.
Table and database encryption is based on Rijndael algorithm, the winner. It is one of the best existing symmetric block ciphers, tested by the best cryptography experts.
Data stored in the encrypted tables and databases is protected from modifications by CRC-32 checksums. EasyTable features sophisticated protection of your data.

Reliability

EasyTable provides the possibility to repair tables and databases in case of hardware failure or operating system error caused by another application.
Automatic rebuild of table indexes in case of corruption.
EasyTable works with really large databases (about millions records).

Convenience

Table restructuring is being performed in the easiest way keeping all the existing data.
Data importing from and exporting to any data source is supported. EasyTable provides you with the simplest way to import and export tables using ImportTable and ExportTable methods.
Internationalization / localization support. All text search and sorting functions use current system locale, so localizing your program with EasyTable is a very simple task.
Unicode support. All the text operations work with multi-byte encoding using ftWideString.
Displaying progress during potentially slow operations with the tables and databases is supported.
Usage examples. There are more than 20 demos for Delphi and C++ Builder in EasyTable distribution package.
Comprehensive help. EasyTable comes with full documentation presented in EasyTable Developer's Guide and EasyTable Reference.

Utilities

DBTransfer utility will help you transfer your existing tables from database systems with BDE driver, such as Paradox, Interbase, Access, Oracle, SQL Server to EasyTable database and vice versa.
EasyTable Manager helps you manage a database easily. This powerful tool allows you to perform any supported operations with EasyTable tables and databases.
SQL Console provides you an easy way of executing SQL queries. You can load and run demo queries supplied with it or create your own scripts and save them to a text file.
All utilities include source code that can be used as advanced examples.


	Custom Development

	Custom Development for you - Delphi and C++ Builder! Experts in Database, Networking, Data Compression and Encryption. 10+ years experience.

02/02/12
EasyTable v.7.00

01/31/12
Single File System v.3.00

01/30/12
CryptoPressStream v.3.00

10/27/11
MsgCommunicator v.5.00

10/19/11
SQLMemTable v.5.00

10/06/11
Accuracer VCL v.6.00 Beta 2 with XE2

04/27/11
MsgCommunicator Database Pack v.1.10

03/30/11
Accuracer ODBC Driver v.4.02

03/23/11
Accuracer VCL v.5.90 is the fastest Delphi C/S database

02/10/11
Accuracer is the best in the SQL test!

02/17/06
EasyTable ODBC Driver v.1.20

12/14/05
Active Query Builder v.1

10/12/04
Accuracer & EasyTable
are the fastest!
Competitive Prices and
Features Comparison

01/28/04
Accuracer CLX v.1.40 for Kylix


	Competitive Upgrade

	If you own a competing product, you may take a discount up to 50%. Please, contact our

Voting

If Single File System v.3 will include own virtual drive driver, what price do you consider to be suitable for you?

$500-$1000 Com (without source code)

$1000-$2000 Com (without source code)

$2000 -$3000 Com (without source code)

$3000-$5000 Com (without source code)

$10000 with source code

No matter - I do not need it


	Accuracer is fastest!

	Accuracer Database System is the fastest Delphi client/server database!


	Last Releases

	02/02/12 EasyTable v.7.00 01/31/12 Single File System v.3.00 01/30/12 CryptoPressStream v.3.00 10/27/11 MsgCommunicator v.5.00 10/19/11 SQLMemTable v.5.00 10/06/11 Accuracer VCL v.6.00 Beta 2 with XE2 04/27/11 MsgCommunicator Database Pack v.1.10 03/30/11 Accuracer ODBC Driver v.4.02 03/23/11 Accuracer VCL v.5.90 is the fastest Delphi C/S database 02/10/11 Accuracer is the best in the SQL test! 02/17/06 EasyTable ODBC Driver v.1.20 12/14/05 Active Query Builder v.1 10/12/04 Accuracer & EasyTable are the fastest! Competitive Prices and Features Comparison 01/28/04 Accuracer CLX v.1.40 for Kylix

EasyTable: BDE Replacement Single-File Delphi Database

EasyTable: BDE Replacement
Single-File Delphi Database