[VPM] Meeting?

Darren Duncan darren at DarrenDuncan.net
Thu Sep 9 19:40:15 CDT 2004


At 4:21 PM -0700 9/9/04, Peter Scott wrote:
>At 10:44 AM 9/9/2004, you wrote:
>>I have actually put Parse::RecDescent to work in my module (that 
>>won't be in time for Sept), so his re-presentation could include an 
>>actual working example of moderate complexity (that parses 
>>VIEW/SELECT and PROCEDURE/FUNCTION create sql, for example).
>
>SQL::Statement won't do?

No.

SQL::Statement is very much under-powered relative to my module, and 
is so different that I'm better off trying to start from scratch than 
use it.  However, I can look at its source code and learn a few 
tidbits for how to do certain things.

SQL::Statement was written at least 6 years ago, and while it does 
see updates, it simply can not handle these commonly used database 
features, from what I can see: multiple table joins, compound 
queries, group-by, sub-selects, a lot of functions, named views and 
stored procedures, several data types, etc.  It can only handle the 
simplest kinds of selects and queries, and there is no support for 
any kind of relational database features.

Even that simple Genealogy database demo that I made for July 
wouldn't be able to run through it, since it uses joined tables.

SQL::Statement is designed to help implement simple database 
back-ends, such as DBD::CSV (a plain text file), and that's about it.

-- Darren Duncan


More information about the Victoria-pm mailing list