diff options
Diffstat (limited to 'databases/p5-Msql/pkg-descr')
-rw-r--r-- | databases/p5-Msql/pkg-descr | 71 |
1 files changed, 13 insertions, 58 deletions
diff --git a/databases/p5-Msql/pkg-descr b/databases/p5-Msql/pkg-descr index fd86725e90bc..c87518913b6d 100644 --- a/databases/p5-Msql/pkg-descr +++ b/databases/p5-Msql/pkg-descr @@ -1,58 +1,13 @@ -What you achieve with MsqlPerl ------------------------------- - -MsqlPerl is an interface between the perl programming language and the -mSQL programming API that comes with the mSQL relational database -management system. All functions provided by the mSQL programming API -are supported. - -From perl you activate the interface with the statement - - use Msql; - -After that you can connect to multiple msql database servers and send -multiple queries to any of them via an simple object oriented -interface. Two types of objects are available: database handles and -statement handles. Perl returns a database handle to the Connect -method like so: - - $dbh = Msql->connect($hostname,$databasename); - -Once you have connected to a database, you get a statement handle -with: - - $sth = $dbh->query("select foo from bar"); - -You can open as many queries as you like simultaneously by selecting a -different scalar to hold the object: - - $another_sth = $dbh->Query("select bar from foo"); - - -The statement handle allows you to step through the virtual table -returned from the database with the FetchRow method: - - @row = $sth->fetchrow; -or - %hash = $sth->fetchhash; - -You can access all metadata that mSQL supplies for a given table. To -find out the number of rows or the number of fields returned by a -query you simply say: - - $numrows = $sth->numrows; - $numfields = $sth->numfields; - -To find out the size in bytes for the field with the offset 0 (the -first field of a query), you say: - - $length = $sth->length->[0]; - -The list of the names for each column is returned by - - @list => $sth->name; - -As for other metadata available, consult the manpage that comes with -MsqlPerl and study the examples in the file t/msql.t, which is the -extensive testscript to test your installation, but is heavily -commented, so you may use it as a tutorial. +Msql.pm and DBD::mSQL implement two different approaches to +communicate with an mSQL server. DBD::mSQL is built upon the DBI, the +generic Perl Database Interface. It brings you an identical interface +to a broad variety of databases and is in this regard comparable to +ODBC. The advantage of the DBI approach is portability and +interoperability. Msql.pm is the elder species. It was written before +DBI was available but it was inspired by an early draft of the DBI +specification. As it has been circulating longer it is more mature and +pretty stable. It's also more complete than DBD::mSQL. + +Some day in the future DBD::mSQL will probably be the clearly superior +competitor in this package. Today you have to decide on your own about +the trade-offs. |