MySQL - SPLessons

MySQL Connections and API’s

Chapter 30

SPLessons 5 Steps, 3 Clicks
5 Steps - 3 Clicks

MySQL Connections and API’s

MySQL Connections and API’s

shape Description

Connectors Administer Network to the MySQL server for the programs of user. APIs give low-level access to the MySQL convention and MySQL assets. MySQL Connections and API’s empower to interface and execute MySQL explanations from another dialect or to the settings, along with Perl, PHP, Ruby, ODBC, Java, Python with local C and installed MySQL illustrations.

MySQL Connections and API’s are the libraries and drivers that are used for associating the applications in MySQL Databases servers through various programming dialects. The Databases server and the application are impart over the system or can be on the similar machine.

Connectors

shape Description

Connectors Administer Network to the MySQL server for the programs of user. Oracle technology build up various connectors:

J-Connector

J-Connector prompts driver backing to interfacing with MySQL against the applications of Java by utilising common Database Connectivity API of java.

Net-Connector

Net-Connectors empowers clients for making .NET applications that are associate with MySQL. Net-Connector executes a completely utilitarian ADO.NET admix and gives backing to use with ADO.NET mindful apparatuses. Applications that utilize Connector/Net can be composed in any upheld .NET dialect.

Python-Connector

Python-Connector contributes the driver backing to interfacing with MySQL against Python operations utilizing an API that is consistent with the Python DB API form 2.0. No extra Python programs or MySQL user libraries are needed.

C-Connector

C-Connector is a stand down restoration by considering user Library of MySQL, that are utilised for C operations.

C++-Connector

C++ Connectors empowers C++ Operations to interface with MySQL.

ODBC-Connector

ODBC-Connectors administer the driver backing to associating with MySQL utilizing the free Database integrations of API. Backing is accessible for ODBC availability for Unix, Windows and OS X stages.

API’s

shape Description

APIs gives low-level access to the MySQL convention and MySQL assets. There are 2 methods of MySQL API’s. They are:

Libmysqld

Libmysqld is encapsulated in MySQL server library which empowers to implant an occurrence of the MySQL server within C operations. Libmysqld is incorporated into MySQL appropriations, yet not in C-Connector circulations.

Libmysqlclient

Libmysqlclient is incorporated into MySQL dispersions and in C-Connector circulations. 

Summary

shape Key Points

  • MySQL Connections – Administer network to the MySQL server for the programs of user.
  • MySQL API’s – give low-level access to the MySQL convention and MySQL assets.