3 ms·
Postgres is the C++ of databases. It is well thought out and designed. It seems overly complex at first until you actually use it a lot to solve hard problems,
by 16s 13y ago
Postgres is the C++ of databases. It is well thought out and designed. It seems overly complex at first until you actually use it a lot to solve hard problems, then you understand why it is the way it is and just how great all those features are.
- davidw 13y agoPostgres, however, is written in C. Mysql uses C++. I'll take Postgres any day, though.
- e12e 13y agoNot quite sure what RDBMSs you are comparing Postgres to here... Firebird? Microsoft SQL/Sybase? Oracle? Because none of those strike me as particularly "simple" products?
- corresation 13y agoAlmost certainly MySQL, which is overwhelmingly the competitor in the psql space. A big reason why mysql took off is the same reason that PHP took off -- it is very quick and easy to take the first steps.
- nirvdrum 13y agoI think a large part of that simplicity can be attributed to the lack of Windows port of PostgreSQL at the time that PHP was gaining traction. MySQL was the only reasonable option then. And then the community mindset was solidified.
- dugmartin 13y agoI think it was the need for manual vacuuming. If you were running a small web host at the time picking MySQL over Postgres meant a huge reduction in potential support tickets related to non-vacuumed databases causing customers to run out of space.
- nirvdrum 13y agoThat certainly didn't help, but if your DB was large enough where vacuuming mattered, you probably found a cron solution. The other place I saw MySQL win was in single access benchmarks that were scattered across the Web. Postgres would win in concurrent scenarios pretty handily, but people were glued to those serial benchmarks.
- irahul 13y ago> A big reason why mysql took off is the same reason that PHP took off -- it is very quick and easy to take the first steps. I think most people struggle with setting up postgres auth. Personally, I find postgres' auth well designed.
- MrGando 13y agoYeah, because C++ is well thought and designed, specially simple when trying to solve hard problems with it.
- Demiurge 13y agoConsidering I think C++ has many problems because it is overly complex because it grew on top of a very low level language, I have to say I can't agree with your statement. Just because something has features, doesn't mean it's great, because some of these features can make everything unstable. And PostgreSQL is great because it is solid and reliable and doesn't have anything like that.
- irahul 13y agoWhen you are comparing to other offerings, postgres's auth is complex than them. But other than that, what about postgres is complex?
- marcosdumay 13y agoDifferently from C++, Postgres complexity is completely optional. The features you don't know about won't change the way your code works.