Alomohora

ZeosDBO is a database middleware component for Borland development tools, including Delphi, C++ Builder and Kylix.

The following compilers are supported:

• Delphi 4 – 7.
• C++ Builder 4 – 6.
• Kylix 1 – 3.

ZeosDBO supports direct connectivity to the following databases using the vendor provided, native interface:

• MySQL 3.20 – 4.1
• PostgreSQL 6.5 – 7.3
• Firebird 1.0 – 1.5
• Interbase 5.0 – 7.5
• Microsoft SQL Server 7, 2000
• Sybase ASE 12.0, 12.5

For other databases we propose to use implemented Active Data Objects (ADO) Bridge.

Advantages of using ZeosDBO:

• Platform independence. The ZeosDBO is highly generic. Applications written in ZeosDBO can be migrated across databases without major changes.

• ZeosDBO is open source, written for usability and extensibility.

• ZeosDBO leverages the amazing power of the Delphi development environment without relying on a performance killing middleware.

• ZeosDBO is an extremely thin abstraction layer, unlike ‘thick’ layered protocols like ADO and BDE.

Package contents:

1. ZCore – Core classes and interfaces. Contains Java style objects and collections as well as compatibility types and functions.

2. ZParseSql – SQL specific for syntax and lexical analysis.

3. ZPlain – Native plain API to supported SQL servers.

4. ZDbc – Port of Java Database Connectivity API (JDBC 2.0). DBC API acts as intermediate layer between Plain API and highlevel TDataset or DBExpress components.

5. ZComponent – visual components descended from TDataset.

Installed components:

1. TZConnection: This component encapsulates the database connection and transaction management.

2. TZReadOnlyQuery: TDataset component to execute SQL queries and process data in read-only mode.

3. TZQuery: TDataset component which allows data modifications in regular and cached mode.

4. TZUpdateSQL: Analog of standard TUpdateSQL component to explicite definition of Insert/Update/Delete SQL statements for TDataset modifications.

5. TZStoredProc: The component to execute SQL stored procedures.

6. TZSQLProcessor: The component to execute SQL scripts for different SQL and various delimiter types.

7. TZSQLMonitor: The component to monitor all outgoing SQL queries and other logging information.

8. TZSQLMetadata: Specialized TDataset component which provides an access to database metadata such as tables, columns, indices, etc.

The project home page is here (for news, links and other project info): http://www.zeoslib.net

Related Posts:

1. What and Why LINQ
2. Install Packages Delphi
3. Make First Zeos Delphi Application
4. Delphi ZeosDBO Component
5. Introduction SQL