I would say it depends. If the content you are planning to store is very varied in shape (number of fields, structure) mongodb is is a very suitable candidate (shutterfly uses it to store all the metadata for uploaded photos which varies a lot depending on the camera that took the photo). If on the other hand the model is inherently relational then something like PostgreSQL is probably a better choice. Both scale well (there are large working installations for both). For storing blobs I would probably recommend using more specialized storage such as S3 or similar rather than the database even if they can do it.
That said I work for 10gen so I might be biased so keep that in mind :) On Friday, September 28, 2012 4:30:56 PM UTC+1, Matt Sergeant wrote: > > Personally, PostgreSQL all the way, on your own hardware. We have > benchmarked our postgreSQL instances to over 100k queries per second, and > they aren't even on SSD (although this assumes the dataset fits in memory). > And it's way more proven than MongoDB. > > On Thu, Sep 27, 2012 at 6:43 PM, Jason Nunnelley > <[email protected]<javascript:> > > wrote: > >> I'm building a node.js project that will grow to a large authentication >> data group (hopefully), and I'd like to make the right decision now. >> >> My options are: >> -- PostgreSQL sharding, like Instagram does >> -- MongoDB >> -- Something more creative >> >> I'll likely use some kind of VM solution like Amazon's EC2 or Rackspace >> instances for app servers, some kind of scaling mechanism that behaves >> similarly to HA Proxy (if not just HA Proxy), and I'd like to use some >> method of scaling dB servers to more easily grow to meet capacity needs. >> >> To add some context, we'll also need to store data like user generated >> content. I'm just looking for experience based opinions on which route >> makes the most sense. >> >> Basically, imagine you're building Instagram today from scratch. What >> tech would you use to handle storage? >> >> -- >> Job Board: http://jobs.nodejs.org/ >> Posting guidelines: >> https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines >> You received this message because you are subscribed to the Google >> Groups "nodejs" group. >> To post to this group, send email to [email protected]<javascript:> >> To unsubscribe from this group, send email to >> [email protected] <javascript:> >> For more options, visit this group at >> http://groups.google.com/group/nodejs?hl=en?hl=en >> > > -- Job Board: http://jobs.nodejs.org/ Posting guidelines: https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines You received this message because you are subscribed to the Google Groups "nodejs" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nodejs?hl=en?hl=en
