user gmax  <font color="#000099"> <PRE> _/_/_/ _/_/_/ _/_/ _/_/_/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/_/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/_/_/ _/ _/ _/ _/_/_/ _/ _/ _/ _/_/  </PRE></font> <p><font color="#ff9966"><b>Savoir, savoir faire, faire, faire savoir.</b></font></p>  <p>Systems analyst and database designer, converted to Perl after a long mutual love with C. </p> <p>Currently working as MySQL Community Team lead with Sun Microsystems <strike>a QA developer for <a href="http://www.mysql.com">MySQL AB</a>,</strike> <strike>free-lance database designer and IT forensic consultant</strike>, loves C/C++, perl, women, linux, mysql, object-pascal, books and chess <I>(not necessarily in that order :-)</I></p> <p>I have used the [gmax] nickname since 1991, and I would like to state that I have no association to a game tool with the same name.</p> <p> <a href="http://gmax.oltrelinux.com/places.html">Places I visited</a> </p> <h3><font color="#669999">Articles (SQL & Perl):</font></h3> <table border=0> <tr><td> <A HREF="http://www.mysql.com/articles/wizard/index.html" >MySQL wizardry - cross tabulations</A> (off-site at <a href="http://www.mysql.com">MySQL.com</a>) </td> <td>A tutorial on how to create server-side cross-tabulations reports with MySQL and Perl. </td> </tr> <tr> <td> <a href="http://www.onlamp.com/pub/a/onlamp/2003/12/04/crosstabs.html">Generating Database Server-Side Cross Tabulations</a> (off-site at <a href="http://www.onlamp.com">OnLamp</a>) </td> <td>Theory and practice of server-side cross-tabulation with SQL and Perl.</td> </tr> </table> <h3><font color="#669999">My policy</font></h3> <p>I usually don't participate in flames. Nor I answer to gratuitous attacks. I apply Murphy's law about not getting engaged in a discussion with an idiot, since people couldn't tell the difference.</p> <pre> \|||/ (o o) ,----ooO--(_)-------. ,---------------------------------. | Please | | If you are arguing with a fool, | | don't feed the | | chances are he's doing the same | | TROLLs !! | | thing. | '--------------Ooo--' '---------------------------------' |__|__| || || ooO Ooo </pre> <p><small>I got the above ascii-art from<a href="http://jni.sdf-eu.org/trolls.html"> this usenet collection</a>. Thanks to [IlyaM] for [id://237707|providing the link].</small></p>     <h3><font color="#669999">CPAN Modules</font></h3> <table border=0 cellpadding=2 cellspacing=0> <tr> <td>Server-side cross tabulations</td> <td><a href="http://search.cpan.org/perldoc?DBIx::SQLCrosstab">DBIx::SQLCrosstab</a> </td> <td><a href="http://gmax.oltrelinux.com/cgi-bin/xtab.cgi">(Live sample)</a></td> <td><i>SQL and Perl wizardry together</i></td> </tr> <tr><td> Database Normalizer </td> <td> <a href="http://search.cpan.org/perldoc?DBSchema::Normalizer"> DBschema::Normalizer</a> </td> <td> <a href="http://search.cpan.org/search?dist=DBSchema-Normalizer" >(CPAN module)</a> <td><i>When Perl and SQL co-operate strictly</i></td> </td><tr> <tr><td> A parser for PGN files </td> <td> <a href="http://search.cpan.org/perldoc?Chess::PGN::Parse" >Chess::PGN::Parse</a> </td> <td> <a href="http://search.cpan.org/search?dist=Chess-PGN-Parse" >(CPAN module)</a> </td> <td><i>(Fruit of a joint venture with brother [hsmyers]).</i></td> </tr> </table> <h3><font color="#669999">Nodes</font></h3> <h4><font color="#0000FF">database programming</font></h4> <table border=0 > <tr> <td>[id://162771|The fine art of database programming].</td> <td>Why database programming is not easy.</td> </tr> <tr> <td>[id://284436]</td> <td>A collection of DBI idioms. (Now mentioned in <a href="http://search.cpan.org/~timb/DBI-1.39/Changes#Changes_in_DBI_1.39,_27th_November_2003"> DBI docs</a>)</td> </tr> <tr> <td>[id://264485|Before asking a database related question ...] </td> <td>Searching for solutions before asking for help.</td> </tr> <tr> <td>[id://132513|Normalization the easier way] </td> <td>How database programming could be less difficult. </td> </tr> <tr> <td>[id://273952|Speeding up the DBI] </td> <td>Improve the efficiency of your database apps with new DBI features. </td> </tr> <tr><td> [id://298213]</td><td>How to find your way through database learning</td> </tr> <tr> <td>[id://182023|DBI specification change] </td> <td>Something in the DBI docs to be aware of.</td> </tr> <tr> <td>[id://150255|Handling huge BLOB fields with DBI and MySQL] </td> <td>Stretching the database limits.</td> </tr> <tr> <td>[id://313934|SQL Crosstab, a hell of a DBI idiom]</td> <td>Analyzing the guts of a complex SQL builder.</td> </tr> </table> <h4><font color="#0000FF">Tutorials</font></h4> <table border=0> <tr><td>[id://153259|Tree::Dag_Node tutorial] </td> <td> The fascinating world of trees.</td></tr> <tr> <td> [id://270014] </td> <td> How to use Vim to compose off-line Perlmonks write-ups </td> </tr> </table> <h4><font color="#0000FF">Perl community</font></h4> <table border=0> <tr><td> [id://163993] </td> <td> The social impact of PerlMonks </td></tr> <tr><td> [id://134361] </td><td> On writing negative reviews </td></tr> <tr><td> [id://152185] </td><td> On answering with examples </td></tr> <tr><td> [id://136235] </td><td> On hiring a new developer </td></tr>  <tr><td> [id://344377] </td><td> [best nodes] on steroids! (<a href="http://gmax.oltrelinux.com/cgi-bin/cbnodes.cgi">live listings</a>)</td></tr> </table> <h4><font color="#0000FF">obfuscation</font></h4> <table border=0> <tr><td> [id://128986| Reusing Camel Code] </td> <td>Obfuscation turned into Software Engineering :-) </td></tr> <tr><td> [id://133561|The key to paradise (1)] [id://133730|and (2)] </td> <td> <I>Plain</I> Obfuscation (if there is such a thing) </td></tr> </table> <code> #/usr/bin/perl -w use strict;my%p= ("\40"=>chr(ord("\40" )*3-1).chr(ord("\40")+ord("\40")/4+7));$p{$p{"\40"}}="\40";print @{[map{my$o= $p{"\40"};@{[map{(($o=$p{$o})x$_)}map{ord($_)-(ord( "\40")*3 )-1}split//]},"\n"}split/n/,"uaqbnfdgcebcccbnebe" ."bcecc" ."gbndbeb" ."cbibi" ."bncdg" ."dcbib" ."nbbna" ."bnaaua" ."ubndd" ."ccgce" ."debcb" ."ncbeb" ."ebcbeb" ."cbebc" ."cnbbeb" ."ebcbebcbebcbcbnab" ."ebebecebebcbeb" ."na"]};# amen </code> <table> <tr><td> [id://136685|Perl Monk's dream]</td> <td>A multiple level obfuscation </td></tr> <tr><td> [id://140626]</td> <td>with its spoiler.</td> </tr> <td>[id://144594|Elusive monks] </td> <td> A running obfuscation</td> </tr> <tr><td>[id://155426] </td> <td>A different obfuscation. Wants to be fun :) </td></tr> <tr> <td>[id://157703]</td> <td>spoiler of the above</td></tr> <tr> <td>[id://309253|2 years]</td> <td>A celebration of a pleasant friendship with PM.</td></tr> </table> <h4><font color="#0000FF">various</font></h4> <table border=0> <tr> <td>[id://278232]</td><td>How curiosity can make you grow as a programmer.</td> </tr> <tr> <td>[id://135345|Perl's pearls]</td> <td> Notes on implementing an anagram algorithm in Perl </td> <tr>  <tr> <td> [id://141765|Editing features for advanced users]</td> <td>shows some powerful features for programming using a well known editor. </td></tr> <tr> <td> [id://314528|On-the-fly all-languages syntax highlighting]</td> <td>Syntax highlighting for the masses. </td></tr> <tr><td> [id://144335|In praise of Perl for admin tasks]</td> <td> is a praise of Perl for its original purpose. </td></tr> </table> <br/> <br/> <small><i>Data charmer drawing by Simon Goodway</i></small> 2011-06-21 15:36:55 20724 358145 229091 292 Sardinia, Italy</td></tr><tr><td>CPAN Directory:  </td><td><a href="http://search.cpan.org/author/GMAX/">GMAX</a> </td></tr><tr><td>Home page:  </td><td><a href="http://datacharmer.org/">the data charmer</a> -1 80 on