Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re^2: Wisdom sought on migrating from text files to Berkeley DB or SQL

by punkish (Priest)
on Dec 23, 2004 at 04:48 UTC ( #416996=note: print w/ replies, xml ) Need Help??


in reply to Re: Wisdom sought on migrating from text files to Berkeley DB or SQL
in thread Wisdom sought on migrating from text files to Berkeley DB or SQL

For the record, eToys.com used Berkeley DB for caching data, and imdb.com used to use it extensively. I don't know if they still do.

So, did they use a regular rbdms to store the data, and to construct "answers" to complicated but frequently asked questions, and then they cached those answers in a Berkeley DB to quickly retrieve and display?

I can imagine that even trying to do simple rdbms things like MAX(), MIN(), BETWEEN, and GROUP kinda SQL stuff would be headache-inducing with BDB.


Comment on Re^2: Wisdom sought on migrating from text files to Berkeley DB or SQL
Re^3: Wisdom sought on migrating from text files to Berkeley DB or SQL
by perrin (Chancellor) on Dec 23, 2004 at 04:55 UTC
    In the case of eToys, it was a cache of frequently used data from an Oracle RDBMS. There are people doing serious work with Berkeley DB as their primary database, but I think they are more in the scientific or embedded systems fields.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (7)
As of 2014-08-20 22:42 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (124 votes), past polls