|
Posted by Bill H on May 9, 2008, 9:18 am
Please log in for more thread options
I am about to dive into working with MySQL databases in perl and am
looking for any information you all may have on the subject, website
links, modules etc.
Bill H
|
|
Posted by Ted Zlatanov on May 9, 2008, 10:19 am
Please log in for more thread options
BH> I am about to dive into working with MySQL databases in perl and am
BH> looking for any information you all may have on the subject, website
BH> links, modules etc.
It depends on what you want to do. If you need high-volume stuff or
complex queries, learn MySQL well before you start with Perl. If you
are doing normal usage or don't care to write SQL by hand, get
Rose::DB::Object from CPAN and it will automate 95% of your database
interactions, plus it will work on most other DBI-compatible databases.
Ted
|
|
Posted by xhoster on May 9, 2008, 12:41 pm
Please log in for more thread options > I am about to dive into working with MySQL databases in perl and am
> looking for any information you all may have on the subject, website
> links, modules etc.
What do you already know about MySQL and Perl? What I mostly used
was:
"MySQL" by Paul DuBois
perldoc DBI
perldoc DBD::mysql
And I found them mostly satisfactory.
Xho
--
-------------------- http://NewsReader.Com/ --------------------
The costs of publication of this article were defrayed in part by the
payment of page charges. This article must therefore be hereby marked
advertisement in accordance with 18 U.S.C. Section 1734 solely to indicate
this fact.
|
|
Posted by cartercc on May 9, 2008, 2:20 pm
Please log in for more thread options > I am about to dive into working with MySQL databases in perl and am
> looking for any information you all may have on the subject, website
> links, modules etc.
>
> Bill H
Dubois wrote two books, one on MySQL and one on Perl and MySQL. The
one on Perl and MySQL is outstanding. I bought it years ago and am
still reading it. Yeah, it's that helpful.
On the database, look at PostgreSQL. It's far superior to MySQL, and
you can use Perl as the PL. It has far more in common with DB2 and
Oracle than with MySQL. I've used MySQL for about ten years and
PostgreSQL for almost four, and have had ample opportunity to compare
them side by side, and PostgreSQL is by far the superior product.
The big selling point for MySQL is speed, but there really isn't a
difference. I suppose if you get into big, industrial sized databases
MySQL may have a speed advantage, but if you are into big, industrial
sized databases, you won't be using MySQL.
CC
|
|
Posted by xhoster on May 9, 2008, 2:27 pm
Please log in for more thread options >
> The big selling point for MySQL is speed, but there really isn't a
> difference.
To me the biggest selling point of MySQL is simplicity, not speed. But
the speed is nice.
> I suppose if you get into big, industrial sized databases
> MySQL may have a speed advantage, but if you are into big, industrial
> sized databases, you won't be using MySQL.
I use MySQL for big, industrial sized databases. I also use Oracle for
other big, industrial sized databases. Horses for courses.
Xho
--
-------------------- http://NewsReader.Com/ --------------------
The costs of publication of this article were defrayed in part by the
payment of page charges. This article must therefore be hereby marked
advertisement in accordance with 18 U.S.C. Section 1734 solely to indicate
this fact.
|
| Similar Threads | Posted | | Msql-Mysql-modules: unable to find my mySQL 'include' dir | March 4, 2005, 2:57 am |
| can't install DBD::mysql - missing mysql.h? | November 30, 2004, 4:39 pm |
| Perl to MySQL? | December 9, 2004, 3:29 pm |
| Using MySQL with Perl | February 3, 2005, 6:31 pm |
| perl-mysql example | November 10, 2005, 11:10 am |
| Perl and MySQL | February 28, 2007, 12:44 pm |
| Perl/MySQL Question | December 29, 2004, 8:21 pm |
| perl mysql procedures | January 5, 2006, 10:21 pm |
| Perl / MySql / Shopping cart | December 3, 2004, 1:45 am |
| copy mysql database with perl | December 22, 2004, 9:36 pm |
|
XML Sitemap