Article needed: using MySQL with Perl

[dnmfarrell]

We need a MySQL-focused tutorial on using MySQL with Perl and DBI. The article should probably include:

• links to how to install/setup MySQL Server
• Installing DBI and DBD::MySQL
• connecting to the database
• executing queries with "do"
• how to read data from query results

We already have: https://www.perl.com/pub/1999/10/DBI.html/ (one of our most popular articles) https://www.perl.com/pub/2003/10/23/databases.html/ https://www.perl.com/pub/2002/11/27/classdbi.html/

[jacoby]

I think this can easily be split up into two articles:

• Perl, DBI and MySQL
• Perl, DBIx::Class and MySQL

I can do the first with a lot more fluidity than the second.

[dnmfarrell]

I agree, if you take the first, I can take the second as a "part II".

In part 1 you might want to mention mariadb as that seems to be the mysql variant of choice on linux. One thing that trips folks up with DBD::mysql more than anything are the database header file dependencies. It's probably enough to mention the ubuntu and dnf/yum package names (libmariadbclient-dev and mariadb-devel I think). Maybe MacOS too if you feel like it.

[jacoby]

I'd have to find a Mac user to bug. So, maybe.

On Tue, Oct 9, 2018 at 11:19 AM David Farrell [email protected] wrote:

I agree, if you take the first, I can take the second as a "part II".

In part 1 you might want to mention mariadb as that seems to be the mysql variant of choice on linux. One thing that trips folks up with DBD::mysql more than anything are the database header file dependencies. It's probably enough to mention the ubuntu and dnf/yum package names ( libmariadbclient-dev and mariadb-devel I think). Maybe MacOS too if you feel like it.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/tpf/perldotcom/issues/135#issuecomment-428234685, or mute the thread https://github.com/notifications/unsubscribe-auth/AADaz8MfJJ6ND5dgGtcdxWZsLTryWDg_ks5ujL6XgaJpZM4VfSPy .

-- Dave Jacoby [email protected]

Don't panic when the crisis is happening, or you won't enjoy it.

[jacoby]

And yes, I'll take the DBI part

On Tue, Oct 9, 2018 at 11:30 AM Dave Jacoby [email protected] wrote:

I'd have to find a Mac user to bug. So, maybe.

On Tue, Oct 9, 2018 at 11:19 AM David Farrell [email protected] wrote:

I agree, if you take the first, I can take the second as a "part II".

In part 1 you might want to mention mariadb as that seems to be the mysql variant of choice on linux. One thing that trips folks up with DBD::mysql more than anything are the database header file dependencies. It's probably enough to mention the ubuntu and dnf/yum package names ( libmariadbclient-dev and mariadb-devel I think). Maybe MacOS too if you feel like it.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/tpf/perldotcom/issues/135#issuecomment-428234685, or mute the thread https://github.com/notifications/unsubscribe-auth/AADaz8MfJJ6ND5dgGtcdxWZsLTryWDg_ks5ujL6XgaJpZM4VfSPy .

-- Dave Jacoby [email protected]

Don't panic when the crisis is happening, or you won't enjoy it.

-- Dave Jacoby [email protected]

Don't panic when the crisis is happening, or you won't enjoy it.

[welleozean77]

Hi Jacoby,

I can help out with testing on macOS, if you need. I work with MySQL on a Mac.

[jacoby]

@welleozean77 , I have a question. It's Perl -> DBI -> DBD::mysql -> MySQL server, and you need to have the developer libs to give DBD::mysql something to work with. But I don't run Mac, so I don't know how package management works on Mac for that. Anything you could add would be appreciated.

[welleozean77]

I have the following ecosystem: macOS HighSierra Perl 24.1 DBI+DBD::mysql And a MySQL I connect remotely

If this can be ok, tell me how can I help. Best

Am Sa., 27. Okt. 2018 um 20:36 Uhr schrieb Dave Jacoby < [email protected]>:

@welleozean77 https://github.com/welleozean77 , I have a question. It's Perl -> DBI -> DBD::mysql -> MySQL server, and you need to have the developer libs to give DBD::mysql something to work with. But I don't run Mac, so I don't know how package management works on Mac for that. Anything you could add would be appreciated.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/tpf/perldotcom/issues/135#issuecomment-433644846, or mute the thread https://github.com/notifications/unsubscribe-auth/AqSBwqSapAVAj3nflAIGCOavbs4U2UUQks5upKevgaJpZM4VfSPy .