Sunday, October 04, 2009

SQL comparison update: PostgreSQL 8.4

I finally got around to adjusting my SQL comparison page, so that the improvements in PostgreSQL 8.4 are taken into account. PostgreSQL is now standards-compliant in the sections about limiting result sets; actually, PostgreSQL is the first DBMS that I know of which supports SQL:2008's OFFSET + FETCH FIRST construct for pagination. PostgreSQL's new support for window functions is also very nice.

My page doesn't cover common table expressions (CTEs) yet, but it's certainly nice to see more and more DBMSes (including PostgreSQL, since version 8.4) supporting them. Even non-recursive CTEs are important, because they can really clean up SQL queries and make them more readable.

2 comments:

slapo said...

Would you add Firebird and SQLite if I managed to find at least some of the information used in the comparison?

Troels Arvin said...

slapo, thanks for your offer, but as I have stated on the page: "I will only write about subjects that I've worked with personally, or subjects which I anticipate to find use for in the near future".

I have this policy, because I fear that the quality of the page will decrease if I add information about DBMSes which I have no first hand experiences with.