FileMaker Pro in my case. I build my own DB apps, but then I'm only a SOHO, so I'm stretching the defn of company.
Poll: What database does your company use?
221–230 of 378 posts
Re: Poll: What database does your company use?
#222SQLite 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.
It's also worth noting that SQLite is, for the time being, the underlying store for Membase
You mean the eventual persistance store.
Re: Poll: What database does your company use?
#223HADOOP / HIVE...unbeatable if you are working with big data
Re: Poll: What database does your company use?
#224I'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.
Why do you use pgsql over mysql? I've used mysql a lot, and pgsql a little. I can't tell the difference, other than pgsql being slower and having less support. Some people swear by it, so I'm curious what I am missing.
I'm a longtime Postgres guy, but I've used MySQL on a few sizable projects. MySQL has come a long way over the years, such that a lot of my original criticisms are no longer valid. My reasons for not using it this day are mainly lack of transactional DDL and the fact that adding indices require a full table lock. There are some interesting solutions to the latter problem that the Percona guys have pulled together, but Postgres handles it all out of the box. Things like partial and expression indices are icing on the cake.
Re: Poll: What database does your company use?
#225In my day job as a Data Warehousing consultant it's usually Oracle, Netezza or Teradata.
However, for the first time ever, my current project uses Postgres with Oracle being pushed out of the enterprise at a fast rate.
For my personal projects it's Postgres, Redis and SQLite.
Re: Poll: What database does your company use?
#226What no Intersystems Cache option?
This was my "Other"
Re: Poll: What database does your company use?
#227My company has 130,000 employees, so I suspect every one of the above is represented somewhere, but the code that I hack on runs on PostgreSQL.
Re: Poll: What database does your company use?
#228Earlier quoted context omitted.
Same here. Voted other. I have a big database on the App Engine, and I'm moving more of my data from mysql to the datastore.
Out of curiosity, are you on the HRD already? We have some fairly sensitive billing code and... well, I'm nervous about the transition to HRD...
Do it. We made the switch a couple of months ago, and haven't looked back. Very little impact on performance, huge impact on reliability - we hardly ever get datastore timeouts now. And of course no maintenance outages either.
http://neogregious.blogspot.com/2011/04/migrating-app-to-hig...
Re: Poll: What database does your company use?
#229You should add the Neo4j ( http://neo4j.org/ ) graph database to the list. Graphs are a much more modern and elegant way of storing relational data. I've used Postgres for over 10 years, but it's not a graph database. With graph databases you don't have to mess with tables or joins -- everything is implicitly joined. And Neo4j is ridiculously sweet -- store 32 billion nodes ( http://blog.neo4j.org/2011/03/neo4j-13-ab…
> Graphs are a much more modern and elegant way of storing relational data. Actually, storing data as graphs is older than relational approaches. It used to be called "network databases". They were not supplanted for the hell of it, relational databases have certain advantages. For select applications, object databases are absolutely the way to go. But for most purposes relational is hard to beat.
For tabular data, relational databases rock. But the relational model doesn't align well with object-orientated programming so you have an ORM layer that adds complexity to your code. And with relational databases, the complexity of your schema grows with the complexity of the data.
The graph-database model simplifies much of this and makes working with the modern-day social graph so much cleaner.
Graphs allow you to do powerful things like find inferences inside the data in ways that would be hard to do with relational databases.
How would you calculate PageRank using a relational database? As I said, with a graph database and Gremlin, you can do it in 2 lines.
To see the types of things you can do with graphs, check out Marko's short screencast on Gremlin (http://www.youtube.com/watch?v=5wpTtEBK4-E).
And also check out Peter Neubauer's introduction to graph databases and how they compare to RDBMS' and where they stand in the NOSQL-movement (http://www.infoq.com/articles/graph-nosql-neo4j).