From: Rick DeNatale Date: 2010-12-06T07:57:38+09:00 Subject: Re: Q: what database would you suggest? On Sun, Dec 5, 2010 at 4:30 PM, Diego Virasoro wrote: >> SQLite[0] might be worth a look, especially if you can split your data >> across several instances of SQLite. > > Thanks, I'll start with this then. > > Any suggestion on the ruby wrapper? It seems that DataMapper is pretty > good and "hides" some of the complexities of SQL. But I've heard of > Sequel as well, and some closer to the SQL code such as ruby-sqlite. > > Which one would you suggest to start? IMHO you should definitely have a look at the latest Rails 3 version of active record which uses arel https://github.com/rails/arel http://railscasts.com/episodes/202-active-record-queries-in-rails-3 http://railscasts.com/episodes/239-activerecord-relation-walkthrough Active record can be used separately from Rails, it always could but Rails 3 makes it easier to pick particular parts of Rails then ever. -- Rick DeNatale Blog: http://talklikeaduck.denhaven2.com/ Github: http://github.com/rubyredrick Twitter: @RickDeNatale WWR: http://www.workingwithrails.com/person/9021-rick-denatale LinkedIn: http://www.linkedin.com/in/rickdenatale