A while back, I put up bobby-tables.com as a repository for showing people the right way to handle external data in their SQL calls. Whenever someone pops up on a mailing list or IRC and they're building SQL statements using external tainted data, you can just refer them to the site.

In the past few days, I've spiffed up the site (with design help from Jeana Clark) and added pages on Perl and PHP. I need more examples, though. It's 2010, and there's no reason anyone shouldn't know about parameterized SQL calls.

The site source is hosted on github, so if you have any contributions, please fork it and let me know about your applied changes, or you can email me directly.

Thanks!

P.S. In the next few days, I hope to fire up some redesign on perl101.org, too.

These links are collected from the Perlbuzz Twitter feed. If you have suggestions for news bits, please mail me at andy@perlbuzz.com.

• Famous Perl One-Liners Explained, Part IV: String and Array Creation (catonmat.net)
• Run invdividual Test::Class methods in vim (blogs.perl.org)
• A regular expression tip every day from @regextip (and not just Perl regexes)
• A few resources for women in open source (itworld.com)
• The next QA hackathon: What do you need? (blogs.perl.org)
• YAPC::NA 2010 dates announced: June 21-23, 2010 (news.perlfoundation.org)
• Pod: Now with sane web links (justatheory.com)
• Creating mailing labels with PostScript::MailLabels (blog.worldlabel.com)
• Ten ways to destroy your community (coffee.geek.nz)
• Conferences on the cheap (blogs.stpcollaborative.com)
• Perl 5.11.4 available (xray.mpe.mpg.de)
• Using Perl to find best Wii bundle pricing (blogs.perl.org)
• Now's the chance for North Americans to easily get to a Nordic Perl Workshop (blogs.perl.org)
• What is Moose? (perltraining.com.au)
• Pretty Perl (blogs.perl.org)

These links are collected from the Perlbuzz Twitter feed. If you have suggestions for news bits, please mail me at andy@perlbuzz.com.

• Decoding climate change with Perl, gnuplot and Google Earth (radar.oreilly.com)
• Musical chord analysis with CPAN (use.perl.org)
• Schwern on a pet peeve of mine: Numbered test file abuse (use.perl.org)
• eumm-migrate - easy way to migrate to Module::Build (use.perl.org)
• Readable Perl (blogs.perl.org)
• CPAN's greatest hits: Path::Class (use.perl.org)
• Spreadsheet::WriteExcel now supports embedding charts (blogs.perl.org)
• Cool things in Perl 6: Subsets (blogs.perl.org)
• Ovid has written an INI file parser in Perl 6 (blogs.perl.org)
• Schedule for Perl Oasis 2010 in Florida posted (perloasis.org)
• Movable Type 5 released (movabletype.com)
• YAPC Europe Foundation has published its financials (use.perl.org)

Go run to the announcement about Devel::NYTProf v3.0. Marvel at the code profiling goodness.

Highlights include:

• Ability to profile opcodes, which means...
• NYTProf can now profile slow regular expressions
• More detailed stats on BEGIN blocks
• Treemap of subroutines
• Tracking of which subs called which other subs
• Graphing of sub calls
• Improved report output
• Ability to merge profile runs, such as when a process spawns other processes like mod_perl code does.

Already I have found that my regular expression compilation is taking 6% of the runtime in my sample runs in ack. I had no idea.

Just amazing. Go try it now, and buy Tim Bunce and the other contributors a beer.

These links are collected from the Perlbuzz Twitter feed. If you have suggestions for news bits, please mail me at andy@perlbuzz.com.

• How to import Gravatars into Gmail with 121 lines of Perl (dagolden.com)
• RT @davorg From Amazon.com: After viewing "Data Munging With Perl" 61% of customers buy "I Drink For A Reason" (@davorg is the author of the book)
• ack 1.92 is now out (betterthangrep.com)
• Why learn Perl in 2009? (news.ycombinator.com)
• Screencast about ack from @yerhot (fosscasts.com)
• Presenting Module::Starter 1.54 (use.perl.org)
• Make the pragmas stop! (justatheory.com)
• A collection of Perl one-liners (blogs.perl.org)
• Skud on how developers can make things easier for CPAN users unfamiliar with developer tools (infotrope.net)
• The problems with CGI (blogs.perl.org)
• SVK was end-of-lifed back in May. It was fantastic back when. (use.perl.org)
• Is Perl 5's object system really that bad? (use.perl.org)
• use Config; # discover your path (use.perl.org)
• Perl Foundation has a new Perl events mailing list (news.perlfoundation.org)
• lists.perl.org has been overhauled and updated (blogs.perl.org)
• Perl 5.11.3 now available (use.perl.org)

These links are collected from the Perlbuzz Twitter feed. If you have suggestions for news bits, please mail me at andy@perlbuzz.com.

