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

Tue, 18 Sep 2012 19:19:54 -0700

All you guys who didn't come missed out, great talk Mark!

-- Sent from my Palm Pre on Verizon Wireless

On Sep 18, 2012 6:44 PM, Michael <[email protected]> wrote:

Cant make it today.

--
Michael

On Tuesday, September 18, 2012 at 12:00 PM, [email protected] wrote:

Send spug-list mailing list submissions to

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

You can reach the person managing the list at

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]>
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]>
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
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
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/

Reply via email to