ID: 22535, SQLMemTable v.3.60 for Delphi 2007 / C++Buider 2007

by Ella Perelman Email: Anonymous

Fast in-memory native Delphi database system with SQL. BLOB fields compression, table/database import/export, Unicode, thread-safe, comprehensive help.

Download

Details

Download 4.1MB

CDN Login Required to Download. (You will be redirected to the login page if you click on the Download Link)

To download this, you must have registered:

A free membership

For Delphi, Version 4.0 to 11.0 205 downloads
Copyright: All rights reserved

Updated on Mon, 11 Aug 2008 07:07:44 GMT
Originally uploaded on Fri, 08 Oct 2004 05:19:50 GMT
SHA1 Hash: 18DCADC0D861FB2D1152A0681133EAD2598B8945
MD5 Hash: 371414DDC48F8463471A44AEE14AD5AD

Explore the files in this upload

Description

SQLMemTable for Delphi / C++ Builder: README
============================================

Please read this file carefully (especially the INSTALLATION chapter)
before installing the program to your computer.

Contents
--------

Program information
Company information
Description
Specification
Features and Benefits
Installation
Purchasing / Registration
Copyright and licenses
Warranty and guarantee
Technical support
Important note

Program information
-------------------

Program Name:
SQLMemTable
License Types:
Personal (for personal use, without source code)
Com (for 1 developer, without source code)
Pro (for 1 developer, with source code)
Team4 (for 4 developers, with source code)
Team8 (for 8 developers, with source code)
Enterprise (Enterprise License - for entire company, with source code)
Program Version:
2.50
Program Release Date:
09/29/2004
Program Purpose:
SQLMemTable is a compact, fast and powerful in-memory table with SQL support.
Target Environment:
Delphi 4, 5, 6, 7, 8, 9 and C++ Builder 4, 5, 6.

Company information
-------------------

Company Name:
AidAim Software LLC
Contact E-mail Address:
support@aidaim.com
Contact WWW URL:
http://www.aidaim.com

Description
-----------

SQLMemTable is a compact in-memory table with SQL support
for Delphi and C++ Builder.

SQLMemTable does not require BDE and provides all the TTable's functions
such as Master/Detail relationship, Filtering, Searching, Sorting, Key,
Range, BLOB fields, and has some advanced features such as
BLOB data compression, multi-indexes and table restructuring,
shareable in memory capabilities.
It is fully compatible with all standard DB controls,
supports calculated and lookup fields as well as
internationalization/localization and Unicode,
provides data importing from and exporting to any dataset,
includes SQLConsole utility with source code, comprehensive help and demos.

SQLMemTable provides the following services:

- SQL support
- Master / detail relationship
- Creating, renaming, emptying, deleting and restructuring tables
- Creating, editing, deleting, navigating and searching for records
- Creating and deleting multiple indexes
- Calculated and lookup fields
- Filtering support
- Using BLOB fields with data compression ability
- Importing from and exporting to any dataset in fast and easy way
- Internationalization/Localization and Unicode support
- BatchMove component

SQLMemTable does not require BDE or any external drivers and has small
footprint. Its search performance is excellent and data access speed
is extremely fast.

Specification
-------------

Data types:
ftAutoInc, ftInteger, ftSmallInt, ftFloat, ftDateTime, ftDate,
ftTime, ftBLOB, ftMemo, ftGraphic,
ftString (any fixed length string),
ftCurrency, ftWord, ftBoolean, ftLargeInt, ftFmtMemo,
ftBytes, ftWideString.
Advanced data types:
aftExtended, aftWideMemo

Default index page size: 4096 bytes (variable SQLMemDefaultMemoryPageSize in unit SQLMemConst)
Maximum records quantity: up to 2^31 (over 2 billions).
Maximum fields per table: 2^31 (over 2 billions).
Maximum indexes per table: 2^31 (over 2 billions).
Maximum index fields per index: 2^31 (over 2 billions).
Maximum index entry size: (PageSize - 128) / 2.
Maximum field name's length: 255 characters.
Maximum index name's length: 255 characters.
BLOB fields block size: > 1 byte, default 100 Kb.
BLOB compression: ZLib, BZip, PPM
Search operators: <,>,=,<>,<=,>=, like, not like, is null, is not null,
and, or, not, ().

Features and Benefits
---------------------

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 several
times faster by choosing the best execution plans.

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.
- 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.

Installation
------------

1) Make sure that all copies of Delphi (or C++ Builder) are currently
closed and not running on the target system. Also, if you are
replacing an existing version of SQLMemTable, please remove all files and
the package of the prior version before running the new setup program.

2) Unpack zip archive containing SQLMemTable into any directory.

3) Run the INSTALL.EXE from this directory.

4) Follow on-screen instructions of step-by-step setup wizard to install
SQLMemTable.

5) If after the installation SQLMemTable components
don't appear in Components Palette of the IDE, please follow the next
instructions:

* From the IDE, select 'Component | Install Packages...'.
* Click the 'Add' button.
* In the ..\SQLMemTable\Lib\Delphi# (or ..\SQLMemTable\Lib\C++ Builder#) directory,
select the dclSQLMemTableD#.BPL (or dclSQLMemTableB#.BPL) file.
* Click the 'OK' button to close the dialog.
* Finally, select 'Tools | Environment Options' from the main menu. From this dialog,
select the 'Library' tab and insure that the
..\SQLMemTable\Lib\Delphi# (or ..\SQLMemTable\Lib\C++ Builder#) directory is
included in the 'Library Path' line.

Purchasing / Registration
-------------------------

Visit our site http://www.aidaim.com to purchase or register the product.

Copyright and license
---------------------

See "license.txt" file.

Warranty and guarantee
----------------------

See "license.txt" file.

Technical support
-----------------

Before you contact us, please do the following:

- Make sure you have performed all the required steps correctly.
- Look at the Help files and Demos: it may already contain an answer to
your question. A lot of people ask us something like "how do I:",
though the complete information is there.
- Visit our Internet site at http://www.aidaim.com. It's a good chance
that you'll find the newer version of our product there.

If the problem persists, please, inform us about the following:

- SQLMemTable version.
- Where did you obtain SQLMemTable (http or ftp site).
- Compiler information: Delphi or C++ Builder, Version, Edition, Service
Pack
- Environmental information: your OS and Service Pack
- Description of your problem (as much information as possible to
retrieve the problem).
- Attach a test project where the problem could be reproduced (it helps
us to solve your issue as soon as possible)

Typically AidAim Software Support Team answer messages in 24 hours, but
depending on singularity and difficulty of your question it may take a bit
longer.

Should you have any ideas on improving the existing functions of this
product after you have downloaded and used it, be easy to e-mail us.
All registered users who buy this product may also send their offers
to add new possibilities and/or to change the product's functions.
We consider any ideas and we may take them into account while creating
new versions of our products.

For more information, see http://www.aidaim.com/products/sqlmemtable/sqlmemtable_spec.php