in reply to SQL with Berkely DB

Does anyone know of module that can take my existing SQL commands and use them to store and retrieve the data to xml/text files or Berkely instead of into MySQL?

DBD::AnyData can handle text, CSV, and XML files with the proper supporting modules. Maybe jZed, who is the author of said module, can add support for BerkeleyDB too, if he gets help of some people who desperately want it.

Note that I recommend against updating this kind of "database" in normal use, the whole file needs to be rewritten every time.

p.s. I'm a bit surprised you can get BerkeleyDB for free, while you have to pay extra for Mysql.

Replies are listed 'Best First'.
Re^2: SQL with Berkely DB
by jZed (Prior) on Apr 01, 2006 at 08:33 UTC
    Good idea, bart! But please change from the future tense to the past tense. My DBD::DBM has come as part of the DBI distribution for several years now. It handles many kinds of DBM files, including BerkeleyDB. It, like DBD::AnyData uses SQL::Statement as its SQL engine so look there for details of what SQL is supported but it makes use of MLDBM and the storage abilities of the various DBM files (including both DB_File and BerkeleyDB so doesn't operate the same way DBD::AnyData does.