I have a multi-user application on Heroku (several accounts that don't know anything about each other), and I'm not sure how best to archive my database. Postgres schemas look amazing , but heroku doesn't handle a lot of them .
Now my Rails application mainly serves JSON, as most templates render the client side (using Backbone.js). Therefore, I am considering the possibility of switching to MongoDB, because 1) each tenant can get one “top-level” document, and everything can be attached below, and 2) its storage format resembles JSON so closely. We are still in beta, so it could be removed. Are these good reasons to use Mongo? Is the former even the smartest way to use Mongo?
If I were to stick with postgres, should everything belong to the top-level account model (with indexes)? If so, how do I handle connections? Is it possible to perform multi-index connections (total number of postgres noob)?
We have about 60 thousand records in one table, but one account can only have 200-1000, so I'm worried about joining the whole table.
Really appreciate any help.
Update:
We moved to VPS (Rackspace Cloud) and implemented postgres schemes. No regrets with this move, since it works much faster than on Heroku, and we have more control over the server.
source
share