Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I see that PostgreSQL is being developed, for example it has INTERSECT and JSON types. Why MySQL is not being developed? Why people use MySQL over PostgreSQL. What I'm missing?

share|improve this question
And analytic functions, support for check constraints to name a couple of other things. I don't really use either of them extensively myself but PostgresSQL seems so clearly superior to MySQL that I don't see why one would choose it either. – Martin Smith Dec 5 '12 at 8:51
This is not a good question for this site though and will likely be closed as "not constructive" – Martin Smith Dec 5 '12 at 8:52
@MartinSmith What happened to so called community questions? – george Dec 5 '12 at 8:53
3  
The view on discussion type questions on stack overflow has hardened from when it first started and now they aren't tolerated at all really. The FAQ says "Chatty, open-ended questions diminish the usefulness of our site". You might get some takers if you want to discuss your question in one of the chat rooms. – Martin Smith Dec 5 '12 at 8:59
1  
show 1 more comment

closed as not constructive by Paul White, Martin Smith, Remus Rusanu, Jack Douglas♦ Dec 5 '12 at 10:07

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or specific expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, see the FAQ for guidance.

2 Answers

up vote 0 down vote

I'm not sure of the reasoning behind the question, do you think that INTERSECT is such an important part of SQL that anything without it is flawed??

MySQL didn't have procs, or views until v5, but it was still massively popular.

share|improve this answer
up vote 0 down vote

Simple answer is because it is doing what needs to be done.

While ago MySQL didn't support subqueries, transactions or EXISTS/IN statements and people were using it. While ago PostgreSQL was not supporting JOINs and people were using it.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.