Teaser: MySQL book

[Terra]

www.oreilly.com/catalog/msql/chapter/ch10-beta.html (http://www.oreilly.com/catalog/msql/chapter/ch10-beta.html)

--
Terra
--I need this yesterday!--
FutureQuest

[Rich]

Terra
--I need this yesterday!--
FutureQuest

ROFL. I've had this reserved for over 6 months now and the expected release date has changed twice (argh).

Well, at least we know they have 10 chapters done!

Rich
[This message has been edited by Rich (edited 05-24-99)]

[Stephen]

I love that cover. Kookaburra's if I'm not mistaken. I used to live in Brisbane, Australia, and would wake to the sound of those laughing birds (they sound pretty freaky!). Weird thing is I live in Southern California now, and on occasion I think I can still hear them.

I also can't wait for that book to come out. I installed MySQL on my Win98 PC and tinkered this weekend with a tutorial DBD::mysql script which builds a database of zipcodes and name places (did anyone realize that there are 29738 different US zipcodes?). I was pleased when I got the program going because it meant the Perl distribution that I downloaded from the official MySQL site appeared to allow me to program on my PC using the DBD::mysql interface.

But my joy was premature. There are 2 Perl distributions available at the MySQL site. Neither contains a functioning Sockets module (which I use for e-mailing), so that makes using them for testing purposes a little more difficult. Worse, the distributions don't appear to be stable. While I had no problems running my tutorial zipcode scripts, I've managed to crash my computer several times messing around with DBD::mysql calls.

I figured I'd install wwwthreads on my PC (which uses the DBD::mysql interface). After a long period of frustration I finally realized that I needed to place the wwwthreads.pm file on my @INC path to get the program working. Almost. With the current Perl distributions I have, wwwthreads never gets very far without killing my machine. So now I'm trying to figure out if there is a way of compiling the needed perl modules (DBD::mysql, Data::ShowTable) into the stable 5.00402 binary that's available from CPAN.

Has anybody had success trying to do something like this? I'll probably use the Cygwin32 C compiler on my machine if I can figure out how to go about it. Has anybody who reads these forums come up with a stable Perl/DBD::mysql combination for Windows? If so, I'm all ears...

Stephen

[DanS]

I needed this chapter 2 weeks ago.[nbsp][nbsp]Oh well...

[Stephen]

For the archives...

If anybody is thinking of using the Perl DBD::mysql interface on their Win32 PC this might be of interest to them--especially if you're not into compiling new modules for your current Perl distribution. After searching about for a stable Perl that supports the DBD drivers, I ended up at ActiveState's site www.ActiveState.com (http://www.ActiveState.com) and I'm now using their 'Perl for Win32'.

The nice thing about this distribution is that after downloading the core distribution you can use their 'perl package manager' to locate and install new modules without having to do practically anything. You simply type 'ppm' at your DOS prompt while logged on and end up in the ppm shell. From there, issue a command like search DBI to scan the ActiveState repositories for the module of interest. If it's found, type install DBI and it downloads and installs the new module, updates the documentation on your machine, and you're ready to go. In that respect it's like the Linux package managers.

If you're still using the 5.00402 binary available from CPAN you might want to check this out. I was glad I did. The only caveat is that the repositories are not that well developed yet and you may have to hunt around for the .ppd files that indicate where the modules can be found. Of interest to MySQL people is the DBD-mysql.pdd file and the associated DBD-mysql.tar.gz at ftp://www.mysql.com/pub/mysql/Contrib/ppd/

If anyone needs more information on how to install this once you have the ActiveState distribution let me know.
[This message has been edited by Stephen (edited 05-26-99)]