VCL

Kylix

Download

Technologies

Articles

Products –> EasyTable


	Products
Delphi Components

Accuracer

EasyTable

SQLMemTable

Single File System

CryptoPressStream

MsgCommunicator

Active Query Builder

Database Master

BDE Replacement

Delphi Database

Kylix Components

Download

Technologies

Articles

Under Development


	Order
How To Buy

Sales Policy

Upgrade Policy


	Support
Support Policy

FAQ

Contact Us


	Info
Main

News

Why Choose Us

Testimonials

Partners

About Us

Awards

Trademarks

Subscription

EasyTable: BDE Replacement
Single-File Delphi Database

Product description
Specification
Data Import/Export
SQL support
Visual Query Building

Awards
On-Line Reference Guide
On-Line Developer's Guide
Buy now!

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.

Voting

What new feature do you need first of all in MsgCommunicator?

Authentication using RSA keys

TCP protocol

Auidio conference

Web-cam support

MSN client

Jabber client

ICQ client

Yahoo client

Proxy-servers support

MS SQL Server database support

Other:

EasyTable: BDE Replacement Single-File Delphi Database

EasyTable: BDE Replacement
Single-File Delphi Database