Net::MySQL vs DBD::mysql vs Msql

[max1x]

I have found all 3 modules above that can be used as gateways to connect to MySQL. I am unable to install DBD::MySql due to missing mysql.h and mysql_version.h, files and reinstalling MySQL is not an option (at least not at present), running Sol-10.

I was able to install Net::MySQL (pure perl) and reviewed Msql, but wanted to get expert opinions on pros/cons before I went into a direction.

 

[KevinADC]

If it is your only option I suggest giving it a try and see how well it works. It is a fairly new module so I suspect few people have yet to use it.

------------------------------------------
- Kevin, perl coder unexceptional!

 

[ishnid]

The usual recommendation would be to use the database-independent DBI module, using DBD::mysql as the driver.

 

[PaulTEG]

Can't you find versions of the include files you need?

Paul
------------------------------------
Spend an hour a week on CPAN, helps cure all known programming ailments ;-)

 

[max1x]

Kevin,
Thx for the feedback, I've Net::Mysql to have little documentation, but I'll work further with it today.

ishnid,

DBD::mysql won't install due to missing .h files, I've tried via MCPAN -e shell using perlgcc and then manually, which led to finding the missing mysql.h
and mysql_version.h, hence no luck there.

Paul,

I've looked every where and can't seem to find independent .h files for S10, vs 5.xx for mysql anywhere. I'll try to do another search.

 

[travs69]

what OS/version perl version are you working with?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those who say it cannot be done are usually interrupted by someone else doing it; Give the wrong symptoms, get the wrong solutions;

 

[max1x]

5.8.4 is what the server displays.