Can we connect few models of a Rails 3 app to different type of database using the ActiveRecord adapter?

Question

Let there is a rails 3 app with two models, a Project and Notification using the ActiveRecord adapter with MySql.

Project has various states using state_machine and when its state changes, I want the notifications to be stored and retrieved back using MongoDb?

Can this be done using rails3?

Answer 1

ActiveRecord is for SQL driven databases, at least you can use ActiveModel and build some custom logic to handle MongoDb.

alternatively, you can use specific MongoDB adapters: MongoMapper or Mongoid