I'm interested in using ActiveRecord (AR) to build an API to a
glorified file catalogue with ~35 million and counting entries. It's
really an MD5sum catalogue with extra information granules about each
file to support web services like interaction. Firstly, I'm not a
computer scientist; just a hacking physicist with a little OOP
experience. In addition to AR for ORM, I'm planning to use MySQL
partition tables of type InnoDB.
In a private email, David H. said this combination looks compatible:
Ruby 1.8.6 or 1.8.7, AR and AS 2.2.2, MySQL 2.7 and MySQL Server
5.1.x. I'm trying not to bother David directly, for this related
The problem is that our admins will not install Ruby 1.8.6 or AR/AS
2.2.2, instead I'm allowed to have these versions "managed" by the
RedHat package manager: Ruby 1.8.5, AR/AS 2.1.1.
I plan to take advantage of simple implementations of these built in
technologies: transactions, callback macros, validation, association,
Are there any obvious problems with my setup?