SQLMemTable: Embedded BDE Alternative
In-Memory SQL Database for Delphi / C++Builder



Features Overview
Previous  Top  Next


Compactness


·   Short compiled code with approximate size 300 Kb, no external drivers (such as BDE) required.  
 
 
·   Small memory consumption by SQLMemTable database engine.  
 
 
·   Fast BLOB data compression. Your large data fields will need less memory. SQLMemTable can compress data on the fly. The compression routines used in the SQLMemTable are much faster than most of popular archivers like PKZip, WinRar, Arj.  
 

High performance


·   Fast search by B-tree indexes. At the moment SQLMemTable is one of the fastest existing in-memory tables 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. SQLMemTable 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.  
 
 
 

Functionality


·   A subset of SQL'92 including DDL operators is supported by TSQLMemQuery component. With SQLMemTable you can create SQL scripts for creating tables, inserting, editing and deleting records, retrieving data by SELECT command. Click here to learn more about SQL implemented in SQLMemTable.  
 

·   Reverse engeneering (Export tables to SQL script)  
 
 
·   Advanced search engine. SQLMemTable 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. SQLMemTable provides descending and ascending indexes, case-sensitive and insensitive indexes for string fields.  
 

·   Shareable in-memory tables. SQLMemTable supports simultaneous access to a table by multiple TSQLMemTable components within a single application.  

·   Default values support.  

·   Record-level constraints, i.e. constraints that must be met when editing the data.  
 
 

Compatibility


·   SQLMemTable supports most of TTable field data types, including BLOB fields, moreover it allows to create string and wide string fields of any fixed length.  
 

·   SQLMemTable 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. SQLMemTable 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 SQLMemTable is a very simple task.  
 

·   Unicode support. All the text operations work with multi-byte encoding using ftWideString.  
 
 

·   Comprehensive help. SQLMemTable comes with full documentation presented in SQLMemTable Developer's Guide and SQLMemTable Reference.  
 

 


© AidAim Software SQLMemTable: