I sit corrected [LWN.net]

I sit corrected

Posted Jul 12, 2006 1:27 UTC (Wed) by ccyoung (guest, #16340)
In reply to: vinalla vs nuts by nix
Parent article: PostgreSQL Anniversary Summit a success (NewsForge)

I think you are much more of the student of SQL than myself (personally limited to PG, Oracle, MS-SQL, and MySQL). I and probably others would enjoy an overview of your assertions. Do you have anything in writing you can share?

Did not know that full table inheritance was taking place - this is really good news and I look forward to revisiting - have done many elaborate work-arounds.

I also sit corrected on extensibility: my point is that extending a single app among a dozen or so is, for me, asking for trouble.

Lastly, SQL is, after all, SQL. Every young Turk who sees it (of whom I have been one) decries is stodginess and oblique expressiveness. At this point in my professional career I'm (happily) too busy finishing projects to re meta-think SQL, although I'm still sensitive to inelegant code.

Also, most modern programming (Java, .Net) tends to demote the database to a simple repository, trying to capture the business rules in the middle tier with communication objects for example. SQL is a bad impedance match for this. Some of us (me) prefer use instead-of views for user interfaces and triggers to keep the database aligned. OK but not great.

Again, please share your enlightenment.

(Log in to post comments)