VCL

Kylix

Download

Technologies

Articles

Products –> VCL


	Products
Delphi Components

Accuracer

EasyTable

SQLMemTable

Single File System

CryptoPressStream

MsgCommunicator

Active Query Builder

Database Master

BDE Replacement

Delphi Database

Kylix Components

Download

Technologies

Articles


	Order
How To Buy

Sales Policy

Upgrade Policy


	Support
Support Policy

FAQ

Contact Us


	Info
Main

News

Why Choose Us

Testimonials

Partners

About Us

Awards

Trademarks

Subscription

soap2day

SQLMemTable:
In-Memory SQL Database for Delphi

Awards
Description
Specification
Features and benefits
SQL support
Requirements
Speed tests

Advantages of version 5
How to use
Support
On-Line Developer's Guide
On-Line Component Reference
How to order

Description

SQLMemTable is a simple and fast in-memory database for Delphi and C++ Builder.
SQLMemTable includes 4 visual components:

TSQLMemDatabase, analogue of TDatabase;
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'92 DML & DDL enhanced support with advanced statements;
Correlated subqueries support in SELECT, UPDATE and DELETE SQL statements;
SQL stored procedures and functions support;
Full Views support;
Case-insensitive search;
Referential Integrity support (SQL'99 compliance);
100% Unicode support - SQL, filters, database objects names;
Export to SQL;
BatchMove component;
Master / detail relationship;
Database Designer - design-time editor for TSQLMemDatabase and SQL designer in TSQLMemQuery;
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.

SQLMemTable is a fully functional in-memory database system; it includes database, table, query and batch move components as well as useful utility (with source code), demos and comprehensive help. SQLMemTable does not require BDE or any external drivers and has small footprint.

Specification

Data types:
ftFixedChar, ftString, ftWideString, ftSmallint, ftInteger, ftLargeint, ftWord, ftAutoInc, ftFloat, ftBoolean, ftCurrency, ftDate, ftTime, ftDateTime, ftTimeStamp, ftBytes, ftVarBytes, ftDBaseOle, ftParadoxOle, ftTypedBinary, ftBlob, ftGraphic, ftMemo, ftFmtMemo
Advanced data types:
aftUnknown, aftChar, aftString, aftWideChar, aftWideString, aftShortint, aftSmallint, aftInteger, aftLargeint, aftByte, aftWord, aftCardinal, aftAutoInc, aftAutoIncShortint, aftAutoIncSmallint, aftAutoIncInteger, aftAutoIncLargeint, aftAutoIncByte, aftAutoIncWord, aftAutoIncCardinal, aftSingle, aftDouble, aftExtended, aftBoolean, aftCurrency, aftDate, aftTime, aftDateTime, aftTimeStamp, aftBytes, aftVarBytes, aftBlob, aftGraphic, aftMemo, aftFormattedMemo, aftWideMemo
Maximum records quantity: up to 2³¹ (over 2 billions).
Maximum fields per table: 2³¹ (over 2 billions).
Maximum indexes per table: 2³¹.
Maximum index fields per index: 2³¹.
Maximum index entry size: (PageSize - 128) / 2.
Default index page size: 4096 bytes (variable SQLMemDefaultMemoryPageSize in unit SQLMemConst).
Maximum field name's length: 255 characters.
Maximum index name's length: 255 characters.
BLOB compression: ZLib, BZip, PPM
Search operators: <,>,=,<>,<=,>=, like, not like, is null, is not null, and, or, not, ().

Features and benefits

Compactness
High performance
Functionality
Compatibility
Convenience

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 in-memory 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 (DML & 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. See full list of supported commands.
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 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.

SQL support

Here is a full list of supported SQL statements in current version of SQLMemTable:

SELECT [DISTINCT | ALL]
* | column [AS correlation_name | correlation_name], [column...]
[INTO destination_table]
FROM table_reference [AS correlation_name | correlation_name]
[[[[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, 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
Also, there are many other capabilities released in v.5

If you have any questions or would like to tell us what SQL feature you need first of all, please feel free to our Support Team.

Requirements

SQLMemTable is available for Delphi 4, Delphi 5, Delphi 6, Delphi 7, Delphi 2005, Delphi 2006, Delphi 2007, Delphi 2009, Delphi 2010, Delphi XE, Delphi XE2 and for C++Builder 4, C++Builder 5, C++Builder 6, C++Builder 2006, C++Builder 2007, C++Builder 2009, C++Builder 2010, C++Builder XE, C++Builder XE2. As the Delphi Standard and Personal editions do not support TDataset class SQLMemTable will not work there as most other BDE alternatives. SQLMemTable Free and Com are not compatible with trial versions of Delphi (C++ Builder).

How to use

SQLMemTable 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 SQLMemTable Developer's Guide and SQLMemTable Reference (SQLMemTableGuide.hlp and SQLMemTableRef.hlp). Developer's Guide contains examples showing how to use all SQLMemTable's operations and step-by-step instructions. Setup program automatically installs Reference into IDE.

Support

If you have any problems or questions, please 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

SQLMemTable Free is free for personal use. Any company must order SQLMemTable Com, Pro, Team4, Team8 or Enterprise to use it in its projects. If you would like to order this product, please click here.

In case you have already bought this product, you can upgrade it to the latest version or edition. Read our Upgrade Policy to learn more about it.

Please see Sales Policy for details about guarantee, money back, usage terms and conditions.

If you have any problems or questions, please our Sales Department.

Accuracer is fastest!

Accuracer Database System is the fastest Delphi client/server database!

Discounted Giftcards

DigiCounted is a marketplace for buying and selling discounted digital products.

Last Releases

01/17/24
Accuracer VCL v.22.00 for RAD Studio 12.0 Athens

01/17/24
SQLMemTable v.21.00 for RAD Studio 12.0 Athens

01/17/24
EasyTable v.21.00 for RAD Studio 12.0 Athens

01/17/24
CryptoPressStream v.19.00 for RAD Studio 12.0 Athens

01/17/24
Single File System v.18.00 for RAD Studio 12.0 Athens

01/17/24
MsgCommunicator v.19.00 for RAD Studio 12.0 Athens

Competitive Upgrade

If you own a competing product, you may take a discount up to 50%.
Please, contact our

Voting

What is the maximum size of the database you use?

< 10 Mb

10 Mb - 100 Mb

100 Mb - 1 Gb

> 1 Gb


	Accuracer is fastest!

	Accuracer Database System is the fastest Delphi client/server database!


	Discounted Giftcards

	DigiCounted is a marketplace for buying and selling discounted digital products.


	Last Releases

	01/17/24 Accuracer VCL v.22.00 for RAD Studio 12.0 Athens 01/17/24 SQLMemTable v.21.00 for RAD Studio 12.0 Athens 01/17/24 EasyTable v.21.00 for RAD Studio 12.0 Athens 01/17/24 CryptoPressStream v.19.00 for RAD Studio 12.0 Athens 01/17/24 Single File System v.18.00 for RAD Studio 12.0 Athens 01/17/24 MsgCommunicator v.19.00 for RAD Studio 12.0 Athens


	Competitive Upgrade

	If you own a competing product, you may take a discount up to 50%. Please, contact our


Contact AidAim		© 2000-2024 AidAim Software
RAD Studio Components \| Delphi Components Download \| Multi User Database \| Client Server Database System \| Embedded SQL Database \| Delphi Embedded Database \| In Memory SQL Database \| Fastest In Memory Database

SQLMemTable: In-Memory SQL Database for Delphi

RAD Studio Components | Delphi Components Download | Multi User Database | Client Server Database System | Embedded SQL Database | Delphi Embedded Database | In Memory SQL Database | Fastest In Memory Database

SQLMemTable:
In-Memory SQL Database for Delphi