Monday, October 01, 2007

Top 10 Dephi components to access MySQL


An overview of VCL components allowing you to access a MySQL database from Delphi using standard data controls without using BDE/ADO/ODBC. Plus a few MYSQL related tools. MySQL a reliable, fast, compact, powerful and multi-platform multi-threaded open-source database server.

1. mysql.pas

mysql.pas is a Pascal translation of mysql.h and two other C header files needed for writing clients for the MySQL database server. The unit has been tested and compiles on Borland Delphi 4, 5, and 6. Free.

2. TmySQL

TmySQL provides access to MySQL servers from Delphi via a visual component and an extendable non-visual component. TmySQL utilizes a single client DLL, which is provided by most Windows-compiled versions of MySQL. TmySQL does not use the database aware components in Delphi, such as TDatabase, TQuery, etc. Open Source.

3. MySQL Dataset Component

A set of Delphi Components for easy access of MySQL. The included components are: TParser - component to calculate formulas; TMySQLDatabase - component to access a MySQL Database; TMySQLTransact - component to post updates directly to the MySQL server, or via the ZEOS Transact server; TMySQLQuery - Full-featured TDataset class. GPL Public License.


MySQLDAC is MySQL BDE replacement. This components set allows to create Delphi applications with direct access to MySQL DB without BDE and ODBC. BLOB fields are supported. MySQLDAC was developed for easy migration of existing projects from BDE/ODBC scheme to the native one. TDBImageEx component for JPEG images support included in package for free (with sources). MySQLDAC is royalty free product.

5. MySQL ODBC Drivers

MySQL ODBC drivers allow you to connect to MySQL running on your Virtual Private Server from your PC and import/export databases. Handy tool for exporting an MS Access Database to MySQL and vice versa.

6. MySQL Components

The TMySQLComponents consists of TMySQLServer and TMySQLDataset. The purpose of these components is to give you full direct access to all MySQL server's feature using your standard data aware controls in either Delphi or Kylix without the BDE or dbExpress limitations. The components are Single Source and will thus compile in either Delphi 5/6 or Kylix 1/2 using the same source files. Commercial.

7. MySQL Data Access Components (MyDAC)

MyDAC library offers a set of nonvisual components for Borland Delphi, C++ Builder and Kylix. They provide access to MySQL database and are an alternative to a standard way of accessing databases using Borland Database Engine (BDE) and ODBC. MyDAC includes following components: TMyConnection, TMyQuery, TMyCommand, TMyTable, TMySQLMonitor, TMyConnectDialog , TVirtualTable. Commercial.

8. PremiumSoft MySQL Studio

A set of graphical database management, reporting and monitoring tools for MySQL database systems. From its fresh, new look to its intuitive, task-based navigation, PremiumSoft MySQL Studio makes it easier than ever to use your databases. Commercial.

9. Direct SQL

The main idea of the project is to have cross-platform (Windows+Linux) delphi native components for directly accesing SQL servers (without using any externall dll's). The first releas will be for My-sql and Interbase, but there are plans to be extendend. GNU General Public License.

10. Zeos Library

Components for fast access to MySql, PostgreSql, MicrosoftSQL, 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. Open Source.

Pinpoint customers who are looking for what you sell.