Description

UniDAC (Universal Data Access Components) is a powerful library of non-visual cross-database data access components for direct access to various database servers from Embarcadero RAD Studio XE-10.3 Rio, Embarcadero RAD Studio 2010, CodeGear RAD Studio 2009/2007, Turbo Delphi Professional, Turbo Delphi for .NET Professional, Turbo C++ Professional, Borland Delphi 2005, Borland Delphi 7/6, Borland C++Builder 6, Lazarus 1.2.4 and Free Pascal 2.6.2 for Windows, Mac OS X, iOS, Linux, FreeBSD, for 32-bit and 64-bit platforms.

UniDAC presents the compilation of the best DAC products and provides unified access to the popular database servers like Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite and others. Using UniDAC with its server-independent interface is the best way to create cross-database applications. UniDAC brings outstanding flexibility and independence to your projects. The capability to develop applications using the cutting-edge IDE for all the supported target-platforms: Win32, Win64, Mac OS, iOS, and now - Android. UniDAC gives its users an opportunity to establish Direct Connection and get the fastest data access to databases.

Key features:

• Android application development support
• iOS development support
• NEXTGEN compiler support
• Mac OS X development support
• Win64 development support
• Universal access to different database servers
• Full support for the latest server editions
• High overall performance
• Support of all standard and third-party data-aware controls
• Disconnected Model with automatic connection control for working with data offline
• Local Failover for detecting connection loss and implicit re-execution of certain operations
• Unicode and national charsets support
• Database-independent data storage with the TVirtualTable component
• CachedUpdates operation mode
• Ability to retrieve metadata information
• A large amount of helpful demo projects

Informations

• Status: Evaluation (time-limit)
• Source: On purchase/registration
• price: $299.95
• Source price: $449.95
• Size: 8 386kB

Platforms: C2k6, D2006, C2k7, D2007, C2k9, D2009, C2k10, D2010, CBXE, DXE, CBXE2, DXE2, CBXE3, DXE3, CBXE4, DXE4, CBXE5, DXE5, CBXE6, DXE6, CBXE7, DXE7, CBXE8, DXE8, C10, D10, C10.1, D10.1, C10.2, D10.2, C10.3, D10.3, D6, D7, CB6, FM

Description

EntityDAC is an ORM for Delphi with LINQ support. It provides a powerful framework that allows to perform object-relational mapping of database objects to Delphi classes with full support for encapsulation, inheritance, polymorphism and other OOP features. To retrieve data from a database, LINQ is used as a database independent query engine. In addition, there is a feature-rich ORM modeling tool available ï Entity Developer, that allows to create and edit your ORM models visually, and generate Delphi entity classes by this model automatically.

Key Features:

• * RAD Studio 10.3 Rio is supported
• * RAD Studio 10.2 Tokyo is supported
• * RAD Studio 10.1 Berlin is supported
• * RAD Studio 10 Seattle supported
• Database-First, Model-First and Code-First development: There are several approaches to database application development. Database-First ï a database is developed first, then a data model and application classes are generated on the basis of the existing database. Model-First ï a data model is developed first in a model developer tool, then a database and application classes are generated by this model. Code-First ï in this case, application classes are the original source, on the basis of which a database can be generated, as well as a model, if necessary. When developing applications using EntityDAC, you will be able to use all the three ways.
• Visual ORM Model Designer with Code generation: Entity Developer allows you to create and edit ORM models visually, without typing a line of XML code or manual describing class attributes in Delphi code. It supports creation of all kinds of mapping, such as table splitting, mapping entity to several tables, complex types, inheritance hierarchies, etc. Code generation is very flexible due to using T4-like templates, allowing virtually anything you may want for code generation, and you may even create your own templates for other programming languages.
• LINQ queries: Using ORM when developing your applications must not only accelerate development of the application itself, but also unify the application code and make applications independent of the specifics and syntax of the SQL database for which it is developed, that will allow to support multiple databases in your application with no effort. Therefore, Language Integrated Query (LINQ) is used in EntityDAC as a query language. Using LINQ also significantly simplifies writing and further support of queries, since, at this, the Code completion Delphi engine is used when typing LINQ keywords, class names, their attributes, etc. And in the same way, LINQ queries syntax check is performed at the stage of application compilation.
• Class mapping: Object-relational mapping of database tables to Delphi classes can be performed not only to classes inherited from a basic TEntity class, but to custom classes inherited form TObject as well. Such an approach allows using EntityDAC for development of new applications, as well as simply introduce ORM to already existing projects. In addition, different mapping methods are supported: code mapping, attribute mapping and XML mapping.
• Entity and Query Cache: To increase application performance, EntityDAC allows to cache metadata, all entities loaded from the database, LINQ queries, and much more. Such caching allows to avoid multiple loading of the same data and vastly improve performance in comparison to using the standard Data Access Components.

