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