A directory of data access products for Delphi
| Product: | SQLMemTable | ||
| Vendor: | AidAim Software | ||
| Version: | 4.50 | Data Aware Controls: | TDataSet |
| Web Site: | http://www.aidaim.com/in-memory_sql_database_delphi.htm | Support Delphi Vers: | 4 5 6 7 2005 2006 2007 2009 2010 XE |
| Source Available: | Yes | Supports C++B Vers: | 4 5 6 2006 2007 2009 2010 XE |
| Description: | SQLMemTable is a simple and fast in-memory table and query for Delphi and C++ Builder. | |
| Deployment: | Compiles in to EXE. Small footprint. | |
| Modes of
Operation: Check indicates primary intended use(s). |
Local: |
 Yes |
| Multiuser File Server: | ||
| Multiuser Client/Server: | ||
| Web Server: | ||
| Package(s) Available: | Price: |
| SQLMemTable Personal | Free |
| SQLMemTable COM | $ 125 |
| SQLMemTable PRO | $ 295 |
| Database/File Format Supported | Native? | Via | Notes |
| Proprietary | Yes | Single-file database |
| Third Party Tool Compatibility: | Compatible? |
| Fast Report | Yes |
| Ace Reporter | Yes |
| InfoPower | Yes |
| Orpheus (TurboPower) | Yes |
| QuickReports | Yes |
| RAVE Reports | Yes |
| ReportBuilder Pro | Yes |
| DBFlyTreeView Suite | Yes |
| ExpressQuantumGrid Suite | Yes |
Vendor's Description (from Readme files, web site, etc.):
SQLMemTable is the first and only memory database with SQL support
for Delphi and C++ Builder. You can create as many memory databases as
you like - each of them will have its own tables namespace. Thus it is
possible to create multiple copies of same database - like snapshots.
SQLMemTable can be used for importing data from different databases,
as it allows to create fully independent databases - MemDBOracle for
import from Oracle, MemDBMSSQL for SQL Server, MemDBMySQL for MySQL, etc.
SQLMemTable includes three visual components
- TSQLMemTable which is a fast and easy in-memory TTable replacement;
- TSQLMemQuery that provides a subset of SQL'92 operators;
- TSQLMemBatchMove which is very close to TBatchMove and supports almost all of its functionality.
SQLMemTable 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 blob fields compression and Unicode support.
SQLMemTable provides the following services
- Multiple memory databases support;
- SQL (DML and DDL) commands support;
- Export to SQL;
- Referential Integrity support (foreign keys)
- BatchMove component;
- Master / detail relationship;
- Database Designer - design-time editor for TSQLMemDatabase
- creating, renaming, emptying, deleting and restructuring tables;
- creating, editing, deleting, browsing and searching for records;
- creating and deleting multiple indexes;
- calculated and lookup fields;
- filtering support;
- BLOB fields compression;
- Multi-thread access;
- importing from and exporting to any dataset in fast and easy way;
- loading and saving tables with optional compression;
- internationalization / localization and Unicode support.
Is this data old or incomplete? Visit the How To Contribute page.