MySQL Point

Or interface database for Perl DBI is a Perl package that a developer can uniformly access to different databases. In an environment based on the property where the developer involved in such an ASP platform. NET consulting, interfaces to databases are preferred in one type of system management particular database (eg MS-SQL Server). However, in the open-source environment with PHP or Perl platforms, interfaces to databases are defined uniformly for different databases with the plug-in utilities, so that independent programmers can use SQL code to interact with the database. Each vendor database uses several library functions to access the rules database. Thus, in an organization's software outsourcing services to function, programmers have to write different set of codes to access the library functions, the previous requests, retrieving data, etc. for each new project. As for a solution that encapsulates the basic interface for Perl data, the process of interaction increases the portability of existing modules project. DBI with the DBD (database driver assigned to a package of specific database) interacts with the database and returns the result to the actual program. DBD Perl DBI modules can be used to interact with all the basic systems of leading data management. For example, interaction mysql DBD:: Oracle to connect to an Oracle database during the DBD:: with a MySQL database. Available for text-based CSV file, using the basic interface for Perl data DBD:: CSV module. Unlike the. NET platform for application development, interface database is homogeneous in nature (DBD:: ODBC is used for databases by Microsoft). Work DBI follows the following order: Charging the establishment of the DBI database connection and loading the DBD open a cursor with a SQL statement to retrieve the result of closing the cursor close the database connection end This has contributed to Perl DBI as a programming language to develop effective platform open-source because of the simplicity, ease of use and cost of deployment. With Perl regular expressions and syntactic constructions that DBI is certainly a blessing for all open source programmers.