I have been learning Rails since this summer and have written some successful standalone apps with it, and really have grown to appreciate nearly everything about Rails.
However, my current project is writing Rails as a front-end to a database that will be used for other things (web services, data warehouses, other apps connecting) -- and I am realizing that ActiveRecord, and largely all the Rails developed around AR, seem to be very one directional when it comes to this approach.
Note: I am not referring to a Legacy database, ie. one that we have to plug into, but was designed "back in the day"..
Rails seems to think it is, and should be, the only application working with this data. I am noticing it more and more when it comes to things like, composite primary keys (which is something you cannot just adjust, like table naming and column naming).
While I know there is a composite key gem, I feel like I am developing an entire MVC application dependent on this single gem working. I fear I will run into more and more things like that. I have looked into alternative ORM's, however it seems that many gems depend on ActiveRecord.
I guess I am a bit surprised and saddened at this apparently selfish angle that ActiveRecord has.
Anyone have any feedback or success about how Rails works with an enterprise level database?