Informations

• Status: Trial (work while IDE is running)
• Source: On purchase/registration
• price: $149.95
• Source price: $499.95
• Size: 240 760kB

Platforms: C10, C10.1, C10.2, C10.3, C2k10, C2k7, C2k9, CB64, CBXE, CBXE2, CBXE3, CBXE4, CBXE5, CBXE6, CBXE7, CBXE8, D10, D10.1, D10.2, D10.3, D2007, D2009, D2010, DXE, DXE2, DXE3, DXE4, DXE5, DXE6, DXE64, DXE7, DXE8, FM, FM2, FM3

Description

Delphi Client for Memcached database.

What is Memcached? Free & open source, high-performance, distributed memory object caching system, generic in nature, but intended for use in speeding up dynamic web applications by alleviating database load.

Memcached is an in-memory key-value store for small chunks of arbitrary data (strings, objects) from results of database calls, API calls, or page rendering.

Memcached is simple yet powerful. Its simple design promotes quick deployment, ease of development, and solves many problems facing large data caches.

Informations

• Status: Fully functional
• Source: Included
• Size: 51 703kB

Platforms: D2005, D2006, D2007, D2009, D2010, D6, D7, DXE, DXE2, DXE3, DXE4, DXE64

Description

A component dedicated to FreeDB usage. Implements everything needed to query Audio CD album data from FreeDB servers. Supports HTTP and SMTP submissions and uses ASPI/ SPTI/ CDROMIOCTL to read the CDs TOC.

Informations

• Status: Fully functional
• Source: Included
• Size: 100kB

Platforms: CB5, CB6, D5, D6

Description

This module contains classes that allows you access Clarion 2.1 database from your Delphi applications.

Informations

• Status: Fully functional
• Source: Included
• Exe demo: included
• Size: 256kB

Platforms: D3

Description

Components set for Clarion v.2.x tables read-only access.

Features:

• Encrypted tables support (with password recovering)
• Clarion arrays support
• Firebird (Interbase 6) support
• Application-level transactions.

Useful demos:

• Clarion DAT to dBASE DBF converter (d2d)
• D2D ActiveX edition
• D2D GUI edition
• DAT to Interbase converter
• DAT Viewer
• DBF to DAT converter.

Informations

• Status: Fully functional
• Source: Included
• Size: 124kB

Platforms: CB4, CB5, CB6, D3, D4, D5, D6

Description

DbExpress driver for ODBC. Tested against many Databases including: Microsoft SQL Server, Oracle, IBM DB2, Centura SQLBase, MySQL, Microsoft Access, etc.

The driver realizes versions 3 and 2 DBX drivers. The driver can work with anyone ODBC alias. Supports ODBC 2, 3, 3.5.

Informations

• Status: Fully functional
• Source: Included
• Size: 5 390kB

Platforms: CB6, D2005, D2006, D2007, D2009, D6, D7

Description

DBViewer is an universal database navigator that use your database Third Dimension (i.e. foreign keys) to provide you with more navigation and querying power. Navigate inside Oracle, MS SQL Server, Informix, DB2, Sybase, Interbase, MS Access, Paradox, and dBase databases via foreign keys. Instantly jump from master record to detail records. Automatically aggregate reference fields. Database structure is displayed in tree structure that you can customize to build almost instantly powerfull demo apps.

Informations

• Status: Fully functional
• Source: On purchase/registration
• Source price: $80
• Size: 121kB

Platforms: D3, D4

Description

Degisy Data Suite is a package of VCL-components for processing Clarion, dBase, Paradox and Degisy tables. Thanks to the direct access technology, this software solution processes tables very fast, almost instantly, making it a perfect solution for creating applications where a high data processing speed is a basic requirement. All components are inherited from the original TDataSet class, which guarantees their full compatibility with all standard DB Controls. 100% native Delphi code - no additional libraries or programs needed for the components to work. BDE, ADO etc also not required.

Supported Formats:

• Paradox 3-7
• DBase, FoxPro III-VII
• Clarion 2.1
• DDA 1.xx.

Degisy Data provides the following services:

