Hacker News new | ask | show | jobs
by dgregd 5024 days ago
If you cannot compare PostgreSQL to MySQL then what databases can be compared?
1 comments

the point of this article is that Postgres is not just a database
You have to define "just a database" (I am the author btw).

PostgreSQL is a very different kind of database than MySQL is. MySQL is closer to a persistence layer for an application with an ability to plug into other reporting tools. PostgreSQL is a data modelling platform.

Both are "just databases" or not depending on how you want to define "database." I would say it is clear that PostgreSQL is not just an RDBMS but that's the point of other articles on the blog, not this one.

postgres provides much more capabilities than just "dumb storage of the application's state"
No argument there. See my other posts in the Object/Relational modelling series for example.
I might refer to one of your comments to this entry: http://news.ycombinator.com/item?id=4495749

when your code goes into RDBMS engine, then it's no longer just a rdbms engine

Well, in this case that's one of the things that makes it an ORDBMS engine.

One of the interesting things about writing the series I have been working on PostgreSQL as an ORDBMS is that it has helped me solidify my understanding of how these features fit together. It has also forced me to think about separation of concerns a lot more.

What this has taught me so far is that PostgreSQL is an absolutely amazing data modelling platform. Sure that's a lot more than an RDBMS engine. The difference is somewhere between a math program capable of doing algebra and one capable of doing symbolic manipulation to solve derivatives and integrals. (Indeed this is forcing me to rethink the way I approach relational math to account for the sorts of things an ORDBMS can do.) So yeah it is a lot more.

But "just a database" is a hard statement to nail down. If BDB is "just a database" then MySQL is "not just a database." As Paul Brown put it in "Object Relational Database Development: A Plumber's Guide" this basically makes an ORDBMS an information backplane for software services. It becomes an interesting whether whether "database" is a superset of that or not.

Sure it is. MySQL is just a database with fewer features (and less rigid ACID compliance.) Like SQLite vs. MSSQL or PG vs. Vertica. Different tools for different jobs.
"Different tools for different jobs"

that's exactly the (or better: one) point of the article. no disagreement here, right?

Nope :)