Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Poll: What database does your company/you use?

news.ycombinator.com

Post reply on HN
Print view View original

71–80 of 101 posts

Re: Poll: What database does your company/you use?

#71

Post by calinet6 »

emn13 wrote: post #48
imsofuture wrote: post #45

Earlier quoted context omitted.

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

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

Balance is the answer.

This tends to be true of all things.

Re: Poll: What database does your company/you use?

#74

Post by pbiggar »

christiansmith wrote: post #60
fragsworth wrote: post #31

A 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 g…

This might be good advice if you're building cookie cutter systems for clients that have high turnover of contractors, but for startups I think it's horrible. I'd take one person that really groks devops and database internals well enough to make informed choices over a million one-size-fits-all SQL/Mongo+MVC devs. Any day of the week.

What do you do when that guy quits?

Re: Poll: What database does your company/you use?

#76

Post by bdcravens »

christiansmith wrote: post #60
fragsworth wrote: post #31

A 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 g…

This might be good advice if you're building cookie cutter systems for clients that have high turnover of contractors, but for startups I think it's horrible. I'd take one person that really groks devops and database internals well enough to make informed choices over a million one-size-fits-all SQL/Mongo+MVC devs. Any day of the week.

but for startups I think it's horrible.

Why? Wouldn't it make more sense for startups to color within the lines, in terms of getting features to market faster?

I'd take one person that really groks devops and database internals well enough to make informed choices

Funded or not, a startup has the responsibility to turn every dollar into a feature that creates revenue, not architecture.

Re: Poll: What database does your company/you use?

#77

Post by sciurus »

akurilin wrote: post #57
wfn wrote: post #51

Earlier quoted context omitted.

I'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_Serv...

The 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 A bit of a lengthy read, but worth it.

Seconding this. Packt Publishing is really hit or miss, but PostgreSQL 9.0 High Performance is a hit.

Re: Poll: What database does your company/you use?

#78

Post by staz »

dgesang wrote: post #53
mathnode wrote: post #24

Sybase 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…

Ask HN: Has anyone ever considered "MS Access a viable option"?

"Access, why would we need that? We already have a shared folder with all our Excel sheets"
Post reply on HN