Connection Between MSQL Tools And Other Programs
Programming language Perl has turned from the tool used mainly by managers of Unix-systems, in the most widespread platform of development for World Wide Web. Perl did not intend initially for Web, but simplicity of its use and powerful functions for work with the text have made natural its application for CGI-programming.
In the similar image when MSQL for the first time has come on the stage, exclusive compactness and speed of performance have made its very attractive to Web developers who needed to serve thousand operations daily. MYSQL with its high speed and the expanded opportunities became even more attractive means for web-developers. Naturally therefore a Perl interface has been developed to both bases - MYSQL and MSQL, - thus having united their advantages.
When this material was written, there were two interfaces between Perl and MYSQL with MSQL. Earlier consists of specialized interfaces Myaql.pm and Msql.pm, which work only with MYSQL and MSQL accordingly. The other newer interface is a connected module in complete set of DBI (Database Independent) - modules, independent of a database.
DBI is an attempt to provide general Perl API for access to any databases and granting of higher bearableness. Interface DBI became the most reliable and standard, and MYSQL developers recommend using only DBI as the further development of modules Mysql.pm and Msql.pm is stopped.
DBD/DBI interface is a recommended method of access to MYSQL and MSQL databases from Perl. DBD/DBI means DataBase Dependent/DataBase Independent. The name is connected with the two-circled realization of the interface. In the bottom circle there is a level dependent on a database. On it there are modules for each type of a database accessible from Perl. Atop of this level there is a level, which is independent of database. It is that interface, which you use at access to the database. The benefit of such scheme is that the programmer needs to know only one API level of database independence. When there is a new database, it is necessary to write only DBD module (dependent) for it, and it becomes accessible to all programmers using DBD/DBI.
Terms And Conditions Privacy Contact Us
|