diff options
author | James FitzGibbon <jfitz@FreeBSD.org> | 1997-09-14 02:55:26 +0000 |
---|---|---|
committer | James FitzGibbon <jfitz@FreeBSD.org> | 1997-09-14 02:55:26 +0000 |
commit | d2efc9486f1083050f50eb2370bb60ddff7f3ee6 (patch) | |
tree | 29b3be796f2a09b2913cb59336bd0c6eaf24b909 /databases/p5-DBD-mysql/pkg-descr | |
parent | Style police. (diff) |
Mass upgrade of CPAN ports:
p5-Apache -> 1.00b2
p5-Array-PrintCols -> 2.0
p5-C-Scan -> 0.4
p5-DBD-Pg -> 0.62
p5-Data-Flow -> 0.05
p5-Devel-Peek -> 0.83
p5-HTML-Stream -> 1.40
p5-HTTPD-Tools -> 0.55
p5-Image-Size -> 2.4
p5-IniConf -> 0.92
p5-Msql -> 1.1809
p5-Mysql -> 1.1809
p5-PGP -> 0.3a
p5-Pg -> 1.6.1
p5-Tk -> 402.002
p5-WWW-Search -> 1.010
p5-libwww -> 5.12
Notes
Notes:
svn path=/head/; revision=7898
Diffstat (limited to 'databases/p5-DBD-mysql/pkg-descr')
-rw-r--r-- | databases/p5-DBD-mysql/pkg-descr | 71 |
1 files changed, 13 insertions, 58 deletions
diff --git a/databases/p5-DBD-mysql/pkg-descr b/databases/p5-DBD-mysql/pkg-descr index 72e2acba0c74..c87518913b6d 100644 --- a/databases/p5-DBD-mysql/pkg-descr +++ b/databases/p5-DBD-mysql/pkg-descr @@ -1,58 +1,13 @@ -What you achieve with MysqlPerl ------------------------------- - -MysqlPerl is an interface between the perl programming language and the -MySQL programming API that comes with the MySQL relational database -management system. All functions provided by the MySQL programming API -are supported. - -From perl you activate the interface with the statement - - use Mysql; - -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 = Mysql->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 MySQL 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 -MysqlPerl 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. |