NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
Disk-based data structures
9323
Disk-based data structures
http://www.wdvl.com/Authoring/Languages/Perl/PerlfortheWeb/index20.html
We've discussed the interaction between Perl and relational databases, courtesy of the DBI module, in several installments of the Perl You Need to Know. But suppose you don't want to get tied up with a relational database and all the supporting software needed, yet you still need to store a dataset to disk for future use. This month we'll look at several Perl DBM, or database management, solutions which have much less overheard than DBI and are a quick way to store and use Perl data structures to and from disk.
CGI and Perl > Tips and Tutorials > Database-related
Oct 11, 2006
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark Disk-based data structures: |
|||
Other links at CGI and Perl > Tips and Tutorials > Database-related
MySQL queries and the like can be executed with PERL via the MySQL Module. This module should already be installed with your web server if not contact your web host.
Category:
2. Perl DBI
The Perl DBI is a perl module that allows Perl users to interact with different types of databases through a single API. DBI means Database Independent, we can use this to talk to a MySQL database, an Oracle database and many more. The point of this module is, say with PHP we wish to use MySQL.. we would use the function mysql_connect(), a MySQL-dependent function. With the perl DBI we can use the same functions and objects to access many types of database, this makes code much more portable, and it makes it much easier.
To elborate, every perl DBI application has three levels. The Perl script, which uses the DBI module (level 2) to interact with the database (level 3). The job of the DBI level is to translate the information sent to it by the Perl script, into a language the database driver we're using can understand. In short, we don't have to write different code just because we're using different databases, DBI is our interpreter.
To elborate, every perl DBI application has three levels. The Perl script, which uses the DBI module (level 2) to interact with the database (level 3). The job of the DBI level is to translate the information sent to it by the Perl script, into a language the database driver we're using can understand. In short, we don't have to write different code just because we're using different databases, DBI is our interpreter.
Category:
There are plenty of articles on blobs, many more on perl and a countless number on mysql but very few on using mysql blob fields with perl. The few that I encountered assumed that the reader has a very wide understanding of perl.
This article tries to bridge that guide by not making such assumptions.
First of all we will be making use of DBI - the DataBase Independent inteface for perl. That means though this article deals with mysql, the code can easily work work other databases such as postgreSQL with little or no change. This code in fact happens to be a extracted from the mega upload perl edition. Please download it and look in the contrib folder for the full code and the sample database.
This article tries to bridge that guide by not making such assumptions.
First of all we will be making use of DBI - the DataBase Independent inteface for perl. That means though this article deals with mysql, the code can easily work work other databases such as postgreSQL with little or no change. This code in fact happens to be a extracted from the mega upload perl edition. Please download it and look in the contrib folder for the full code and the sample database.
Category:
We've discussed the interaction between Perl and relational databases, courtesy of the DBI module, in several installments of the Perl You Need to Know. But suppose you don't want to get tied up with a relational database and all the supporting software needed, yet you still need to store a dataset to disk for future use. This month we'll look at several Perl DBM, or database management, solutions which have much less overheard than DBI and are a quick way to store and use Perl data structures to and from disk.
Category:
To best understand MySQL we should start from above, like surveying a cityscape from a helicopter. MySQL operates on a client-server model, not unlike many other network applications. The MySQL server is the Grand Central Station for the city of MySQL -- the server handles incoming and outgoing traffic to and from a database. Any machine which you wish to process queries of a MySQL database must be running the MySQL server; in other words, Grand Central Station must be open for business for any traffic to arrive or depart.
The MySQL server is all-powerful: it can create and destroy. Databases are built, queried, and demolished using this server. One potentially confusing matter for some newcomers is that MySQL has no graphical interface; when we think of databases in Windows such as Access, we think of database creation and management in the model of the spreadsheet-like visual interface. Not so with MySQL, whose server takes action by commands only. Eventually, you may find that this is not nearly so horrible as it sounds.
The MySQL server is all-powerful: it can create and destroy. Databases are built, queried, and demolished using this server. One potentially confusing matter for some newcomers is that MySQL has no graphical interface; when we think of databases in Windows such as Access, we think of database creation and management in the model of the spreadsheet-like visual interface. Not so with MySQL, whose server takes action by commands only. Eventually, you may find that this is not nearly so horrible as it sounds.
Category:
Main Category
199
2044
829
286
175
1801
1439
913
1177
7568
70
917
59
2238
175
Join Mailing List
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.
Top 10
Directory Statistics
Links: 19869
Categories: 1275
Registered Users: 783
Mailing List Subscribers: 2049
Unique Outgoing Hits: 233720
Pagerank Statistics
PHP News