Poll: What database does your company use? • Hacker News Board

Re: Poll: What database does your company use?

#351

Post by ericflo » Thu, Jun 23, 2011, 5:29 PM UTC

ahik wrote: post #296

ericflo wrote: post #287

Earlier quoted context omitted.

Facebook for a long time didn't use the vastly (and I mean vastly ) improved open source version of Cassandra, instead opting for their internal fork. Instead of choosing to do so, I believe they have now switched to HBase, mainly for its easier consistency model. So I would take their advice with a grain of salt, because it's probably based on their experiences with an old fork. There are a few people (YC companies…

Eric, Jonathan Gray said it very clear at his talk at BerlinBuzz: Facebook is now using HBase instead of Cassandra. http://berlinbuzzwords.de/content/realtime-big-data-facebook... You can find a lot of info about the FB process to choose HBase in favor of Cassandra. This one for example: http://facility9.com/2010/11/18/facebook-messaging-hbase-com...

That's exactly what I'm talking about: that facility9 blog post explaining why they chose HBase had many factual errors about Cassandra when it was posted, and had to be revised after several respected people in the space contacted the author.

Re: Poll: What database does your company use?

#352

Post by asjo » Thu, Jun 23, 2011, 5:39 PM UTC

blntechie wrote: post #157

asjo wrote: post #62

Earlier quoted context omitted.

Here is a graph of this poll: http://koldfront.dk/misc/hn/database2011/data.png ... and one of the 2010 poll: http://koldfront.dk/misc/hn/database2010/data.png (Updated every ~4 hours currently; I will be fading out the update rate.)

Very surprising thing is the upward change in Microsoft SQL Server, that too in HN. On a lighter note, does this support the theory of HNers who complain that HN is not the same any more and it has been generalized?

Maybe more Microsoft SQL Server users follow Hacker News now than before?

Re: Poll: What database does your company use?

#353

Post by old-gregg » Thu, Jun 23, 2011, 5:43 PM UTC

rosser wrote: post #278

spitfire wrote: post #275

Earlier quoted context omitted.

I'll second this. For the longest time mysql was the quickest way on the web to lose your data. As in corrupt databases. It also didn't support transactions where postgres did. Essentially mysql was a dumb datastore with sql interface, whereas postgres was a database. That's changed now, but postgres is still a head in reliability(shit just doesn't break) and feature-set. and I hear in speed these days. But I no long…

Be very, very careful using SSDs under your DB, whether PostgreSQL or anything else. If you don't have supercaps on your drives, you will lose data in a power loss situation, even with a battery-backed RAID controller. That data loss could take the form of anything from silent corruption of a table or index, to unrecoverable filesystem loss. (Briefly, the drive's controller uses the on-board cache to accumulate write…

This is why I will be able to go back tonight and honestly say that I didn't waste time on Hacker News in the morning. :)

Thanks.

Re: Poll: What database does your company use?

#354

Post by Gerdus » Thu, Jun 23, 2011, 5:55 PM UTC

Other-Firebird

Re: Poll: What database does your company use?

#355

Post by mncolinlee » Thu, Jun 23, 2011, 5:59 PM UTC

As much as I like MySQL for a lot of purposes, it still has some catching up to do on PostGIS for applications requiring massive amounts of geospatial queries.

Re: Poll: What database does your company use?

#356

Post by rgnitz » Thu, Jun 23, 2011, 6:08 PM UTC

sjs wrote: post #279

jamwt wrote: post #70

Riak! We're ( http://bu.mp ) using more Riak every day. So far so good.

Hear hear! Mongo but no Riak? Come on.

Riak isn't in the same ballpark as MongoDB. They are closer to Hadoop.

Re: Poll: What database does your company use?

#357

Post by mschireson » Thu, Jun 23, 2011, 6:09 PM UTC

Quite interesting to me how the HN demographic has changed. Oracle usage is up dramatically from a year ago, and I don't think it's because Oracle has grown :)

Re: Poll: What database does your company use?

#358

Post by espeed » Thu, Jun 23, 2011, 6:18 PM UTC

gaius wrote: post #308

espeed wrote: post #5

You should add the Neo4j ( http://neo4j.org/ ) graph database to the list. Graphs are a much more modern and elegant way of storing relational data. I've used Postgres for over 10 years, but it's not a graph database. With graph databases you don't have to mess with tables or joins -- everything is implicitly joined. And Neo4j is ridiculously sweet -- store 32 billion nodes ( http://blog.neo4j.org/2011/03/neo4j-13-ab…

Sorry, but this is very amusing: IBM were doing this, with IMS, in the 1960s and IMS is still their highest-revenue product today.

But isn't IMB a hierarchical database (http://en.wikipedia.org/wiki/Hierarchical_database_model), which is a tree-like structure?

This is somewhat different than a general graph database (http://en.wikipedia.org/wiki/Graph_database) where nodes are not restricted to being a hierarchy.

Re: Poll: What database does your company use?

#359

Post by phlux » Thu, Jun 23, 2011, 6:25 PM UTC

It would be interesting to compare each companies profile to this list: # of employees + revenue + userbase + internal enterprise apps vs world facing web services.

Simply saying "I use XYZ" isnt really informative unless you know under which circumstance each was chosen.

Legacy requirements? New scrappy startup with no money? High performance need? Have shared DB stores across multiple departments/apps?

etc...

Re: Poll: What database does your company use?

#360

Post by jamwt » Thu, Jun 23, 2011, 7:45 PM UTC

StavrosK wrote: post #305

jamwt wrote: post #273

Earlier quoted context omitted.

> The test hasn't been a "concocted scenario" Btw, b/c I can totally see why you'd read it that way, that particular barb wasn't directed at you, more directed at some of the public benchmarks touted by (non-distributed) NoSQL database systems. Re: cassandra, please see my reply to the sibling on this thread. Also, feel free to email me jamie@bu.mp if I can answer any specific questions for you with things we ran int…

Can you make a blog post about the issues instead? It would greatly benefit everyone.

I'd love to, but there are things politically complicated about all this in the very small startup world. So maybe one day, but I can't do it right now.