SPUG: spug-list Digest, Vol 111, Issue 1

[Michael]

Cant make it today. 

-- 
Michael


On Tuesday, September 18, 2012 at 12:00 PM, spug-list-request at pm.org wrote:

> Send spug-list mailing list submissions to
> spug-list at pm.org
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> http://mail.pm.org/mailman/listinfo/spug-list
> or, via email, send a message with subject or body 'help' to
> spug-list-request at pm.org
> 
> You can reach the person managing the list at
> spug-list-owner at pm.org
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of spug-list digest..."
> 
> 
> Today's Topics:
> 
> 1. Talk Tomorrow? (Webster)
> 2. Re: Talk Tomorrow? (Mark Swayne)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Mon, 17 Sep 2012 15:23:42 -0700
> From: Webster <webstermontego at gmail.com>
> To: spug-list at pm.org
> Subject: SPUG: Talk Tomorrow?
> Message-ID: <02A79FCC-FAC9-47DE-9766-8371BE0812E5 at gmail.com>
> Content-Type: text/plain; charset=us-ascii
> 
> There were some mentionings of a couple people that might be willing to give a talk tomorrow but I never heard anything definite. Is anyone willing to volunteer for tomorrow?
> 
> ------------------------------
> 
> Message: 2
> Date: Mon, 17 Sep 2012 19:44:15 -0700
> From: Mark Swayne <daotoad at gmail.com>
> To: Webster <webstermontego at gmail.com>
> Cc: spug-list at pm.org
> Subject: Re: SPUG: Talk Tomorrow?
> Message-ID:
> <CACYbuXTsTqzaNw6G-uah-J-WC2J2H57Ofw6vtd=tfYu2i+6yTg at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
> 
> I will be giving a talk on my SQL generation library called DBIx::PreQL.
> 
> DBIx::PreQL - Less awful SQL generation with templates
> 
> Executive Summary:
> 
> Do amazing things with SQL by sprinkling it with 7 characters: & | * #
> ? ! ~
> 
> Summary:
> 
> Nearly every programmer will work with relational databases at one time or
> another, if not every day. This means we have to work with SQL, whether we
> write our queries by hand or use an abstraction layer to generate them.
> 
> No generator is perfect, and sometimes you just have to write SQL to get
> the results you need.
> 
> DBIx::PreQL defines a small templating language that is designed to make it
> easy to manage groups of related, complex queries.
> 
> For example, if you have a webpage that sells widgets, you may have a bunch
> of nearly identical queries that provide:
> 
> * A list of available models of widget
> * A count of available models of widget
> * A count of widgets available of each type
> * The above three queries for discontinued models only.
> * The first three queries for currently available models only.
> 
> These queries are probably 90% identical, with only minor changes.
> 
> DBIx::PreQL addresses this problem by adding simple tags to the beginning
> of each line of SQL that are used to determine whether or not a line is
> included in the final query.
> 
> Here's a typical marked-up query:
> 
> * SELECT
> & count(*) !count!
> * model,
> * name,
> & status !~status!
> * FROM tbl_widget
> * WHERE
> & status = ?status?
> & AND model = ?model?
> & AND name LIKE ?name?
> 
> 
> 
> You can see DBIx::PreQL on github right now:
> https://github.com/daotoad/DBIx-PreQL
> I will be working like a feverish weasel tonight to get it uploaded to CPAN
> before the talk.
> 
> 
> 
> On Mon, Sep 17, 2012 at 3:23 PM, Webster <webstermontego at gmail.com> wrote:
> > There were some mentionings of a couple people that might be willing to
> 
> give a talk tomorrow but I never heard anything definite. Is anyone willing
> to volunteer for tomorrow?
> > _____________________________________________________________
> > Seattle Perl Users Group Mailing List
> > POST TO: spug-list at pm.org
> > SUBSCRIPTION: http://mail.pm.org/mailman/listinfo/spug-list
> > MEETINGS: 3rd Tuesdays
> > WEB PAGE: http://seattleperl.org/
> > 
> 
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mail.pm.org/pipermail/spug-list/attachments/20120917/b9262362/attachment-0001.html>
> 
> ------------------------------
> 
> Subject: Digest Footer
> 
> _______________________________________________
> spug-list mailing list
> spug-list at pm.org
> http://mail.pm.org/mailman/listinfo/spug-list
> 
> ------------------------------
> 
> End of spug-list Digest, Vol 111, Issue 1
> *****************************************
> 
> 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/spug-list/attachments/20120918/8745a2ed/attachment.html>