Gary Lawrence Murphy wrote:
>
> What is the smallest, simplest SQL-like database supported by DBI?
I would guess that DBD::AnyData is your best bet in this case. It will
work with your existing flatfiles (regardless if they are CSV, or Fixed
Length, or XML, or others) and fully supports DBI. If you do switch to
a real database backend later, the scripts you create using DBD::AnyData
should port over with very little modification. Its SQL is limited but
will be improving quite a bit in the next few months. In particular you
currently need to do joins across tables using multiple commands but
that will be changing soon.
Documentation and the modules are available at
http://www.vpservices.com/jeff/programs/AnyData/
Or on CPAN. You'll need both AnyData-0.05.tar.gz and
DBD-AnyData-0.05.tar.gz as well as the prerequistes listed in the
DBD-AnyData README.
Write if you have questions.
--
Jeff
