dan you should add 'hosted kv' as an option to account for appengine, simpledb etc.
Poll: What database does your company use?
71–80 of 378 posts
Re: Poll: What database does your company use?
#72MySQL, with SQLite for development environments. I want to learn/migrate to Postgres though, what with MySQL being in Oracle's hands.
One of the best things you will ever do.
Agreed. I had to migrate a copy of Team City from MySQL to PostgreSQL a few days ago (due to a buggy mysql version in the Ubuntu 10.04LTS package repository). You just don't get crap like that with Postgres. It just works.
Re: Poll: What database does your company use?
#73The relatively low amount assigned to couch is what surprises me. I thought it was fairly widely used (in the NOSQl world)?
Re: Poll: What database does your company use?
#74flat files!
I hear you.
Re: Poll: What database does your company use?
#75SQLite 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.
SQLite is indeed built into iOS and Mac OS X as well. Core Data's store uses SQLite as an option (XML and Binary are the others), and it is accessible via third party frameworks like FMDB.
Re: Poll: What database does your company use?
#76Interesting to see Tokyo with so few votes. On benchmarking it had the smallest memory footprint when loading ~17GB of packed binary data. Been awhile but I remember testing redis, postgres, mongo, and bdb. This let us keep all the low latency read-only data we needed available in memory and provision the smallest possible machine to do it.
I bet a lot of the proportion is down to most people writing in with what they use in their day jobs.
Also, while I love Tokyo's speed, it is just a better bdb - which is an impressive feat, but I can see why a lot of people would use something slower but more featureful.
Re: Poll: What database does your company use?
#77Agency. We use SQL Server, MySQL, and SQLite. Rare, but have seen Oracle and PostgreSQL.
Re: Poll: What database does your company use?
#78Other - ZODB.
Re: Poll: What database does your company use?
#79I'd vote for PostgreSQL multiple times if I could. I'm a consultant DBA (-ish; I do other stuff as well, but that's what puts most of the food on my table), and have multiple clients using pg.
Re: Poll: What database does your company use?
#80I'm surprised to see that Oracle even has as many mentions as it does, given how rarely you read about it here on HN. We're locked into it at my workplace, and every time I'm reminded of this PG quote I cringe a little: "The more of an IT flavor the job descriptions had, the less dangerous was the company. The safest kind were the ones that wanted Oracle experience. You never had to worry about those."
I suspect that it's the HNers still toiling away in large companies that are voting for Oracle. You'd probably see about as many votes for DB2 had it been an option.
You are correct in my case.
We use Oracle, MS SQL Server, and Sybase because that's what the vendorware we use requires. We do have some open-source software that uses MySQL for administrative purposes.