What is AidAim SQLMemTable?
SQLMemTable for Delphi and C++ Builder is a fast and simple in-memory database. It includes four visual components.
- TSQLMemDatabase is an analog to TDatabase.
- TSQLMemTable is a quick and simple in-memory TTable substitute;
- TSQLMemQuery provides a subset of SQL'92 operators
- TSQLMemBatchMove is very similar to TBatchMove and supports almost all its functionality.
SQLMemTable doesn't require BDE. It provides all TTable functions, including master/detail relationship and searching, sorting, and sorting.
SQLMemTable offers the following services:
- Multiple memory databases are supported
- SQL'92 DML and DDL enhanced support with the advanced statement;
- Support for correlated subqueries in SELECT and UPDATE SQL statements
- Support for SQL stored procedures and SQL functions
- Full Views Support
- Case-insensitive search
- Referential integrity support (SQL 99 compliance);
- Support for Unicode 100% - SQL, filters, and database objects names
- Export to SQL
- The BatchMove component
- Relationship between master and detail;
- Database Designer - Design-time editor in TSQLMemDatabase, and SQL designer for TSQLMemQuery
- Renaming, emptying, deleting, and restructuring tables.
- You can create, edit, delete, browse, and search for records.
- Multiple indexes can be created and deleted
- Calculated and lookup fields
- Filtering support
- BLOB fields compression
- Multi-thread access;
- It is easy to import from or export any data set quickly and efficiently.
- Optional compression is available for loading and saving tables
- Unicode support and internationalization/localization
SQLMemTable, an in-memory fully functional database system, is available with the query, database, and batch move components. It also includes useful utility (with source codes, demos, and extensive help). SQLMemTable doesn't require any external drivers or BDE and has a small footprint.
AidAim SQLMemTable has many great features:
Compactness
- A short compiled code of approximately 300kb. No external drivers (such as BDE) are required.
- SQLMemTable database engine uses very little memory.
- Data compression using fast BLOB. Large data fields will require less memory. SQLMemTable can compress data quickly. SQLMemTable's compression routines are faster than many popular archivers such as WinRar, PKZip, and Arj.
High performance
- Search by B-tree Indexes for fast results. SQLMemTable is currently one of the fastest in-memory tables available for Delphi and C++Builder.
- The use of tuned algorithms and a memory manager optimized for high-speed in-memory performance can be achieved.
- String operations are quick. SQLMemTable can compare strings up to three times faster than standard Delphi string procedures. A special library written in Assembler combined with an advanced sorting algorithm can achieve high performance.
- An advanced SQL optimizer can often make query execution much faster by choosing the most efficient execution plan.
Functionality
- TSQLMemQuery supports a subset of SQL'92 operators (DML & DDL). SQLMemTable allows you to create SQL scripts that can be used for inserting, editing, deleting, and retrieving records using the SELECT command. Check out the full list of commands supported.
- Advanced search engine. SQLMemTable supports the 'LIKE operator with wildcards "%" and "_", as well as IS NULL' and ‘IS NOT NULL’ in queries and filters.
- Full support for multiple indexes, i.e., An index can be made up of multiple fields within a table. SQLMemTable offers descending and ascending, case-sensitive, and insensitive indexes that can be used for string fields.
- In-memory shared tables. SQLMemTable allows simultaneous access to a table from multiple TSQLMemTable components in a single application.
- Support for default values
- Record-level constraints are, i.e., When editing data, there are constraints.
Compatibility
- SQLMemTable supports almost all TTable field types, including BLOB, and it also allows you to create string and large string fields of any length.
- SQLMemTable works with all standard DB-aware visual controls, including QuickReport and DBGrid. DBNavigator, DBNavigator, DBMemo, and DBRichEdit. Third-party products that support TDataset descendant components, such as FastReport, DBFlyTreeView, and others, are also compatible.
- TTable can also be used to calculate and lookup fields.
- TTable functions, including Key and Range, are supported in large part.
Convenience
- The easiest method of table restructuring is to keep all existing data.
- It supports data importing from and exporting any dataset. SQLMemTable allows you to import and export tables using ImportTable or ExportTable methods.
- Support for internationalization and localization. SQLMemTable makes it easy to localize your program using text search and sorting functions that use the current system locale.
- Unicode support. Text operations can be performed using multi-byte encoding with ftWideString.
- Comprehensive assistance. SQLMemTable includes all documentation in SQLMemTable Developer’s Guide and SQLMemTable Reference.
Click on the below link to download AidAim SQLMemTable Retail NOW!
