back

by wglb·17y ago·view on hn ↗
I am tempted to say "real men don't use databases", but that is a little dramatic. Databases in the sense of RDBMS/SQL databases. It seems that HN doesn't, Google doesn't, Yahoo doesn't, ITA does (from what I understand). (Or at least they are using a lot of Oracle--maybe that is stuff that is much more than just the RDBMS.) Is your problem as big or as hard as the problem that these outfits solve? Isn't it an interesting matter for contemplation why these smart folk aren't?

While the article has an agenda, it seems useful to understand why a database might be needed and what the useful alternatives might be.

1 comments
A lot of databases "suck" because they have to be jacks of all trades, in that they have to be able to do a ton of very general things.

That's why a crap-load of web sites and apps can all use the same database software.

You will ALWAYS have much better performance if you write your own "database" that specifically does what it is you need doing, as in the case of Google, etc., that you mention.

And don't forget, Google didn't just write their own database, they wrote their own file system, etc., and even designed their own hardware (batteries on board to eliminate large UPS's, etc).

But they can afford to spend the money to hire the really smart people to build and maintain that stuff for them, and they have the scaling requirements that justify it.

Most other companies either can't justify it, or don't want to... they'd rather rely on the vendor to maintain the DB code, to security testing/updates, etc.

Really, I think a lot of the complaints about SQL (especially in the case of these recent articles) come from the fact that it's hard to design and implement a system that works the way they want it to, and there's no tool that just plugs into what they have that does what they need.

I see their issues as the exception rather than the rule, and not really applicable to most situations.

$0.02