• blogs.perl.org is a new, modern blogging platform for the Perl community (blogs.perl.org)
• Michael Peters gives thanks for some special folks in the Perl community (use.perl.org)
• Peteris Krumins explores secret Perl 5 operators (catonmat.net)
• Dave Rolsky talks about his Markdown parser, Markdent: (blog.urth.org)
• Using PUT and DELETE methods in web apps (blogs.perl.org)
• Tests are divine (blogs.perl.org)
• Perl advent calendars galore (perlbuzz.com)
• mirod releases a new version of xml_grep2 (blogs.perl.org)
• Introducing gitalist, a modern Git browser written in Perl (blogs.perl.org)
• Posting to CPAN from Github (blogs.perl.org)
• GitPAN's first success: Recreating the history for Pod::Simple (use.perl.org)
• Why use Kephra? (use.perl.org)
• Recap of Eric Whilhelm's Perl Foundation grant to overhaul learn.perl.org (news.perlfoundation.org)
• Using Perl to scrape the web (ssscripting.blogspot.com)
• Peteris Krumins publishes 30 projects on github (catonmat.net)
• cope, a command-line program colorizer in Perl (stuff.cytzol.org)
• The Perl way of avoiding repeated code: (blogs.perl.org)

By Matt Follett

It's the time of year for Advent Calendars and it looks like the Perl community isn't disappointing this year.

Perl Advent Calendar

The first day talks about using Package::Alias to alias Mouse to Moose.

RJBS Advent Calendar

Ricardo Signes' calendar to showcase things he has been working on. His first entry is about Sub::Exporter which looks very powerful.

Catalyst Advent Calendar

Perl 6 Advent Calendar

This one starts off with setting up Rakudo, so it requires very little prior knowledge.

SysAdvent

Tips for system administrators

All of these have RSS feeds, so they'll be easy to follow. Have fun!

Matt Follett is a developer in the Informatics team at The Genome Center at Washington University School of Medicine, where he works on high-throughput DNA sequencing projects. He is a graduate of the University of Missouri at Rolla, where he majored in Computer Science & Computer Engineering. He has worked for Monsanto, Boeing, and Beck Automation as a software engineer. He was the head of the 2009 St. Louis BarCamp. He currently resides in St. Louis, where he heads the local chapter of Perl Mongers.

By Ricardo Signes

Back when I first started learning Perl 5, I was excited to find the Perl Advent Calendar. It was a series of 24 or so short articles about useful Perl modules or techniques, with one new entry each day leading up to Christmas. A few years later, the Catalyst crew started the Catalyst Advent Calendar. I always liked the Perl Advent Calendars, and kept meaning to contribute. Every time, though there were too many things I'd want to write about -- and mostly they were my own code, so I felt sort of smarmy and self-promoting and never did it.

Finally, though, I'm glad to say I have tackled those feelings. I will not shy away from showing off my own code, and I will not worry about having to choose just one thing. This year, I will publish the RJBS Advent Calendar, 24+ full days of cool, useful, or stupid code that I have written and given as a gift to the rest of the CPAN community.

I've had a lot of fun working on this project, and it's helped me find and fix a number of little bugs or imperfections in the software I'll be talking about.

The first door opens in seven days. I hope it's as fun to read as it was to write. No returns will be accepted. Approximate actual cash value: $0.02

Ricardo Signes has written tons of modules on the CPAN, including Dist::Zilla, the heir apparent to Module::Starter. He is also a total sweetheart, and has a fuzzy head.

In a move of unparalleled beauty, Dave Cross and Aaron Crane have announced blogs.perl.org, a modern blogging platform for the Perl community.

Go look. Enjoy the non-ugly color scheme. Marvel at the code syntax highlighting and ability to embed images. Navigate posts using thoughtful categories.

A million thanks to Dave and Aaron for putting this together, and to Six Apart for the design. Links to feeds will be going up here on Perlbuzz as soon as I have time.

These links are collected from the Perlbuzz Twitter feed. If you have suggestions for news bits, please mail me at andy@perlbuzz.com.

• Pod::Simple 3.09 hits the CPAN (justatheory.com)
• Strawberry Perl and the nightmare of installing Padre (use.perl.org)
• A busy month for masak in Perl 6 (use.perl.org)
• A productive week in Rakudo-land (use.perl.org)
• Perl one-liners explained part III: Calculations (catonmat.net)
• Handy one-liner to lowercase all filenames in a directory: ls | perl -lne'$x=lc;print qq{mv $_ $x}' | sh -x
• Use CPAN's toolchain to improve your code (use.perl.org)
• Future Perl snuck up on me (headrattle.blogspot.com)
• Find the stupid bug in my progress indicator: say "$n so far" if ( $n % 100000 )";
• I maeked u a shell: lolshell, written in Perl 6 (theintersect.org)
• The horrible bug your command line Perl program probably has (perlbuzz.com)
• Frozen Perl 2010 looking for speakers (news.perlfoundation.org)
• apache2rest is a new framework for REST APIs under mod_perl2 (code.google.com)
• Putting MySQL on a ramdisk to speed up tests (use.perl.org)
• Generating Feedburner graphs (catonmat.net)