• Fully compatible with all standard DB controls
• Creating, renaming, emptying, deleting tables
• Creating, editing, deleting, navigating and searching for records
• Calculated and lookup fields
• Filtering, searching support
• Soft deletion support for dBase, Clarion and DDA tables
• Customizable cursor cache
• Does not require BDE, ADO etc.
• And much more...

Informations

• Status: Fully functional
• Source: On purchase/registration
• Source price: $39.95
• Size: 1 812kB

Platforms: CB6, D5, D6, D7

Description

Diamond ADO is a Delphi component library, that provide high-speed performance when working with any OLE DB provider or ODBC data source. Diamond ADO uses ActiveX Data Objects 2.0 (ADO) to access data and the BDE is not required. Using Diamond ADO you can connect to any OLE DB provider. Currently OLE DB providers exist for SQL Server, Oracle, Access, ODBC, Active Directory Services and the Index Server.

Key features:

• High speed - fast, native access to data without BDE.
• Compatibility with standard Delphi data-aware components.
• Complete BDE replacement. Diamond ADO doesn't emulate BDE behavior. It is a true TDataset descendent.
• Full access to ADO. You can use the original ADO objects through component's properties.

Informations

• Status: Partially restricted
• Source: On purchase/registration
• price: $49
• Source price: $99
• Size: 2 210kB

Platforms: CB4, CB5, D4, D5, D6

Description

Java Database Connectivity (JDBC) library for Android.

• JDBC drivers for H2, Microsoft SQL, Sybase SQL and PostgreSQL databases
• available for Delphi/C++ Builder 10 - 11
• source code included in registered version
• royalty free distribution in applications

Informations

• Status: With Nag-Screen
• Source: On purchase/registration
• price: $80
• Size: 9 199kB

Platforms: C10, C10.1, C10.2, C10.3, C10.4, C11, D10, D10.1, D10.2, D10.3, D10.4, D11

Description

MyLittleBase is the most compatible, easy to use and standalone database library (csv based). Plus it is open source freeware even for commercial use. The Delphi component is distributed with an experimental SQL engine with full source code and sample to query tables. MyLittleBase (Mlb2) links to no external DLL or server or library it is 100% standalone, free from BDE or ADO. MyLittleBase is available for Delphi & Kylix & Lazarus, PHP, C++ Builder and GCC.

Informations

• Status: Fully functional
• Source: Included
• Size: 53kB

Platforms: D1, D2, D2005, D2006, D3, D4, D5, D6, D7

Description

This classes allows to work with Lotus Notes from any Delphi program. You can create and open databases, write and read documents, send mail and so on. The library uses native API calls.

Informations

• Status: Fully functional
• Source: Included
• Size: 892kB

Platforms: D3, D4, D5

Description

Paradox DataSet for Lazarus and Delphi:

• Read-only direct access
• BLOB fields supported
• Encoding from cp866 to cp1251, UTF-8
• Lazarus and Delphi supported

Informations

• Status: Fully functional
• Source: Included
• Size: 511kB

Platforms: D7

Description

Pascal Data Objects provides a consistent interface to access databases. Currently, only the MySQL and Firebird databases are supported, but additional drivers can easily be added. As these drivers are developed, they will be made available.

Informations

• Status: Fully functional
• Source: Included
• Size: 3 534kB

Platforms: D7

Description

The Spider Object Database is an object-oriented database system for Delphi. The class library is written entirely in Object Pascal and designed with an open architecture, separating the underlying database from the user's perspective. The library supports various database backends with both SQL and ISAM data access.

Informations

• Status: Fully functional
• Source: Included
• price: $99
• Size: 812kB

Platforms: D4, D5, D6

Description

TDataSet descendant component with read and write access to Clarion 2.X tables. Memo fields read/write support.

Informations

• Status: Fully functional
• Source: Included
• Size: 30kB

Platforms: D5, D7

Description

TDBFilter is a component to make it easy to filter standard tables on non-indexed fields. This gives the user much greater control of the data. It is also very useful when you are forced to index on a key field (such as in a master detail relationship) but you need to set a range on another field.

Informations

• Status: Fully functional
• Source: Included
• Size: 12kB

Platforms: D1, D2, D3, D4

Description

TinyDB is a small, fast and very reliable database engine for developers in Delphi and C++Builder applications. It provides access to a flat file in its own format without BDE, and doesn't need any installation and configuration. With TinyDB engine, all data can be stored in only one database file. TinyDB engine is an ideal BDE replacement for small database applications in Delphi and C++Builder, and soon also for Kylix. Can be use as simple configuration database too as well.

