Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery

Re: Perl's Hash vs BerkeleyDB vs MySQL

by ioannis (Parson)
on May 09, 2006 at 10:09 UTC ( #548167=note: print w/ replies, xml ) Need Help??

in reply to Perl's Hash vs BerkeleyDB vs MySQL

Previous replies focused on ACID properties, with this post I observe other kinds of differences:

Advantages of Perl Hash:

  • Easy to store a structure as value
  • Easy to later add more hashes (databases) , but in db4 you commit on it ahead of time.
  • Easier to store multiple values for a key (arrayref)
  • No need to worry about recovery and proper shutdown

Advantages of BerkelyDB (not the same as DB_File):

  • Easier to access values bases on combination of keys and values
  • Can to construct cursors (iterators)
  • Can construct custom indexes (not yet supported in the DB4 Perl api)
  • The first 4k of data are in memory, the rest on disk
  • Can add callbacks to modify the standard access and retrieval methods.

Comparisons with SQL databases miss the whole point of an embedded database. DB4 is not a multi-process system; it is an embedded database, a a C library intended meant to run in the same address space with the main program (when not using rpc). The general advantages and disadvantages of stand-alone models versus the client-server model should be noted.

Comment on Re: Perl's Hash vs BerkeleyDB vs MySQL
Replies are listed 'Best First'.
Re^2: Perl's Hash vs BerkeleyDB vs MySQL
by herveus (Parson) on May 09, 2006 at 11:46 UTC

    ...of course, you can have both if you use SQLite, as it's an embedded database *with* SQL and all those goodies...

Re^2: Perl's Hash vs BerkeleyDB vs MySQL
by perrin (Chancellor) on May 09, 2006 at 12:53 UTC
    A lot more than 4K of the BerkeleyDB data might also be in memory, in the shared memory cache.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://548167]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (6)
As of 2015-11-28 09:31 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (740 votes), past polls