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

151–160 of 378 posts

Re: Poll: What database does your company use?

#151

Post by davidhollander »

mmaunder wrote: post #101

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…

>InnoDB with clustered indexes is pretty hard to beat for many scenarios. I hate that Oracle owns it, but damn it works well.

After Oracle stopped distributing the source on their website, an open-source project started continuing its development here: http://www.haildb.com/

Re: Poll: What database does your company use?

#152

Post by shizcakes »

SwellJoe wrote: post #56
thechangelog wrote: post #16

SQLite all over the place – it's great having a super portable DB format for quick little hits. There's nothing quite like sending a DB as an email attachment.

SQLite is so pervasive that I'm pretty sure everyone uses it at some point. It's in client applications, it's used by yum (the package manager found on CentOS/RHEL/Scientific Linux systems), it's part of many web applications, it's part of many spam filtering systems, it's part of Android (maybe iOS, too?), it's basically impossible to avoid it if you're a nerd. Also, it's awesome.

Firefox uses it.

Re: Poll: What database does your company use?

#153

Post by blntechie »

s00pcan wrote: post #90

SQL Server unfortunately. I was reminded why I hate it today when I was trying to set up a simple remote connection to the instance running on my new Windows 7 machine. TCP/IP enabled, IPv4 addresses activated and enabled, remote connections enabled, firewall disabled (for now), and it still didn't work! I tried introducing MySQL over a year ago only to have some hilarious emails with a senior programmer about how we…

I've never worked much with other databases other than SQL Server. But one time I had to work with Oracle and MySQL, I had trouble getting a good enough client (like SQL Server Management Studio) even though I was ready to pay.

May be it's my personal preference, I tried many clients (TOAD, DBArtisan, SQL Developer, SQL Plus etc.) and found that none was as polished (not that i'm mentioning functional) and integrates well with Windows as the one from Microsoft.

It's off topic, but the same applies for Visual Studio and other IDEs.

Re: Poll: What database does your company use?

#154

Post by chrislomax »

s00pcan wrote: post #90

SQL Server unfortunately. I was reminded why I hate it today when I was trying to set up a simple remote connection to the instance running on my new Windows 7 machine. TCP/IP enabled, IPv4 addresses activated and enabled, remote connections enabled, firewall disabled (for now), and it still didn't work! I tried introducing MySQL over a year ago only to have some hilarious emails with a senior programmer about how we…

Just as a side note, make sure you had SQL browser service running! It is not running by default on some setups

Re: Poll: What database does your company use?

#157

Post by blntechie »

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

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?

Re: Poll: What database does your company use?

#158

Post by sjwright »

Someone wrote: post #115
jpitz wrote: post #61

Earlier quoted context omitted.

MS really only has one relevant offering in this discussion, unless you want to add Exchange as a document-oriented store.

It would not surprise me if MS Access were used at more companies than MS SQL Server. I'll leave it to you whether you call it a database :-)

I think it would be fair to say that Jet (Microsoft Access) is a least as much a database as SQLite.
Post reply on HN