3 ms·
It really is amazing how consistently better it gets. The community is ridiculous, too. Every time I read through or ask questions in #postgresql I am reminded
by tdavis 18y ago
It really is amazing how consistently better it gets. The community is ridiculous, too. Every time I read through or ask questions in #postgresql I am reminded that despite knowing way more SQL than your average developer, I am still a big noob compared to the PG folks.
Most SQL questions I field from fellow devs go like:
Him: How do I write a query to do X?
Me: Which RDMS do you use?
H: MySQL
M: Well, I don't use that, but you can probably use Y
M: Now, have you ever considered switching to PostgreSQL...
That probably makes me a fanboy ;)
- mahmud 18y agoIsn't SQL a standard? I know Access and SQLite are a bit quirky, but for all the big stuff I stick to the ANSI SQL standard. Well, I did, until I moved to a Lisp object store :-P
- thristian 18y agoSQL is a standard with approximately zero fully-compliant implementations. What's more, every database has a variety of features that aren't covered by the SQL spec, or use different syntax for some feature for historical reasons. I've got a lot of respect for the PostgreSQL devs for occasionally breaking backwards-compatibility in the name of ANSI-SQL compliance, and for clearly marking deviations from ANSI-SQL in their reference documentation.