News for hackers. Stuff that matters.

Ask HN: It's 2012, what database solution do you now pick for a Web 2.0 site?

Congratulations, it's now the year 2012. Your ready to start a brand new Web 2.0 Website. Now all you need to do is pick a persistent storage (aka a database). Which one do you pick now?

You can choose the traditional paid SQL Server, Oracle or maybe the traditional unpaid MySQL. Older ones came up to replace it such as PostGresql. Then comes the nontraditional such as Cassandra, HBase, MongoDB, and so forth. With all these choices, which one does one now pick? How about if your not 100% sure how your site will scale in the future?

It's a startup, the idea will change as time goes on.

( 17 comments | 5 points | on HN )
Re:Ask HN: It's 2012, what database solution do you now pick... by patio11 on Tuesday May 22, 2012 @02:15AM (#4006481)
Pick whatever one the founding team will be most productive on. Now, try your damnedest to find a business where scaling problems are even on your radar.
Re:Ask HN: It's 2012, what database solution do you now pick... by diminium on Tuesday May 22, 2012 @01:42PM (#4008896)
How do you know which ones the founding team will be most productive on? Especially if none on your team are database pros?
Re:Ask HN: It's 2012, what database solution do you now pick... by rmc on Tuesday May 22, 2012 @03:46PM (#4009588)
Ask them what they have used most. Or if they haven't used a database, what framework are you using? Use the recommended one for that framework.
Re:Ask HN: It's 2012, what database solution do you now pick... by petervandijck on Friday May 25, 2012 @08:35PM (#4025983)
Ask whoever will be doing the programming.
Re:Ask HN: It's 2012, what database solution do you now pick... by dagw on Tuesday May 22, 2012 @06:52AM (#4007211)
After a couple of years of trying out most of the cool new NoSQL databases that have shown up as of late, I keep finding myself coming back to Postgres. The only new 'database' that I still use (and love) is Redis.
Re:Ask HN: It's 2012, what database solution do you now pick... by traxtech on Tuesday May 22, 2012 @12:34PM (#4008564)
I love PostgreSQL. I'm using it now on a startup project to seamlessly store and use graphs with 1M+ nodes and 25M+ links. The lack of pain surprises me.
Re:Ask HN: It's 2012, what database solution do you now pick... by kellros on Tuesday May 22, 2012 @06:20AM (#4007155)
I'd say pick the one that's compatible (or has great libraries) for what you are working in (eg. .NET, Rails, Django etc.). Especially in the beginning of a startup project, it's important to maintain efficiency.

From what I've seen, most start out with a RDBMS and switch to hybrid RDBMS/OODB later on. I've also seen some switch entirely to OODB from RDBMS and back into a hybrid.

There's also a case for schemaless document oriented databases like MongoDB. Honestly, I haven't seen 'serious' uses of document oriented databases other than for distributed caching.

In general, 'big' data needs structure.

One of days it might even become common to see most browsers support indexeddb (sql like) and local storage (kvp like).

So back to my point; efficiency, compatibility and familiarity is key for rapid application development, which is a must have for start-ups.

Re:Ask HN: It's 2012, what database solution do you now pick... by antonioevans on Friday May 25, 2012 @08:31AM (#4023185)
I think patio11 give great advice. Pick one that your founding team is comfortable with but I have a few suggestions.

If you are going to bring in off shore guys/gals it will be hard to find them proficient in some of the newer dbs. So the learning curve and cost inefficiencies maybe create a lost of momentum (time) for you. If I were to build my framework from scratch I would probably still use MySQL for certain thing but definitely move to a NoSQL (mongodb/dynamodb).

Re:Ask HN: It's 2012, what database solution do you now pick... by rmc on Tuesday May 22, 2012 @04:14AM (#4006842)
"older ones"? PostgreSQL is not an "older database". It is still being actively developed and used.
Re:Ask HN: It's 2012, what database solution do you now pick... by diminium on Tuesday May 22, 2012 @04:51AM (#4006939)
I was trying to say older that lost ground for a bit but is now turning into a highly recommended database option.

As for old, doesn't PostgreSQL have roots dating all the way back to 1982?

Re:Ask HN: It's 2012, what database solution do you now pick... by rmc on Tuesday May 22, 2012 @06:46AM (#4007193)
So does emacs, vim, BSD, Microsoft Windows, etc.! Just because some started a long time ago doesn't mean it hasn't been updated and should be ignored.
Re:Ask HN: It's 2012, what database solution do you now pick... by edgardcastro on Friday May 25, 2012 @10:10PM (#4026183)
Go with MySQL or PostgreSQL. Most of the programmers are savvy with them. This will give time to put your MVP in place and then you can work out a more scalable solution when time comes.

Early optimization is the root of all evil.

Re:Ask HN: It's 2012, what database solution do you now pick... by baptisteHM on Wednesday May 23, 2012 @09:09PM (#4016212)
It definitely depends on your team and what you guys are most experienced with. I like with with MySQL, but lately I've been working on some .NET projects where I had to use SQL Server and I love it.
Re:Ask HN: It's 2012, what database solution do you now pick... by antidoh on Tuesday May 22, 2012 @02:05AM (#4006451)
If you don't have an informed opinion, then pick the one that your framework lists as compatible. Multiple? Pick the one that seems to be first among equals in your framework's choices.
Re:Ask HN: It's 2012, what database solution do you now pick... by bsg75 on Tuesday May 22, 2012 @09:53PM (#4011101)
Redis + PostgreSQL - best of both worlds.
Re:Ask HN: It's 2012, what database solution do you now pick... by factorialboy on Tuesday May 22, 2012 @12:25PM (#4008539)
Depends on your use case, the app you're building and the structure of your data.

There isn't a one size fits all solution.

Re:Ask HN: It's 2012, what database solution do you now pick... by bazookaBen on Wednesday May 23, 2012 @10:34PM (#4016485)
Appengine + BigTable, bam. And I can move on to building the business (or finding one)