Dear dbi-user regulars. I'm going to be mostly AFK (Away From Keyboard)
for the next couple of weeks (hooray!). If people have questions about
any of my modules which you can't answer in the interim, could you
please direct them to this message which has a summary of the most
commonly reported problems and latest status.
The current (August 2002) latest versions of modules I maintain or help
to maintain are:
AnyData 0.05
DBD::AnyData 0.05
DBD::CSV 0.2002
DBD::RAM use DBD::AnyData instead
DBI::PurePerl in DBI distribution
SQL::Statement 1.004
SQL::Parser 1.004
For general information and downloading the modules, see
http://search.cpan.org/search?mode=author&query=JZUCKER
* windows users, take note: these are all pure perl modules so
you can download them from that address, then use winzip to
unpack them and simply copy them to your standard perl
library location or to your own private library directory.
For information about the supported SQL syntax in any of the modules,
see the "Supported SQL Syntax" section of this URL (paste the URL together)
http://search.cpan.org/doc/JZUCKER/
SQL-Statement-1.004/lib/SQL/Parser.pm
For further information about the SQL modules, see
http://www.vpservices.com/jeff/programs/sql-compare.html
Latest report of known bugs in all modules:
DBD::CSV, DBD::AnyData, SQL::Statement, SQL::Parser
* Please make sure that you have the latest version and that,
if you want joins and other new SQL features that you are
using the latest version of SQL::Statement from my CPAN
directory shown above.
* Problems with the IN predicate in some situations -- sorry,
still working on it.
* Problems with dotted column names (e.g. tableA.columnB)
in some situations -- sorry, still working on it.
* Problems with inserting an empty string -- insert a NULL
instead (though the empty string thing should be fixed
soon).
* Problems with XML format or 'ad_convert', see under
"AnyData" below
* Note on installing DBD::AnyData -- make sure you've
installed AnyData and DBD::File (in the DBD::CSV
distribution) before installing DBD::AnyData; if the
make test hangs, it only impacts the XML format and
you can go ahead and install and use the other formats.
DBD::RAM
* DBD::RAM has been completely replaced by my newer module
DBD::AnyData which does everything DBD::RAM does and much
more. Please upgrade to DBD::AnyData.
AnyData
* Problems with adConvert() -- try to use adImport() and then
adExport() instead
* Problems with AnyData/Format/XML -- make sure you have the
latest version of XML::Twig (3.05 or higher); if your script
hangs, it is probably a flocking issue, try setting
HAS_FLOCK = 0 at the top of AnyData/Storage/File.pm *if* you
can get by without locking.
DBI::PurePerl
* No known bugs, if you find one, please report it to me with
a cc to the [EMAIL PROTECTED] mailing list.
Thanks!
--
Jeff
