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 <imjas...@gmail.com> 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 nodejs@googlegroups.com > To unsubscribe from this group, send email to > nodejs+unsubscr...@googlegroups.com > 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 nodejs@googlegroups.com To unsubscribe from this group, send email to nodejs+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/nodejs?hl=en?hl=en
