6 ms·
Poll: What database does your company/you use?
Please upvote this if you would like to see more people take the poll.
This has been asked on occasion in the past but like all things, database preference/technology changes quickly. Let's see what people are using today.
If you think I've left out an important one, leave a comment and I will try and edit the post.
- oakaz 12y agoLevelDB
- securingsincity 12y agoLebron stack? http://lebron.technology/ http://lebron.technology/
- roryhughes 12y agoGood idea, added.
- onedognight 12y agoNeo4j is listed twice.
- roryhughes 12y agoFixed, Thanks.
- etaty 12y ago/dev/null
- rgrieselhuber 12y agoI bet you get wicked performance.
- tokanizar 12y agoWhich only support one operation: DELETE. Isn't it?
- patrick3a 12y agoINSERT works fine too, but you cannot SELECT tho :(
- nodesocket 12y agomemcached as a database is a stretch.
- buro9 12y agoMemcacheDB and memcached are both databases. You put data in, you get data out (if it exists). In CAP theorem they are CP.
- jliechti1 12y agoNo SQL Server?
- roryhughes 12y agoI have it in as 'Microsoft'.
- JohnTHaller 12y agoThat could also mean Access, unfortunately. Microsoft SQL Server is the name most people would be looking for.
- roryhughes 12y agoFixed :)
- hfmuehleisen 12y agoMonetDB
- sparrish 12y agoNo CouchDB?
- roryhughes 12y agoCouchBase (Couch, Membase included)
- thezilch 12y agoNo Solr but ElasticSearch?
- roryhughes 12y agoThe reason I thought of adding ElasticSearch in the end was because some projects have started to use it as a DB on its own.
- jjguy 12y agoElasticSearch and Solr are both search engines built on top of Lucene. ElasticSearch just has all the hipster hype these days. Maybe update the description to include all three.
- mhluongo 12y agoLucene isn't really a database, though.
- cakeface 12y agoWe have been using Solr on it's own as a database for years. Many times I hear the "don't use solr as a database" rhetoric but honestly for our usage it is amazing. We're using it as a document store and querying using fulltext and key/value indexes. It is fast and reliable and has handled millions of documents pretty easily. I've been happy with it. Currently evaluating ElasticSearch and it looks really promising also. We may move over to it as it seems to have a bit more momentum and better support for cloud/scaling.
- ddorian43 12y agoAt work i inherited a mysyiam,no foreign keys, no transactions,duplicate indexes,bad indexes, no composite indexes, no backups mysql db and many other stuff. But at home and for personal projects i use postgresql + it's advanced features. So voted for both.
- canadiancreed 12y agoThe vast majority of places I've worked at used MySQL, which isn't surprising considering most have been LAMP shops. Only one Postgres, and one MSSQL
- wldlyinaccurate 12y agoCurrently using Postgres, but not utilising any of its more powerful features.
- wfn 12y agoI'd start with going over the points of this article (assuming you haven't done just that:) -- https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Serv...
- akurilin 12y agoThe PostgreSQL 9.0 High Performance book has been great for us, goes in depth into most interest variables that you can tweak on your instance to make sure you're making the most out of your machine's resources: http://www.packtpub.com/postgresql-90-high-performance/book http://www.packtpub.com/postgresql-90-high-performance/book A bit of a lengthy read, but worth it.
- sciurus 12y agoSeconding this. Packt Publishing is really hit or miss, but PostgreSQL 9.0 High Performance is a hit.
- yamalight 12y agoVirtuoso Open Source
- Patrick_Devine 12y agoVirtuoso is great for handing large-ish graphs and then being able to use SPARQL to walk the nodes. We used it at the last company I worked for and we were able to get fairly good performance out of it while walking hundreds of thousands of edges. I think it would have scaled even beyond that, however the python RDFlib bindings we were using were a bit slow.
- johnlbevan2 12y agoWould be interesting to know the context; small or large company / is there a strong IT focus or is IT just an internal service for the company, etc; think that may give more telling results (i.e. enterprises that buy off-the-shelf are often forced the Oracle/SQL-Server route causing them to select the same techs for bespoke systems to limit DB diversity).
- roryhughes 12y agoI think the only easy way to find that sort of stuff out is through the comments as HN doesn't allow for much customisation. It has its upsides though.
- mathnode 12y agoSybase ASE and Sybase SQL Anywhere are not listed, yes they are different. If you are going to have column stores, you should have InfiniDB. And if you are going to have SQLite, you should also list MS SQL Server Compact. MS Access is also a viable option, also DBase and Filemaker. Clustrix and NuoDB should also be in the list if you are listing NewSQL systems like VoltDB. I am sure there are others :S as a DBA would be interested what businesses or systems only back onto column stores without a traditional RDBMS or a modern NoACID system.
- roryhughes 12y agoSorry. There are hundreds of Database projects and I can see where you're coming from. I added the most popular and had a search around for some smaller ones that seem to be gaining traction. The comments should suffice otherwise.
- dgesang 12y agoAsk HN: Has anyone ever considered "MS Access a viable option"?
- gamegoblin 12y agoI freelanced once for the local VA hospital and they sure tried!
- staz 12y ago"Access, why would we need that? We already have a shared folder with all our Excel sheets"
- Shish2k 12y agoThis is true, and several of the world's biggest companies run that way. Several-hundred-megabyte spreadsheets, with VBA interfaces copy & pasted between them; can't change it because the unknown cost of breaking it is potentially greater than the known cost of hiring an entire department of people to do one database server's job :(
- ghosttie 12y agoJADE http://www.jade.co.nz/jade/index.htm http://www.jade.co.nz/jade/index.htm
- deleted 12y ago[deleted]
- DevX101 12y agoIt'd be nice if HN sorted polls by points
- buro9 12y agoOnly after you had voted and reloaded the page. Otherwise the effect would be to promote the most popular options. Ideally when you hadn't voted, the ordering would be random.
- bshimmin 12y agoHas anyone written a little web app to turn an HN poll into a nice chart, automagically? (Extra hipster points for using D3 and some random and inappropriate visualisation no one has ever heard of.)
- Sami_Lehtinen 12y agoResults as chart: http://hnlike.com/hncharts/chart/?id=7729603 http://hnlike.com/hncharts/chart/?id=7729603
- bshimmin 12y agoNice!
- Moru 12y agoThis is not a popularity vote, it's a vote on what DB you actually use. For a "Best DB system" question, you need to evaluate each DB and rank them all.
- buro9 12y agoIt has a lot of options, people will answer a few, get bored... scroll down and read some comments. The options towards the bottom of the list may not get as much attention and votes even if they are used by people. If it were alphabetical, people might hunt and peck for the one they use most, e.g. PostgreSQL, they might then see things around there (memcached) but fail to scroll back up and vote for Custom too. Random deals with it well enough without even knowing the poll content or number of options.
- lr 12y agoLDAP?
- fragsworth 12y agoA word of opinionated advice to anyone deciding on a database to use for their new project: Just go with something popular (MySQL, Postgres, Mongo, etc.), or go with an Amazon hosted cloud database if you really don't want to set anything up (RDS, SimpleDB, DynamoDB). There's no good reason to start a project with other databases. If you're worried about the scalability of something like MySQL when you haven't even got your first 1000 users, your priorities are messed up. Finish your product and get your users first. And I hope to god if you DO get your users and I ever have to maintain it, it's not running on some bullshit like Tokyo.
- imsofuture 12y agoI don't think this is terribly good advice. Many databases have specific domains in which they excel. I agree you shouldn't be worried about scaling before you have users, but you should absolutely evaluate different tools before picking one.
- emn13 12y agoWhat you're saying is true, but worrying about scaling before it's necessary is unfortunately common, and I've felt the pain caused by this (modern) premature optimization.
- calinet6 12y agoBalance is the answer. This tends to be true of all things.
- tiquorsj 12y agoThis is good advice. I've scaled multiple sites to +3 million registered users and more than 1 million unique visitors with heavy DB usage. This is excellent advice for starting out. Along the way we found areas that could be improved and we were able to move quickly to them because our underlying DB was standard stuff. We knew what areas were breaking down and then fixed them with targeted moves to other DBs and things like memcache. Yes, each DB has a specialty but a good general DB gets you a lot of mileage because those specialty DBs do very little a general DB can't but that is often not true the other way. You would never start a journey with cloudy destination and of a million miles by asking for a moon rover as your vehicle. As your journey develops you would start looking at other options or options for certain segments. Apps follow similar patterns.
- deleted 12y ago[deleted]
- icco 12y agoI personally would have included Google Datastore given how many app engine apps there are out there, but I guess Bigtable is a reasonable approximation of that.
- roryhughes 12y agoI'm really happy to see PostgreSQL doing so well. They've been up against MySQL and Oracle for so long and really deserve it due to all the hard work the team have put into the amazing OSS project.
- ForHackernews 12y agoAs far as I'm concerned, PostgreSQL should be the standard for any new free software projects. It's just too bad so many older projects (Wordpress, etc.) are tied to MySQL.
- deleted 12y ago[deleted]
- warrenmar 12y agoRedshift? or would that go under PostgreSQL?
- pestaa 12y agoFor some reason I thought all major distros dropped MySQL in favor of MariaDB. The list, however, is not too short and it includes Debian, Ubuntu, RHEL, Fedora, openSUSE, among others. https://mariadb.com/kb/en/distributions-which-include-mariadb/ https://mariadb.com/kb/en/distributions-which-include-mariad... If you thought you were using MySQL, check your package repository!
- deleted 12y ago[deleted]
- tetha 12y agoI just felt silly voting so many times. I guess I work at a big company. Our big data team is dealing with HBase and Vertica, our game team is dealing with mysql, our web team migrates a redis into couchdb, my team deals with mysqldb, neo4j, cassandra and sqlite on a test server where no one wants to set something proper up. Memcached and the file system is working on most services it makes sense on.
- aaronharnly 12y agoYep, similar here -- many teams, many use cases, many DBs in use: * Postgres (including RDS), Oracle, and MariaDB all used as transactional stores on projects of varying vintage * Vertica for aggregate reporting * Hadoop/HBase in another data warehouse * Mongo in several key-value stores * Amazon DynamoDB under evaluation for likely adoption for a newer key-value store * memcached ubiquitous * SQLite for simple read-only stores within web services * Cassandra and Redis under evaluation for task queue result stores In a large, mature organization, I think this kind of heterogeneity is both inevitable and appropriate.
- rMBP 12y agoIBM Domino... :-(
- wting 12y agoI worked on Domino--it's a mail server that uses DB2.
- rMBP 12y agoWasn't aware of it using DB2, not that I care much what it is as long as it works. As you probably know having worked on it it's an application platform too, which is mostly what we use it for. Sadly, none of my colleagues has the time to develop any apps for it and I only dabble around in high level languages, so everyone just uses the blank office template and creates documents with tables and stuff. But the search is great, and the save conflict management keeps some of the IT-related headaches away. I wish there was a self-hosted web app equivalent though as the UI for editing is similar to Ms Office, thus easy for Average Joe to grasp. The drag-drop storage of files inside documents is nifty.
- BareNakedCoder 12y agoPoor Domino. Domino is a NoSQL-ish distributed document database and application platform that traces its roots back to 1989. Mail is just one possible application that happens to come out-of-the-box. Domino was mismanaged by IBM after its purchase of Lotus. If IBM had only provided more killer apps out-of-the-box like project management, etc that businesses need (instead of hoping 3rd parties would write 'em) it could dominated (pun?). Instead, we have MS SharePoint (blah!). In fact, today Domino sucks ... but I do get misty eyed thinking about what it could have been.
- darkhorn 12y agoAll the academic recordings, such as what student took what course and what grades he has a stored in Informix, at Middle East Technical University (metu.edu). It is such a pain in the ass that at the beginning of the semester, in the interactive registration the system always goes down. As far as I know it has something like maximum of 30-100 active sessions. They were unable to move it to some modern database. Here is some messaging https://groups.google.com/forum/#!topic/comp.databases.informix/8bcAyY6hYyk https://groups.google.com/forum/#!topic/comp.databases.infor...
- evv 12y agoThe numbers for redis are going to be misleading. Are people voting for it because they use redis as their primary data store, or just because they use it at all? I use it redis a cache and I haven't voted for it because I assume this poll is asking about the primary data store. Does anyone use redis as their main db?
- spullara 12y agoFoundationDB
- blogytalky 12y agoBerkeleyDB?
- vaidik 12y agoWe are using RocksDB as well for something. Although based on LevelDB, but its pretty different now. So can be added as a separate entry.
- canadi 12y agoInterested, what are you using RocksDB for?
- lvca 12y agoWhere is OrientDB on this list? Please add it
- HeyLaughingBoy 12y agoNo love for ZODB? (Zope Database) No, we don't use it, but I'm surprised to see it drop completely off the map.
- elwell 12y agoOnly 8 for Datomic; I thought HN was only Clojure users?
- errorrrr 12y agoI just understand that I use only DB2 in AS/400 right now that's scary
- khaledh 12y agoCompare http://db-engines.com/en/ranking http://db-engines.com/en/ranking
- Pci 12y ago"Some companies have valid reasons not to start prototyping with postgres, it's just yours isn't one of them" - anon I've found that to be true time and time again. With other systems it's easy to quickly paint yourself into a corner, with postgres it's fairly straightforward to move to another system, e.g. cassandra/mongo/couch/etc (that's IF you actually ever need to move from postgres)
- exadeci 12y agoNone of your companies are old enough to use Oracle ?
- nuetrino 12y agoHana
- whatever2001 12y agomore opinionated advice: ElasticSearch and the entire "ELK" stack (Logstash+ElasticSearch+Kibana)is awesome; but don't use it as a primary data store. It's not meant for that even though some of us are using it as such.
- Flenser 12y ago575 PostgreSQL 462 MySQL 275 Redis 201 MongoDB 184 Microsoft SQL Server 144 SQLite 124 Memcached 122 ElasticSearch 100 Oracle 80 The File System 66 MariaDB 57 Cassandra 44 Other 41 Amazon DynamoDB 24 Riak 23 CouchBase (Couch, Membase included) 23 DB2 20 Neo4j 19 Custom 18 BigTable 16 LevelDB 14 HBase 14 RethinkDB 12 Firebase 11 Amazon SimpleDB 9 RavenDB 9 Vertica 8 Datomic 7 Tokyo 5 Teradata 5 Firebird 5 Informix 2 VoltDB 2 Netezza var res = [], arr = document.querySelectorAll('table')[3].childNodes[0].childNodes; for (var i = 0; i < arr.length; i+=3) { res.push({name: arr[i].innerText.replace(/\n/,''), points: parseInt(arr[i+1].innerText,10)}) }; res.sort(function(a,b){return (0+b.points > 0+a.points) ? 1: -1 }).forEach(function(i){console.log(i.points, i.name)})
- jtcain 12y agoI wonder how this distribution is skewed based on company size, sector, and region. (I.E…Large established financial companies in the Midwest primarily prefer X. Small social media startups on the West Coast primarily prefer Y).
- lauriswtf 12y agoRelevant – http://www.databasefriends.co/2014/03/favorite-relational-database.html http://www.databasefriends.co/2014/03/favorite-relational-da... It's a recent poll about favorite relational database and Postgres came first by far.
- bredman 12y agoFor those curious here's a similar post from ~4 years ago: https://news.ycombinator.com/item?id=1411937 https://news.ycombinator.com/item?id=1411937