EasyTable: BDE Alternative
Single File Delphi Database
Description
Description
EasyTable is a compact yet powerful BDE alternative database system
for Delphi and C++ Builder designed to be used with portable applications such
as personal databases, notebooks, phone books, bookmarkers, web server applications, etc.,
when using external drivers (such as standard Borland Database Engine) is pointless.
This product uses its own format that allows to store multiple tables in a single database file .
Moreover, EasyTable allows you to store the database inside the application executable file.
EasyTable includes four visual components:
TEasyTable, which is a fast and easy TTable replacement;
TEasyDatabase that handles tables stored inside the database file;
TEasyQuery that provides a subset of SQL'92 operators;
TEasySession that allows to use EasyTable in multithreaded environment, including web server applications.
EasyTable does not require BDE and provides all the TTable functions such as master / detail relationship,
filtering, searching, sorting, blob fields, key and range methods, as well as some advanced features like
table and database encryption, blob fields compression and multiple indexes.
EasyTable provides the following services:
SQL & DDL commands support;
multiple tables in a single database file;
master / detail relationship;
creating, renaming, emptying, deleting, restructuring and repairing tables;
creating, editing, deleting, browsing and searching for records;
creating and deleting multiple indexes;
calculated and lookup fields;
filtering support;
BLOB fields compression ;
table encryption as well as encryption of the whole database;
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;
capability of database inside the executable file ;
Multi-thread access.
EasyTable is based on original technology created by AidAim Software.
This technology features excellent search performance and extremely high data access speed.
EasyTable is a fully functional database system; it includes database components as well as
useful utilities (with source code), many demos and comprehensive help.
EasyTable is a native Delphi database; it does not require BDE or any external drivers and has small footprint.
Specification
Specification
SQL & DDL commands support.
Data types: ftInteger, ftSmallInt, ftFloat, ftDateTime, ftDate, ftTime,
ftString (any fixed length string), ftWideString (Unicode support),
ftCurrency, ftWord, ftBoolean, ftLargeInt, ftAutoinc, ftBLOB, ftMemo,
ftGraphic, ftFmtMemo, ftBytes, ftBCD.
Maximum records quantity: up to 232 (over 4 billions).
Maximum fields per table: 231 (over 2 billions).
Maximum indexes per table: 231 .
Maximum index fields per index: 231 .
Maximum field name's length: 253 characters.
Maximum index name's length: 253 characters.
BLOB fields block size: >= 10 bytes, default 512.
BLOB compression modes: None, Fastest, Default, Max.
Database file modes: Compact, Normal, Large.
Table encryption: Rijndael with 256-bit key, CRC-32 protected.
Search operators: <,>,=,<>,<=,>=, like, not like,
is null, is not null, and, or, not, ().
File extensions: *.edb - default extension for database file,
*.exe - if database file is integrated into the application executable file. You can use any other extensions.
Data Import/Export Capabilities
Data Import/Export Capabilities
Tables import and export using ImportTable and ExportTable methods.
If you need to move data to EasyTable database from the database that can be accessed via BDE or ODBC,
the better way is to use
EasyTable DBTransfer utility ,
which are available with full source code and can be used
as an example to help you to implement import/export capabilities in your project.
If you need to move data to EasyTable database from CSV (coma-separated values) file ,
look at our CSVImport demo.
EasyTable supports
Borland Bold for Delphi: http://info.borland.com/techpubs/delphi/boldfordelphi/?idh_Overview_auto_1.htm
technology, special thanks to
Konstantin Gribachev, the author of the book "Delphi and Model Driven Architecture".
The easiest way to move your data using Borland Bold® technology is to use his
Bold Data Pump utility: http://mda-delphi.com/articles.php?lng=en&pg=66
.
Here you can download EasyTable Bold Database Adapter
with full source code, a demo and an example of application with source code, too.
EasyTable ODBC Driver
can be used for data import/export from/to ODBC data sources.
It includes almost all the ODBC compatible functionality of the EasyTable.
If you need a help in your special data import/export case, please
contact
our Support Team.
SQL support
SQL support
Here is a full list of supported SQL statements in current version of EasyTable:
SELECT [DISTINCT | ALL]
* | column [AS correlation_name | correlation_name], [column...]
[INTO destination_table]
FROM table_reference [AS correlation_name | correlation_name] [Password 'password']
[[[[NATURAL][INNER | [LEFT | RIGHT | FULL] OUTER JOIN] table_reference [AS correlation_name | correlation_name]
[ON join_condition] | USING (join columns)]
[WHERE predicates]
[GROUP BY group_list]
[HAVING predicates]
[ORDER BY order_list]
[UNION [ALL] [CORRESPONDING [BY (column_list)]] SELECT...]
[EXCEPT | MINUS [ALL] [CORRESPONDING [BY (column_list)]] SELECT...]
[INTERSECT [ALL] [CORRESPONDING [BY (column_list)]] SELECT...]
CREATE TABLE, DROP TABLE, ALTER TABLE statements
CREATE INDEX, DROP INDEX statements
INSERT, UPDATE, DELETE statements
SQL scripts (multiple commands separated by ';')
BETWEEN, IN, EXISTS, LIKE, IS NULL operators
Aggregate functions COUNT,SUM,MIN,MAX,AVG
Most of all SQL'92 arithmetic, logical, datetime and string expressions, functions and operators
Data types conversion function CAST
Parameters in queries
Uncorrelated subqueries
If you have any questions or would like to tell us what SQL feature you need first of all,
please feel free to
contact
Support Team.
Visual Query Building
Visual Query Building
Requirements
Requirements
EasyTable is available for Delphi 4, Delphi 5, Delphi 6, Delphi 7, Delphi 2005, Delphi 2006 and for C++Builder 4, C++Builder 5, C++Builder 6, C++Builder 2006.
As the Delphi Standard and Personal editions do not support TDataset class
EasyTable will not work there as most other BDE alternatives.
EasyTable Free, Lite and Com are not compatible with trial versions of Delphi (C++ Builder).
How to use
How to use
EasyTable is easy-to-use:
just run install.exe and it installs all the components to Delphi (C++ Builder).
The installation process is detailed in Installation chapter in readme.txt.
If you have any questions, please read it carefully.
This product comes with full documentation presented in EasyTable Developer's Guide and EasyTable Reference
(TETGuide.hlp and TETRef.hlp). Developer's Guide contains examples showing how to use all EasyTable’s operations and
step-by-step instructions. Setup program automatically installs Reference into IDE.
Support
Support
If you have any problems or questions, please read FAQ first.
In case if you did not find an answer to your questions there, please
contact our
Support Team
.
We consider any ideas while developing further versions of our products.
Here you can read more about our Support Policy .
Purchasing and Registration
Purchasing and Registration
Custom Development
Custom Development for you -
Delphi and
C++ Builder !
Experts in Database, Networking, Data Compression and Encryption.
10+ years experience.
Contact Us!