Re: Database File Advice

How about SQLite? The corresponding CPAN module is DBD::SQLite. If you decide to upgrade to an RDMS, you should be able to use The SQL Fairy without a hitch (not to mention you shouldn't have to change most of code either).

Also, take some time to familiarize yourself with DBD::AnyData. If you play your cards right, this project will write itself. ;)

jeffa

L-LL-L--L-LL-L--L-LL-L--
-R--R-RR-R--R-RR-R--R-RR
B--B--B--B--B--B--B--B--
H---H---H---H---H---H---
(the triplet paradiddle with high-hat)

Comment on Re: Database File Advice

Replies are listed 'Best First'.
Re: Re: Database File Advice by liz (Monsignor) on Jan 13, 2004 at 20:46 UTC
Too bad that you need to download and install most of CPAN to get SQL::Translater / The SQL Fairy installed. ;-( Liz	[reply]
Re: Re: Re: Database File Advice by Anonymous Monk on Jan 14, 2004 at 10:57 UTC
And that's a problem how? You should have most of those modules anyway (I will never be able to understand how people perceive prerequisites which shave years of development time as problems).	[reply]
Re: Re: Re: Re: Database File Advice by liz (Monsignor) on Jan 14, 2004 at 14:04 UTC
Remember that I'm only interested in altering database tables. I'm not interested in anything else. The actual dependency list from installing SQL::Translator is: `Class::Base GD GraphViz IPC::Run Graph Heap Math::Bezier IO::Scalar Parse::RecDescent Spreadsheet::ParseExcel OLE::Storage_Lite IO::Scalar Template AppConfig Test::Differences Text::Diff Algorithm::Diff Test::Exception Sub::Uplevel Test::Builder::Tester Text::RecordParser XML::Writer XML::XPath XML::Parser YAML` [download] Looking at this list, I can not understand why I would need GD, GraphViz or Template as I don't need visualizations. And these are not trivial modules to install. I don't really understand why I would need to install Spreadsheet::ParseExcel when I'm never going to use that (I only want to do MySQL <-> MySQL for a client). I would rather be able to have that be optional rather than being forced to install it. All in all, I'm forced to install modules of which I'm sure that I'm never going to use them. Worse, several modules just didn't install at all! Particularly GD doesn't install "just like that" without the right libraries pre-installed, and XML::Parser is another one that needs an external library to be properly set up. I perceive obligatory prerequisites for features I'm never going to use as a nuisance. It makes me seriously consider whether or not I would like to have SQL::Translator as a prerequisite for a module that I'm going to develop. Liz	[reply] [d/l]