SPUG: spug-list Digest, Vol 111, Issue 1
Michael
mtshomsky at flowersandrobots.com
Tue Sep 18 18:43:25 PDT 2012
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>
More information about the spug-list
mailing list