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 ***@***.***> 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 <#135 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AADaz8MfJJ6ND5dgGtcdxWZsLTryWDg_ks5ujL6XgaJpZM4VfSPy> .

-- Dave Jacoby jacoby.david@gmail.com 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 ***@***.***> wrote: I'd have to find a Mac user to bug. So, maybe. On Tue, Oct 9, 2018 at 11:19 AM David Farrell ***@***.***> 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 > <#135 (comment)>, > or mute the thread > <https://github.com/notifications/unsubscribe-auth/AADaz8MfJJ6ND5dgGtcdxWZsLTryWDg_ks5ujL6XgaJpZM4VfSPy> > . > -- Dave Jacoby ***@***.*** Don't panic when the crisis is happening, or you won't enjoy it.

-- Dave Jacoby jacoby.david@gmail.com 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 < notifications@github.com>:

…

@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 <#135 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AqSBwqSapAVAj3nflAIGCOavbs4U2UUQks5upKevgaJpZM4VfSPy> .