Cant make it today.
--
Michael
On Tuesday, September 18, 2012 at 12:00 PM, [email protected] wrote:
> Send spug-list mailing list submissions to
> [email protected]
>
> 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
> [email protected]
>
> You can reach the person managing the list at
> [email protected]
>
> 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 <[email protected]>
> To: [email protected]
> Subject: SPUG: Talk Tomorrow?
> Message-ID: <[email protected]>
> 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 <[email protected]>
> To: Webster <[email protected]>
> Cc: [email protected]
> Subject: Re: SPUG: Talk Tomorrow?
> Message-ID:
> <CACYbuXTsTqzaNw6G-uah-J-WC2J2H57Ofw6vtd=tfyu2i+6...@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 <[email protected]> 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: [email protected]
> > 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
> [email protected]
> http://mail.pm.org/mailman/listinfo/spug-list
>
> ------------------------------
>
> End of spug-list Digest, Vol 111, Issue 1
> *****************************************
>
>
_____________________________________________________________
Seattle Perl Users Group Mailing List
POST TO: [email protected]
SUBSCRIPTION: http://mail.pm.org/mailman/listinfo/spug-list
MEETINGS: 3rd Tuesdays
WEB PAGE: http://seattleperl.org/
