in reply to SQL vs Berkeley

merlyn is totally right, but lemme elaborate. Looking at your types of data (large amounts of text and binary) the Berkeley system is going to be way too small for what you're working with. Think of the Berkeley DB as a hash table that's stored to disk; it's great for some things, but comparing it to a relational database is like comparing a car to an F-16.

With MySQL you'll be able to store massive amounts of text data in TEXT columns with virtually no limit - you can do the same for binary data using BLOB. Be warned though - coding for MySQL using the DBI driver is a lot trickier than using the Berkeley DB interfaces.

Replies are listed 'Best First'.
Re: Re: SQL vs Berkeley
by Starky (Chaplain) on Feb 12, 2002 at 02:13 UTC
    I would concur with other replies in that MySQL will probably be the best choice for anything other than simple data requirements.

    However, I would differ in my estimation of how much more difficult it will be than working with DBM. Once you get going, it's really not that hard at all.

    My recommendation would be to find someone who has worked with Perl and MySQL before (there are loads of them out there -- check a local Perl Mongers group if you don't have a friend or friend of a friend who can help or send me an e-mail if you are really stuck), have them help you set up a database, and run a sample query.

    It would take about an hour to step through it all from downloading MySQL to getting the results of your first sample query. And using MySQL will give you more real-world practical experience that you can apply later to more complex problems.

    Hope this helps :-)

Re: Re: SQL vs Berkeley
by ignatz (Vicar) on Feb 12, 2002 at 11:10 UTC
    I'm not sure that I would call MySQL an F-16. More of a cropduster.