[VPM] ANNOUNCE: SQL-Routine-SQLBuilder 0.18 (and SQL-Routine 0.62)
Darren Duncan
darren at DarrenDuncan.net
Fri May 13 20:06:53 PDT 2005
2005-05-13 Darren Duncan <perl at DarrenDuncan.net>
--------------------------------------------------
Special Friday the 13th Release!
Version 0.62 of SQL::Routine (SRT), a fully atomic and portable
abstract syntax tree to define any database tasks, has been uploaded
to CPAN; it should appear on your favorite mirror within the next few
hours.
http://search.cpan.org/dist/SQL-Routine/
So has version 0.18 of SQL::Routine::SQLBuilder, a reference
implementation of a
SQL:2003 string builder (plus other SQL variants) for SQL::Routine.
http://search.cpan.org/dist/SQL-Routine-SQLBuilder/
So has version 1.04 of Locale::KeyedText, version 0.45 of Rosetta,
and version 0.18 of Rosetta::Engine::Generic.
This release of SQL::Routine::SQLBuilder is particularly significant,
and worth announcing, because it is the first release to actually be
executed. Prior versions were simply known to compile. A bunch of
small bug fixes and compatability updates were also made (details in
'Changes'), but no large changes were necessary.
The new test suite for that module demonstrates the ability to
generate SQL to create and drop database schema objects that are base
tables (tables) and viewed tables (views) from SQL::Routine models,
and in 3 SQL variants for each (uppercased and lowercased
non-delimited identifiers, and case-preserving delimited
identifiers). For both object types, multiple data types are
represented, as are foreign keys and aliased joins between a table
and itself.
Various other updates were made that are detailed in the 'Changes'
files. Chief among them is that all the test suites were reorganized
into multiple files that are better organized.
Subsequent releases will see improved input validation in
SQL::Routine, and the demonstrated ability to generate other kinds of
SQL in SQLBuilder.
Any questions, feedback, requests, or offers of assistence with the
module are welcome and appreciated.
Thank you and have a good day. -- Darren Duncan
More information about the Victoria-pm
mailing list