MySQL Questions

carlriz has asked for the wisdom of the Perl Monks concerning the following question:

Hello Perl'ers,

So, I have never used a database before. I am writing a script that makes http requests serially, url encoded, with search parameters using Berkeley Packet Capture syntax (I am writing test code for a packet capture machine). My problem is for some reason the server won't send a completed status, so I won't know when my request is finished. So, a walk around here is to connect to the DB, through my script, and query tables that show the request queue and requests completed, and print these to a file on my machine, for later use. Basically, I need some pointers on how to do this. Any help will be greatly appreciated! Once I figure this part out, I will post everything I got for anyone who wants to learn.

Comment on MySQL Questions

Replies are listed 'Best First'.
Re: MySQL Questions by hippo (Archbishop) on Mar 26, 2014 at 16:09 UTC
If you want to connect to a MySQL database you will almost certainly want to look at DBI and DBD::mysql. Plenty of good stuff in there and literally millions of examples around the net. However, your question as stated hints that perhaps this (using the database) is not the ideal solution. Why not explain with some code what the exact problem is with your HTTP requests in the first place? It could be that there is some simple solution to that problem.	[reply]

Replies are listed 'Best First'.

Re: MySQL Questions
by hippo (Archbishop) on Mar 26, 2014 at 16:09 UTC

If you want to connect to a MySQL database you will almost certainly want to look at DBI and DBD::mysql. Plenty of good stuff in there and literally millions of examples around the net.

However, your question as stated hints that perhaps this (using the database) is not the ideal solution. Why not explain with some code what the exact problem is with your HTTP requests in the first place? It could be that there is some simple solution to that problem.

[reply]