EasyTable: Single-File Embedded Database,
a BDE replacement for Delphi and C++Builder
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. Especially designed for portable applications.
|
| · | Small database size. 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.
|
High performance
| · | Fast search by indexes. 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 and specially optimized algorithms.
|
| · | In-memory mode assigned to speeding up the working process in case when all the data may be stored in RAM.
|
| · | Quick 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. Click here to learn more about SQL implemented in EasyTable.
|
| · | 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 a 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 vendor's 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 AES (Advanced Encryption Standard) 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.
|
| · | Table indexes are re-build automatically 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 an advanced examples.
|
|