[VPM] Victoria Perl Mongers meeting tomorrow
Peter Scott
Peter at PSDT.com
Mon Nov 15 03:32:00 CST 2004
Victoria.pm will meet at its regular date, time, and place tomorrow,
Tuesday, November 16, 7pm, at UVic. The location is Harry Hickman
Building room 120 (the Building Formerly Known As the Centre for
Innovative Teaching). See http://uvic.ca for maps if necessary.
-----------
Darren Duncan will give a sequel to his July 20th presentation, which
concerned how to make a trivial genealogy database-manager application
using Perl and a SQL database, SQLite to be specific.
The November meeting will focus on introducing Darren's new
CPAN-registered modules that strive to implement complete and rigorous
cross-database portability. The core modules are 'SQL::Routine' and
'Rosetta', plus 'Locale::KeyedText' and 'Rosetta::Engine::Generic'.
These modules should help you write database-using applications of any
size, that leverage all sorts of advanced database product features,
and support trivial (zero change) drop-in substitution between many
dozens of database products, such as: SQLite, MySQL, PostgreSQL,
Oracle, Sybase, Firebird, DB2, SQL Server, and more. Rosetta is
conceptually a DBI wrapper, whose strongest addition is SQL generation,
but it also works without DBI, and with non-SQL databases. The module
set's goal is similar to Java, where code written with it will run the
same way on any platform with zero changes. Its goal is to help free
users and developers from database vendor lock-in, such as that caused
by the investment in large quantities of vendor-specific code. It also
comes with a comprehensive validation suite that proves it is providing
identical behaviour no matter what the underlying database vendor is.
Darren's modules will be demonstrated in action using a version of the
trivial genealogy application that is modified to access the database
engine through those modules rather than directly. For simplicity, the
demonstration will use the trivial-to-install SQLite database
(DBD::SQLite 1.0.7). The same code used in the demonstration will be
on CPAN as a 'demo' accompanying the 'Rosetta' module, so it is kept in
a working state over time.
Note that these modules are still bleeding-edge and pre-alpha; while
they will work well enough next week to power the demonstration, most
other features are not quite finished yet.
-------------
Other topics to be covered as time permits; make requests for anything
particular.
I would also like to see a future presentation by someone that can talk
about how Perl is being used in a commercial application or something
of the same scale that they are familiar with.
(Courtesy copy to VLUG members by permission of the list
manager. Victoria.pm's home page is <http://victoria.pm.org/>.)
--
Peter Scott
Pacific Systems Design Technologies
http://www.perldebugged.com/
*** New! *** http://www.perlmedic.com/
More information about the Victoria-pm
mailing list