Live data from Hacker News

Poll: What databases does your company use?

news.ycombinator.com

41–50 of 84 posts

Re: Poll: What databases does your company use?

#43

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

It'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".

By that definition data containers (dictionaries, lists, etc) built into popular languages or standard libraries are databases.

Re: Poll: What databases does your company use?

#44

Earlier quoted context omitted.

It'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".

By that definition data containers (dictionaries, lists, etc) built into popular languages or standard libraries are databases.

I think the best defining difference is persistence, which means memcache isn't a database but Redis is.

Re: Poll: What databases does your company use?

#45

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

Agreed. Regardless of the technical definition of "database," I think the word implies durability in some sense.

Re: Poll: What databases does your company use?

#48
post #11

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

I 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?

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

Re: Poll: What databases does your company use?

#49
post #11

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

What databases do you use in RDS? RDS isn't a database, it's hosted MySQL, SQL Server, or Oracle.

Sorry, forgot to specify which one. It was MySQL if I remember correctly.
Post reply on HN