EasyTable for Delphi / C++ Builder: README
==========================================
Please read this file carefully (especially the INSTALLATION chapter)
before installing the program to your computer.
Contents
--------
Program information
Company information
Description
Specification
Features and Benefits
Installation
Purchasing / Registration
Copyright and licenses
Warranty and guarantee
Technical support
Important note
Other products recommended to use
Program information
-------------------
Program Name:
EasyTable
License Types:
Lite (for 1 developer, without source code, no SQL, no sessions)
Com (for 1 developer, without source code)
Pro (for 1 developer, with source code)
Team4 (for 4 developers, with source code)
Team8 (for 8 developers, with source code)
Enterprise (Enterprise License - for entire company, with source code)
Program Version:
5.40
Program Release Date:
05/14/2003
Program Purpose:
EasyTable is a compact, fast and powerful BDE alternative providing
access to a database in a single file format.
Target Environment:
Delphi 4, 5, 6, 7 and C++ Builder 4, 5, 6.
Company information
-------------------
Company Name:
AidAim Software
Contact E-mail Address:
support@aidaim.com
Contact WWW URL:
http://www.aidaim.com
Description
-----------
EasyTable is a compact SQL database engine for Delphi and C++ Builder designed
to be used with small applications such as personal databases, notebooks,
phone books, bookmarkers, etc., when using external drivers (such as
standard Borland Database Engine) is pointless.
EasyTable provides access to a database in its own format and can stores
all the tables in a single database file.
EasyTable does not require BDE and provides all the TTable's functions
such as Master/Detail relationship, Filtering, Searching, Sorting, Key,
Range, BLOB fields, and has some advanced features such as data encryption,
BLOB data compression, multi-indexes, table restructuring and repairing,
shareable in memory capabilities, in-memory mode and others. It is fully
compatible with all standard DB controls, allows using standard database
operations, supports calculated and lookup fields as well as
internationalization/localization an Unicode, provides data importing from
and exporting to any data source, includes some utilities with sources
(f.e. EasyTable Manager), comprehensive help and many demos.
EasyTable provides the following services:
- SQL support
- All tables in a single database file
- Master / detail relationship
- Creating, renaming, emptying, deleting, restructuring and repairing tables
- Creating, editing, deleting, navigating and searching for records
- Creating and deleting multiple indexes
- Calculated and lookup fields
- Filtering support
- Using BLOB fields with data compression ability
- Table encryption, including both table data and BLOB data
- Protecting data from unauthorized access by external tools (such as disk editors)
- In-memory mode is also available to speed up the work with small tables
- Importing from and exporting to any data source in fast and easy way
- Internationalization/Localization and Unicode support
EasyTable does not require BDE or any external drivers and has small
footprint. Its search performance is excellent and data access speed
is extremely fast.
Specification
-------------
All the tables are stored in a single database file.
Data types: ftAutoInc, ftInteger, ftSmallInt, ftFloat, ftDateTime, ftDate,
ftTime, ftBLOB, ftMemo, ftGraphic,
ftString (any fixed length string),
ftCurrency, ftWord, ftBoolean, ftLargeInt, ftFmtMemo,
ftBytes, ftBCD, ftWideString.
Maximum records quantity: up to 2^32 (over 4 billions).
Maximum fields per table: 2^31 (over 2 billions).
Maximum indexes per table: 2^31 (over 2 billions).
Maximum index fields per index: 2^31 (over 2 billions).
Maximum field name's length: 253 characters.
Maximum index name's length: 253 characters.
BLOB fields block size: > 100 bytes, default 512.
BLOB compression modes: None, Fastest, Default, Max.
Table encryption: Rijndael with 256-bit key, CRC-32 protected.
Search operators: <,>,=,<>,<=,>=, like, not like, is null, is not null,
and, or, not, ().
File types:
- All tables in a single file (v.5.xx format):
*.edb
- Each table in several files (v.2.20 format):
*.dat - table (all records and table header),
*.idx - indexes for table,
*.bif - blob fields headers,
*.bdf - blob data file.
Features and Benefits
---------------------
Compactness.
- Short compiled code with approximate size 450 Kbytes, no external
drivers (such as BDE) required. Especially designed for small
applications such as personal databases, notebooks, phone books,
bookmarkers, etc., but it works with huge data, too.
- Small database size. EasyTable will allow you store your data
compactly, due to its well-thought database maintenance, as well as
due to some special means, such as automatic BLOB headers compression.
- 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 speed is essentially greater than
that of popular archivers such as zip, rar, arj, and so on.
Rapidity.
- Fast search by indexes. Now EasyTable is one of the fastest existing
TTable replacement. EasyTable is even faster then many popular DB
engines created by world software industry leaders.
- High-speed I/O performance is achieved by means of using read-ahead
and write buffering and special optimized algorithms.
- In-memory mode assigned to speeding up the working process in case
when all the data may be stored to Random Access Memory.
- Quick operations with strings. High strings comparison speed
(assembler library) and an advanced sorting algorithm are used.
Functionality.
- Advanced search engine. Try our advanced substring search with 'like'
operator using wildcards '%' and '_'. EasyTable search engine also
supports 'is null' and 'is not null' searching operators.
- Single file format. All tables can be stored in a single database file
as well as each table in several files.
- 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 support for working with the same table
using several TEasyTable components at a time.
Compatibility.
- All the necessary data types including BLOB fields' support. EasyTable
supports almost all TTable field data types and provides even more
power supporting string fields of any fixed length.
- Full compatibility with standard DB-aware visual controls such as
QuickReport, DBGrid, DBNavigator, DBImage, DBMemo, DBRichEdit and
others.
- Calculated and lookup fields may be used in the same to TTable way.
- Most of TTable functions support including Key and Range methods.
Security.
- Table encryption is executed by Rijndael, the AES (American Encryption
Standard) winner, all table data is checked by means of CRC-32.
EasyTable protects your data in the best way.
Reliability.
- The ability to repair the table data in case of a failure, which may
occur due to hardware failure or in case of the operating system
failure owing to another application's incorrect operating.
- Auto