Search Scripts - Web Development Scripts Directory

Find out how to manipulate Perl databases by using DBI - the Database Independent Interface module, which allows you to connect to a certain database from a Perl script, using a specific database driver (DBD). DBI architecture let you use multiple databases from different vendors in the same script program, regardless the database system you have in view.

DBI Perl Module (DBI stands for database-independent interface) is one of the most important Perl module designed to allow the use of SQl and mySQL queries, available on most platforms, including SQL Server, DB2, Oracle and MySQL.

This module allows the connection from a Perl script to different databases, using the appropriate database driver (DBD). The DBI Perl module (which is database independent) is responsible for loading at runtime the appropriate DBI driver which interfaces with the specific database.

For example, if we want to connect to MySQL database, we must use DBI and DBD::MySQL modules in the Perl script. We can use the driver DBD::ODBC too, which allow us to connect to many databases such as MS Access, Paradox, Oracle and so on. In the next figure you can see the architecture of a DBI Application.

Thus it is not necessary to know operational details of implementing the various databases, DBD modules providing the necessary interface and transmitting back to the DBI module results from the execution of the request.

DBD modules convert queries received from DBI module in a format according to the requested libraries database and return results to the DBI Perl module as a Perl data structure. In this way, the same script could use more DBD modules for access to various databases.

1. Distance Calculation using Latitude and Longitude in Perl
2. Mysql Data Manager
3. EasyData