3 ms·
Have you run your (mostly) database agnostic app at a large scale? When your app is running at scale, did you require any custom SQL or non-standard to the ORM
by criley2 12y ago
Have you run your (mostly) database agnostic app at a large scale?
When your app is running at scale, did you require any custom SQL or non-standard to the ORM stuff to get it running well?
In my experience with Rails, the "database agnostic" features are for prototyping, and by the time you're a real app moving towards some idea of scale, there is nothing "agnostic" about your ORM and database code...
- Joeboy 12y agoA fair point, I might be unduly influenced by having done a lot of work on a huge, unwieldy internal app. Running the tests in postgres took literally half a day, and there's no way we could have worked like that. In that case trading some db efficiency for actually being able to do work was a pretty easy decision, but horses for courses I guess.
- adamonduty 12y agoI've combined Postgres views and set returning functions in rails and had a lot of success with good performance and good maintainability, too. No custom SQL required in the application itself.