title: MongoDB and PostgreSQL thoughts
body: <p>I've got an app fully working with PostgreSQL. After reading about MongoDB, I was interested to see how the app would work with it. After a few weeks, I migrated the whole system to MongoDB.</p>
  
  <p>I like a few things with MongoDB. However, I found certain queries I was doing in PostgreSQL, I couldn't do efficiently in MongoDB. Especially, when I had to join several tables to calculate some logic. For example, <a href="https://stackoverflow.com/questions/4366417/need-suggestions-on-designing-artist-recommendation">this</a>.</p>
  
  <p>Moreover, I am using Ruby on Rails 3, and an ODM called Mongoid. Mongoid is still in beta release. Documentation was good, but again, at times I found the ODM to be very limiting compared to what Active Record offered with traditional (SQL) database systems.</p>
  
  <p>Even to this date, I feel more comfortable working with PostgreSQL than MongoDB. Only because I can join tables and do anything with the data. </p>
  
  <p>I've made two types of backups. One with PostgreSQL and the other with MongoDB. Some say, some apps are more suitable with one or the other type of db. Should I continue with MongoDB and eventually hope for its RoR ODM (Mongoid) to fully mature, or should I consider using PostgreSQL? </p>
  
  <p>A few more questions:
  1) Which one would be more suitable for developing a social networking site similar to Facebook.
  2) Which one would be more suitable for 4-page standard layout type of website (Home, Products, About, Contact)</p>