summaryrefslogtreecommitdiff
path: root/databases/p5-DBD-mysql/pkg-descr
diff options
context:
space:
mode:
authorJames FitzGibbon <jfitz@FreeBSD.org>1997-09-14 02:55:26 +0000
committerJames FitzGibbon <jfitz@FreeBSD.org>1997-09-14 02:55:26 +0000
commitd2efc9486f1083050f50eb2370bb60ddff7f3ee6 (patch)
tree29b3be796f2a09b2913cb59336bd0c6eaf24b909 /databases/p5-DBD-mysql/pkg-descr
parentStyle 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-descr71
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.