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

Check indicates
primary intended
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.