From: John Joyce <dangerwillrobinsondanger@...>
Date: 2007-05-04T04:27:32+09:00
Subject: Re: Beyond YAML? (scaling)


On May 4, 2007, at 12:35 AM, Bil Kleb wrote:

> Brian Candler wrote:
>> Use a SQL database?
>
> I always suspect that I should be doing that more often,
> but as my experience with databases is rather limited
> and infrequent, I always shy away from those as James
> already knows.  Regardless, I should probably overcome
> my aggressive incompetence one day!

Don't be afraid of the database solution. In the long term, it is  
much more scalable and will pay dividends immediately.
MySQL and PostgreSQL are both pretty fast and scalable, but if you  
have a large data set, you certainly do need to plan a schema  
carefully, but it should be somewhat similar to your existing data  
structures anyway.
the database APIs in Ruby are pretty simple.