| TurboDB Database Engine |
| |
TurboDB
for VCL Std |
TurboDB
for VCL Pro |
TurboDB
for
ODBC |
TurboDB
Managed |
TurboDB
Studio |
| Runs on native Windows |
|
|
|
|
|
| Runs on .NET |
|
|
|
|
|
| Runs on .NET CF/Silverlight/Phone |
|
|
|
|
|
| Runs as a true 64 bit application |
|
|
|
|
|
| Multi-user access |
|
|
|
|
|
| Primary and foreign key constraints with cascade and reject |
|
|
|
|
|
| Default values and check constraints |
|
|
|
|
|
| Improved net file management to avoid "dead" locks |
|
|
|
|
|
| Transactions |
|
|
|
|
|
| Option to have a single file for all tables, indexes and blob files of a database |
|
|
|
|
|
| Support for multiple sessions and multiple threads per application |
|
|
|
|
|
| Up to 255 tables and query results open concurrently |
|
|
|
|
|
| Up to 50 indexes per table |
|
|
|
|
|
| Up to 1000 columns per table |
|
|
|
|
|
| Up to 2.000.000.000 rows per table |
|
|
|
|
|
| Strong and weak encryption for database tables and indexes |
|
|
|
|
|
| Unicode string fields and Unicode memo fields |
|
|
|
|
|
| Normal string data types up to 32.767 characters long |
|
|
|
|
|
| Large Integer fields (64 Bit) |
|
|
|
|
|
| GUID fields |
|
|
|
|
|
| Memo and Blob fields |
|
|
|
|
|
| 32-Bit integer field |
|
|
|
|
|
| Time columns with minute, second or millisecond resolution |
|
|
|
|
|
| Datetime fields |
|
|
|
|
|
| Auto-increment field |
|
|
|
|
|
| Link field for implementing one-to-many relationship |
|
|
|
|
|
| Relation field for implementing many-to-many relationship |
|
|
|
|
|
| Maintained full-text indexes for ultra-fast keyword search |
|
|
|
|
|
| No database configuration/installation required |
|
|
|
|
|
| Language support through collations on table and column level |
|
|
|
|
|
| Unicode-enabled database engine |
|
|
|
|
|
| Full support for SQL parameters |
|
|
|
|
|
| Stored procedures written in TurboSQL or .NET language |
|
|
|
|
|
| User-defined functions written in TurboSQL or .NET language |
|
|
|
|
|
| User-defined aggregates to create customized aggregation functions in analogy to MAX, SUM etc. in any .NET language |
|
|
|
|
|
| Database format compatible with TDB for DOS 5.5, Visual Data Publisher 3.0, TurboDB Studio and TurboDB 4. |
|
|
|
|
|
| Needs no special execution rights under .NET |
- |
- |
|
|
- |
| Library size (KB) |
~2000 |
~2000 |
~1300 |
~1000 |
~2000 |
| SQL Dialect |
| SELECT with GROUP BY and HAVING, UPDATE, DELETE and INSERT with subselect |
|
|
|
|
|
| INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN |
|
|
|
|
|
| FULL OUTER JOIN |
|
|
|
|
|
| Sub-queries with IN, EXISTS, SOME, ANY, ALL |
|
|
|
|
|
| Sub-queries can be uncorrelated or correlated |
|
|
|
|
|
| UNION, EXCEPT, INTERSECT |
|
|
|
|
|
| CASE, CAST and TOP keywords |
|
|
|
|
|
| PRIMARY KEY, FOREIGN KEY, CHECK |
|
|
|
|
|
| DDL with CREATE TABLE, ALTER TABLE, CREATE INDEX and DROP |
|
|
|
|
|
| UPDATE INDEX/FULLTEXTINDEX to rebuild an index |
|
|
|
|
|
| Multiple SQL commands within one statement |
|
|
|
|
|
| CREATE FUNCTION/PROCEDURE/AGGREGATE statements |
|
|
|
|
|
| TurboDB VCL Components |
| Can compile completely into the application, no need for additional libraries |
|
|
- |
- |
- |
| Special component properties and methods to support Unicode |
|
|
- |
- |
- |
| Table component derived from TDataSet for compatibility with all data-aware controls and components |
|
|
- |
- |
- |
| Table component supports methods, events and properties of TTable, like SetKey, Lookup, Locate, Exclusive, ReadOnly,... |
|
|
- |
- |
- |
| Complex filtering on conditions and keywords at the same time |
|
|
- |
- |
- |
| Range methods: SetRange, ApplyRange, CancelRange |
|
|
- |
- |
- |
| Table creation and altering at run-time using CreateTable and AlterTable |
|
|
- |
- |
- |
| Full control over normal and full-text indexes: Add/Delete/Update methods |
|
|
- |
- |
- |
| Properties for foreign key definitions and full-text definitions |
|
|
- |
- |
- |
| Query component derived from TDataSet for compatibility with all data-aware controls and components |
|
|
- |
- |
- |
| Query component supports methods, events and properties of TQuery like SQL and ExecSQL. |
|
|
- |
- |
- |
| Query can produce live result set |
|
|
- |
- |
- |
| Query supports outer joins |
|
|
- |
- |
- |
| BatchMove component supports methods, events and properties of TBatchMove like Mappings, Execute. |
|
|
- |
- |
- |
| BatchMove imports from different text files, TurboDB files and dBase files |
|
|
- |
- |
- |
| BatchMove exports to different text files, TurboDB files, dBase files and XML files. |
|
|
- |
- |
- |
| BatchMove imports from any data set, e.g. BDE data set, ADO data set, dbExpress, ... |
|
|
- |
- |
- |
| BatchMove supports modes of BDE like Append, Copy, Update, Delete, AppendUpdate. |
|
|
- |
- |
- |
| BatchMove export to any data set, e.g. BDE, ADO, dbExpress |
|
|
- |
- |
- |
| BatchMove exports from query results as well as from tables |
|
|
- |
- |
- |
| Database component to replace TDatabase and TSession |
|
|
- |
- |
- |
| Component editor for table component for opening, creating, altering and indexing tables within the IDE |
|
|
- |
- |
- |
| Component editor for database component for creating and selecting databases |
|
|
- |
- |
- |
| Wizard for quick and easy conversion of BDE tables within Delphi IDE |
|
|
- |
- |
- |
| Password dialog support in database component |
|
|
- |
- |
- |
| .NET Managed Provider |
| Native Managed Provider without OLE/COM |
- |
- |
|
|
- |
| Supports full-featured ADO.NET component set including DataConnection, DataCommand, DataReader and DataAdapter |
- |
- |
|
|
- |
| Ability to execute chained SQL commands (multiple commands with the same DataCommand component) |
- |
- |
|
|
- |
| Contains additional components for the cursor-based data access model |
- |
- |
|
|
- |
| Design-time editors and designers for Visual Studio |
- |
- |
|
|
- |
| DDEX Provider for integration into Visual Studio 2005 Server Explorer and Data Source window |
- |
- |
|
|
- |
| Supports Entity Framework |
- |
- |
|
|
- |
| Miscellaneous |
| Visual database management tool for Windows |
|
|
|
|
|
| Additional console-based tool for creating, altering and indexing database tables |
|
|
|
|
|
| Royalty-free deployment of compiled applications built with TurboDB |
|
|
|
|
|
| Free life-time 48 hour e-mail support |
|
|
|
|
|