Key Features:

• Inherited from TDataSet, supports all visual DB-aware components;
• Without BDE, and no DLL, no OCX;
• All data in ONE database file;
• Supports BLOB data Compression;
• Supports database Encryption, and CRC32 protection;
• Extended interface for data processing algorithms;
• Supports In-memory database;
• Supports Multi-indexes, and maximum records quantity over 100,000;
• TinyDB Desktop tool, detailed manual, and rich samples;

Complete update to Unicode Delphi and translate comments from Chinese to simply English (by JB.). For update to XE2 big thanks to Mr.Cervinka.

Informations

• Status: Fully functional
• Source: Included
• Size: 1 244kB

Platforms: D2005, D2006, D2007, D2009, D2010, DXE, DXE2, DXE3, DXE4, DXE5, DXE6

Description

TkbmConnectionPool contains TkbmPooledSession, TkbmPooledQuery and TkbmPooledStoredProc which handles pooled connections to a database. Very usefull in, for example, a WWW application as they also makes the BDE function threadsafe, and limits the concurrent connections to a database. Can be used instead of a TTable or TQuery.

Informations

• Status: Fully functional
• Source: Included
• Size: 20kB

Platforms: CB3, CB4, D3, D4

Description

TParadox allows you to read a Paradox 4.0+ table without using the BDE. It is short, fast and dumb. It reads the following field types correctly: Alpha, Date, Short, Integer, Auto-Increment, Money, Number, Logical, Bytes. BLOB fields only return the portion stored in the Table (e.g. a "M40" field would return only the first 40 chars of the Memo). Time, TimeStamp and BCD fields are not handled at all. It can find a record using the Primary Index, but can't use any secondary indexes.

Informations

• Status: Fully functional
• Source: Included
• Size: 9kB

Platforms: D4

Description

Ever needed to create a Paradox Datasource Name (DSN) on the fly from inside your Delphi code? We certainly have! This incredibly useful little Delphi component allows you to create, modify and delete DSNs at runtime from a Delphi application (32 bit only). Why would you want to do this? Quite often we (as developers at GWAcc) find ourselves having to climb into the control panel and muck around inside the ODBC32 applet. It gets annoying, especially if you have to do it several times in a row, even more so when it means having to switch between changing user names, passwords, paths, exclusivity... you get the idea.

Informations

• Status: Demo only
• Source: On purchase/registration
• price: $29.99
• Source price: $49.99
• Size: 105kB

Platforms: D4, D5, D6

Description

The ZeosLib is a set of database access components for Delphi and FreePascal/Lazarus. Supported Databases:

MySQL

PostgreSQL

Interbase

Firebird

MS SQL

SAP (Sybase) ASA / ASE

Oracle

SQLite

Features:

Support object for Sequences (Generators)

Support for Firebird, Interbase and PostgreSQL database events

Support object for retrieving database objects meta data

Support object for executing database scripts

Informations

• Status: Fully functional
• Source: Included
• Size: 2 209kB

Platforms: D10, D10.1, D10.2, D2005, D2006, D2007, D2009, D2010, D7, DXE, DXE2, DXE3, DXE4, DXE5, DXE6, DXE64, DXE7, DXE8

Description

Components for fast access to MySQL, PostgreSQL, Microsoft SQL, Oracle and Interbase SQL servers without use add-ons, such as BDE / ODBC / ADO. Besides, the components - sources of data are compatible with standard TDataset and have a number of additional features.

The library consists of:

• Low-level plain API for access to client part of MySQL, PostgreSQL and Interbase
• Low-level class API for access to MySQL, PostgreSQL and Interbase
• TZXXSqlDatabase components for representation of database connection
• TZXXSqlTransact components for transaction management
• TZXXSqlQuery components for executing of SQL-queries and viewing/editing of the contents of simple and complex selects
• TZXXSqlTable components for viewing and editing of database tables
• TZXXSqlMonitor components for viewing of outgoing queries to SQL-servers
• TZUpdateSql components for changing/deleting/adding of queries
• TZBatchSql for executing of SQL-scripts.
• more...

Informations

• Status: Fully functional
• Source: Included
• Size: 1 745kB

Platforms: D2005, D2006, D2007, D2009, D2010, D6, D7, DXE, DXE2, DXE3, DXE4, DXE5, DXE6, DXE64