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

[punkish]

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.

[perrin]

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.