Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Poll: What database does your company use?

news.ycombinator.com

Post reply on HN
Print view View original

101–110 of 378 posts

Re: Poll: What database does your company use?

#101

Post by mmaunder »

InnoDB with clustered indexes is pretty hard to beat for many scenarios. I hate that Oracle owns it, but damn it works well. Also frequent cascading deletes are surprisingly fast, especially in high lock contention environments. [As a side note, it's unfortunate that Wordpress still uses MyISAM by default]

Redis has also been incredibly fast for our ad network. We throw around 7000 qps at the thing with a low number of writes and we haven't restarted the daemon for months. [Thanks Salvatore!]

Re: Poll: What database does your company use?

#104

Post by eftpotrm »

dragonquest wrote: post #69
eftpotrm wrote: post #10

Legacy apps, Ingres. All sorts of odd little things, SQL Server. Various legacy data processing and newer data warehousing jobs, SAS. New projects, in theory Oracle but there seems to be a degree of resistance. It'd be interesting to see how that pans out but I won't be around there much longer :)

Ingres is underrated, I find it quite ok to work with.

It might be good potentially but it certainly isn't as we're currently using it. Quite aside from the incredibly basic console apps we're having to use to browse and test against the DB server, performance isn't exactly its strong point and it has sometimes been crashed by running individual queries. I wasn't impressed.

Re: Poll: What database does your company use?

#105

Post by mryall »

KeyBoardG wrote: post #37
there wrote: post #4

flat files!

In school before learning SQL I wrote my personal site's blog on engine my own flat file database hack. :) Fun times.

Likewise. Perl's DBD::CSV module was my greatest discovery - SQL queries across flat files! No joins though. :)

Re: Poll: What database does your company use?

#106

Post by TillE »

Not really in the line of work where my company makes any significant use of database software, but I've been using Postgres lately for some personal projects. Based on my testing, it's a bit slower than MySQL but uses significantly less memory, which is important to me. Very happy so far.

Re: Poll: What database does your company use?

#107

Post by derobert »

asjo wrote: post #62
fara wrote: post #42

It's really hard to compare results between both polls. It would be nice if pg added the percentages next to each item, or at least sort them.

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.)

The bars are different sizes and in different orders, this makes it much harder to compare by flipping between browser tabs.
Post reply on HN