. .

YAPC::EU 2010 - The Renaissance of Perl



Shooting from the hip : Perl at the command line for DBAs

Shooting from the hip : Perl at the command line for DBAs

By Giuseppe Maxia (‎gmax‎)
Date: Friday, 6 August 2010 10:30
Duration: 50 minutes
Target audience: Intermediate
Language: English
Tags: bash command line mysql perl

You can find more information on the speaker's site:

There are many GUI applications to deal with databases and with MySQL in particular. But for die hard command line enthusiasts, who grew up with Linux, the shell prompt is still prince. You would be surprised at the vast amount of operations that you can do from the command line, and then many would surely marvel at the amount of work that a Perl one-liner can do.
By combining shell and Perl, you get the kind of power that all DBAs dream, but few achieve.
Running commands on several databases at once, filtering users, getting detailed metadata, transferring data from the operating system to a database and the other way around, creating scripts from database data, creating SQL
commands from database data. That, and more, you can learn by attending this session. Learn the art of the command line as a shortcut to quick and
efficient administration, and as help for demanding developers.

Attended by: Markus Pinkert (‎Bedivere‎), Mario Rossano (‎Anak‎), John Scoles (‎byterock‎), Oliver Thieke (‎o-thieke‎), Alan Haggai Alavi (‎alanhaggai‎), Tina Müller (‎tinita‎), simotrone, Francesco Rivetti (‎oha‎), Michal Gawlik, Giuseppe Maxia (‎gmax‎), Damon Davison (‎allolex‎), Francoise Dehinbo (‎franky‎), Fernando Santagata, Lars Thegler (‎tagg‎), Stefano Rodighiero (‎larsen‎), Fulvio Scapin (‎trantorvega‎), Adeola Awoyemi (‎dialog‎),

Our sponsors


  • Booking.Com
  • YAPC::Europe 2009
  • cPanel


  • Shadowcat
  • 123 people
  • Venda
  • Dada


  • YAPC::Europe Foundation
  • Smart Open Software
  • MySQL
  • Exonetric
  • pair Networks


  • GitHub
  • Italpro
  • Geoesse
  • $foo Perl Magazin
  • Lokku
  • Apress
  • No Starch Press
  • O'Reilly Media

Media Partners

  • Linux Magazine


  • Regione Toscana
  • Comune di Pisa