Accuracer: The First And Only BDE Alternative
Client-Server Single-File Embedded Database for Delphi / C++Builder / Kylix
Functionality
| · | A subset of SQL'92 including DDL operators is supported by TACRQuery component. With Accuracer you can create SQL scripts for creating tables, inserting, editing and deleting records, retrieving data by SELECT command. Read SQL Reference book in this Guide to learn more about SQL implemented in Accuracer
|
| · | Reverse engeneering (Export tables to SQL script)
|
| · | Advanced search engine. Accuracer supports 'LIKE' operator with wildcards '%' and '_', as well as 'IS NULL' and 'IS NOT NULL' in filters and queries.
|
| · | Full multiple index support, i.e. numerous fields in a table may comprise an index. Accuracer provides descending and ascending indexes, case-sensitive and insensitive indexes for string fields.
|
| · | Shareable in-memory tables. Accuracer supports simultaneous access to a table by multiple TAccuracer components within a single application.
|
| · | Minimum, Maximum and Default values support.
|
| · | Required fields support (NOT NULL constraint).
|
| · | Primary and unique indexes support.
|
| · | Autoincrement fields with lots of settings (minimum and maximum value, increment, cycled) based on Sequences
|
| · | Memory tables support with SQL & DDL
|
| · | RepairDatabase is implemented in TACRDatabase
|
| · | Executable database files support
|
| · | Backup and Restore support
|
Compactness
| · | Short compiled code with approximate size 740 Kb, no external drivers (such as BDE) required.
|
| · | Small memory consumption by Accuracer database engine.
|
| · | Fast BLOB data compression. Your large data fields will need less memory. Accuracer can compress data on the fly. The compression routines used in the Accuracer are much faster than most of popular archivers like PKZip, WinRar, Arj.
|
| · | CompactDatabase method in TACRDatabase allows to compact a database file
|
| · | Automatic reducing of the database file size in case of deleting data from the end of file.
|
High performance
| · | Fast search by B-tree indexes. At the moment Accuracer is one of the fastest existing single file databases for Delphi and C++ Builder.
|
| · | High-speed memory operations performance is achieved by means of using specially optimized memory manager and tuned algorithms.
|
| · | Quick operations with strings. Accuracer 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.
|
| · | Advanced SQL optimizer often makes query execution significantly faster by choosing the best execution plan.
|
Compatibility
| · | Accuracer supports most of TTable field data types, including BLOB fields, moreover it allows to create string and wide string fields of any fixed and variable length.
|
| · | Accuracer 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.
|
Convenience
| · | Table restructuring is being performed in the easiest way keeping all the existing data.
|
| · | Data importing from and exporting to any dataset is supported. Accuracer 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 Accuracer is a very simple task.
|
| · | Unicode support. All the text operations work with multi-byte encoding using ftWideString.
|
| · | Comprehensive help. Accuracer comes with full documentation presented in Accuracer Developer's Guide and Accuracer Reference.
|
| · | Lots of demos for different IDE - Delphi, C++ Builder, Kylix and ODBC.
|
Security
| · | Database encryption by best symmetric ciphers (AES, Blowfish, Twofish, DES, etc.)
|
| · | Direct setting of the encryption parameters - cipher mode (CTS, OFB, CBC, CFB), initial vector, binary key
|
| · | String passwords supported (RipeMD128 / RipeMD256 hash used)
|
| · | All pages inside the database files are ecnrypted, including all internal data like indexes, maps, directory
|
| · | New pages are filled with random data by default
|
| · | Secure random number generator based on LFSR algorithm
|
| · | Open Source encryption algorithms implementation (DEC 1 library by Hagen Reddmann)
|
Cross platform product
| · | VCL - Delphi 4,5,6,7,2005 and C++ Builder 4,5,6
|
| · | .Net data provider will be available soon
|
|