8 ms·
Poll: What databases does your company use?
daniel_levine has submitted this poll twice before, and the results are always interesting:
http://news.ycombinator.com/item?id=2684620
http://news.ycombinator.com/item?id=1411937
Leave a comment for ones I forgot to mention and I'll add them.
- kt9 14y agoAmazon DynamoDB
- edu 14y agoQuestion, how do you run your dev environment? Are you running in on AWS too and have a separate DynamoDB setup?
- kt9 14y agoMy production and staging/test environments are on AWS and I do development on my local linux box. Since DynamoDB is a web service I can connect to my DynamoDB tables from anywhere. If you have questions or need help feel free to contact me directly (or post here) and I'll be happy to answer any questions you have.
- genwin 14y agoNice, I didn't realize that ability to connect from anywhere. Have you found DynamoDB to be expensive in practice? Of course the cost is mitigated by the admin they handle.
- kt9 14y agoCost has not been an issue for me. I've got 14 tables on DynamoDB - most at 5 read, 5 write, and one at 20 read, 10 write - and its been costing me around $50-$60 per month. IMHO cheaper than running a MySQL database and a slave instances. It was great during development because I would create the tables in the morning, code all day and then delete the tables at the end of the day so I would only pay for 6-8 hours of provisioned throughput!
- genwin 14y agoGood report, thanks! I'll keep that idea in mind to delete tables to save $$.
- ndemoor 14y agoThere are 2 options which I use(d) when developing/deploying DynamoDB: - Have a separate (sub)account for dev/test/... in which you create your tables. Since one of the latest changes to their policy you are now able to configure the lowest read/write capacity possible: 1/1 - Join everything under one account but prefix your tables with dev_, test_, prod_* I prefer the former as it enables me to have the dev/test env as similar as possible to the prod environment: same naming, and both env's are separated, when one gets compromised at least the other one doesn't suffer. Security rules are also easier as you don't have to create per-table rules, when you want to lock out some team-members from production tables, but not dev/test tables.
- pelle 14y agoWe use Datomic
- VaedaStrike 14y agoDatomic
- tgrass 14y agoExcel. Someone save me.
- omni 14y agoPoor soul, even Access would be a step up for you.
- illegalsmile 14y agoAccess. Built a database to do basic inventory of instruments and calibrations.
- tfleischer 14y agoAmazon SimpleDB
- nessus42 14y agoH2
- WALoeIII 14y agoMySQL + Percona.
- gullfaraz 14y agoMySQL http://www.readenews.com http://www.readenews.com
- martinp 14y agoMost companies usually use more than one. At my current job we use PostgreSQL and MySQL in production, and H2 in development. At my previous job we used Sybase SQL Anywhere (horrible, wouldn't recommend it), Microsoft SQL server, MySQL, Amazon RDS and H2.
- bdcravens 14y agoWhat databases do you use in RDS? RDS isn't a database, it's hosted MySQL, SQL Server, or Oracle.
- martinp 14y agoSorry, forgot to specify which one. It was MySQL if I remember correctly.
- pimentel 14y agoI don't have the best knowledge on DBs, but why would you use more than one of the same "tech"/paradigm? Why postgreSQL and MySQL? Don't they work similarly? Or is it because you use postgreSQL for the things it is better than MySQL, and vice-versa?
- martinp 14y agoIn my experience the database usually gets evaluated on a per-project basis. It's a good way to determine the strengths and weaknesses of each. Currently we use PostgreSQL for all new projects, but we have a few legacy projects still using MySQL that we haven't bothered migrating. Additionally, most developers find it a hassle if they have to configure a fullblown database just to do development on a given project. That's why we use H2 (in-memory database) for development.
- deleted 14y ago[deleted]
- adelevie 14y agoDo backend-as-a-service databases count?
- trebor 14y agoWe use MySQL exclusively, unless a client forces us into MsSQL/IIS. I am trying to convert us to PostgresQL over time, but I still have to get a good guide on how to use it.
- brian_cloutier 14y agoHonestly the official docs are really good. http://www.postgresql.org/docs/9.1/interactive/index.html http://www.postgresql.org/docs/9.1/interactive/index.html
- bsg75 14y agohttp://shop.oreilly.com/product/0636920025061.do http://shop.oreilly.com/product/0636920025061.do http://www.packtpub.com/postgresql-9-admin-cookbook/book http://www.packtpub.com/postgresql-9-admin-cookbook/book http://www.packtpub.com/postgresql-server-programming/book http://www.packtpub.com/postgresql-server-programming/book (forthcoming)
- natehark 14y agoWe use PostgreSQL and Cassandra. We're also using MongoDB for an internal reporting application, but don't use it for our service offering.
- MichaelGG 14y agoVoltDB
- jacquesm 14y agoInteresting! How is VoltDB working out for you?
- MichaelGG 14y agoWe're just starting to get it going at my current company, so I can't really speak to its production qualities. The goal is for real-time statistics/analysis on call records: 100-2000 rec/sec, keeping a day to a week or two of records. I've done tests previously, and can confirm that they aren't making the performance numbers up :). 3x $500 servers (~18 months ago: single quad-core Core2) were able to handle over 100K tx/sec with k=1 (2 copies of each record). It was pretty easy to get it up and running and the out-of-box performance required no tweaking on my part to achieve excellence (apart from making sure NTP was working well).
- jacquesm 14y agoWow. VoltDB is on my short list for technologies to evaluate for a transaction processor. I've been reading the documentation and trying to get a grip on the general implications of tying the fate of a company to a relatively unknown player in the DB field so your information is very valuable. Thank you very much.
- tadruj 14y agoFirebase is missing
- kami8845 14y agoMangoDB https://github.com/dcramer/mangodb https://github.com/dcramer/mangodb
- benatkin 14y agoThis is just a bad joke.
- kami8845 14y ago>just I happen to think it's a pretty good bad joke :)
- benatkin 14y agoWell of course you do. You are the one who is deliberately wasting other HNers time with it.
- kami8845 14y agoWeak argument. HN is to look at interesting links that "tickle the mind". My link does that. Being the second most upvoted comment in the thread proves that. I feel sorry it tickled yours the wrong way, benatkin.
- omni 14y ago"Being the second most upvoted comment in the thread proves that." Similarly, Justin Bieber is actually one of the best artists of all time.
- kami8845 14y agoJustin Bieber is popular in pop music. Therefore it's reasonable to assume he's a good pop artist. My comment is popular amongst other HN readers. Therefore it's reasonable to assume it's a good comment.
- ravin455 14y agoArcDB
- theltrj 14y agoSAP Hana
- glanch 14y agoEmbarcadero Interbase. Delphi Pascal. Low wages, few employees, lots of projects, no time to update massive codebases, so, yeah.
- m0nastic 14y agoI'm presently prototyping RavenDB for a big development project at work. For what it's worth, I'm really impressed with it so far.
- jbigelow76 14y agoAnother RavenDB user here. Overall pretty happy with it.
- golgo13 14y agoSQL Server. One day, we'll have a Metro SSMS.
- sidcool 14y agoMine is a standard Enterprise environment with Oracle DB all around. I am surprised Sybase is not listed. We also use some DB2, but 90% of it is Oracle DB.
- spindritf 14y agoNo one's using MariaDB? Or is it considered to be MySQL?
- jzawodn 14y agoI consider it to be MySQL for purposes of a poll like this. If it was "which MySQL variant to do you use?" I'd expect to see MariaDB, Percona XtraDB, etc.
- vq 14y agoZODB
- rbranson 14y agomemcached is a database now? IMHO Redis barely registers as a database; it's more of a shared heap that supports snapshotting. At Instagram we use PostgreSQL, Redis, and Cassandra.
- btipling 14y agoIt's a place where data is stored. Wikipedia says "A database is a structured collection of data." I think redis qualifies given that description, but I agree it's different enough to raise eyebrows if someone referred to it as their "database".
- calinet6 14y agoAgreed. Regardless of the technical definition of "database," I think the word implies durability in some sense.
- petercooper 14y agoIMHO Redis barely registers as a database; it's more of a shared heap that supports snapshotting. What about Berkeley DB? That has a similar range of functionality yet is cited as 'the most widely used database toolkit.'
- vosper 14y agoWe're in the process of moving our analytics from MySQL to Infobright (Community Edition).
- alexatkeplar 14y agoWe also use/support ICE at SnowPlow.
- vosper 14y agoI'd be interested to know what other systems you looked at before settling on ICE? We evaluated HBase, Hypertable and Riak (kind of a wildcard entry) as analytics platforms but then found Infobright purely by luck, and were very impressed by the performance and ease of use.
- alexatkeplar 14y agoSorry Vosper - just saw this. We started with a Hive-based approach for SnowPlow but got tired of having to run a map-reduce for each query, so started looking at columnar databases. ICE is the first columnar database we have integrated SnowPlow with - mainly picked because the OSS project is quite well documented and supported, rather than because of any performance benchmarks. We will probably integrate with other columnar dbs in due course too (e.g. Vertica, Greenplum). Thanks for the Hypertable steer - will definitely take a look at that too.
- Sander_Marechal 14y agoI am missing ElasticSeach. Besides a search engine it is a document database too.
- nettdata 14y agoWhat constitutes a DB? Can we have "custom" as an option? We wrote 2 very light, single-use DB's for two specific use cases in order to get some performance we needed on real-time data, but they don't really have any kind of management or generic SQL-like access.
- smilliken 14y agoGreat point, I've added this option.
- PaulHoule 14y agoOpenLink Virtuoso
- antirez 14y agoWith three runs available it starts to be interesting to see a graph about tendencies.
- PaulHoule 14y agoJDBM
- jlebeau 14y agoWhile most of our new code is PostgreSQL, I support apps that use Synergex, FoxPro, and Access.
- valhallarecords 14y agoApp Engine datastore
- bsg75 14y agoIts early, but consider RethinkDB?
- nollidge 14y agoList is missing Sybase.
- schammy 14y agoMySQL, memcached, and a custom pure-memory database that stores volatile real time data.
- kulekci 14y agoMysql
- gorbachev 14y agoWe use ElasticSearch and Solr for search heavy applications.
- aespinoza 14y agoWe are also using NuoDB.. which is pretty cool.
- jerven 14y agoOWLIM-se Its a RDF/sparql database
- calciphus 14y agoMySQL via AmazonRDS and Postgres via Heroku. Depends on the project.
- unit0x03 14y agoDoes Hive+HDFS count? I know it's ugly, but we use it.
- danbala 14y agoInterSystems Caché (http://www.intersystems.com/cache/ http://www.intersystems.com/cache/)
- serge2k 14y agoI use SQL Server. Some of the applications run on Oracle and I think PostgreSQL is around too.
- cpher 14y agoWe're mostly a SQL Server shop, but we have a client on Oracle and we're exploring Postgres as well. In the enterprise realm (e.g. MS) you typically stick with the enterprise db systems, but not always--that's why we're looking into Postgres. But to be honest, our clients that have invested in the MS stack are already well-versed in SQL Server. It's rare when the entire "picture" can justify open source stuff when they've already invested in a proprietary stack.
- j0j0r0 14y ago(: PostgreSQL is beautiful :)
- noisyby 14y agoUse Firebird Database (more 100 organizations)
- mariuz 14y agoI only use Firebird http://www.slideshare.net/mindthebird/why-firebird-fact-for-decision-makers http://www.slideshare.net/mindthebird/why-firebird-fact-for-... It's weird to see memcache listed as databases but is true it can be used as cache system for web frameworks I have used it for Rails , Django and CakePhp So i guess it is worth it's place to stay in the database world
- brightsize 14y agoPostGIS. I'm not sure if that would count as distinct from PostgreSQL though.