[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