Mysql belongs to Oracle. Is it doomed? PostgreSQL?

[eluser]dreamer111[/eluser]
MySQL was acquired by Oracle April 2009.

Since Oracle is the major produce of commercial database software I can't stop thinking about
quite obvious conflict of interests that this creates.Makes me wonder if I should continue using MySQL in my projects.

I can see how MySQL becomes less scalable, more bloated and less competitive in general in the long run, or gets commercialized. IMHO - I don't think it's gonna get the same attention from ORACLE's developers as they give to their own db software. New releases are probably gonna get a bit more buggy.

Is it time to ditch it for PostgreSQL which is completely open source comparing to MySQL?
Has anyone had a positive experience with PostgreSQL?

Would be nice to get Codeigniter's community insight on this one

[eluser]jedd[/eluser]
[quote author="dreamer111" date="1273953843"]
MySQL was acquired by Oracle April 2009.
[/quote]

This is not strictly true.

Since Oracle is the major produce of commercial database software I can't stop thinking about quite obvious conflict of interests that this creates.Makes me wonder if I should continue using MySQL in my projects.

Since IBM flog *nix and web server variants, yet contribute code to Apache and Linux (amongst other things) are you able to stop thinking about potential conflicts of interest there?

I can see how MySQL becomes less scalable, more bloated and less competitive in general in the long run, or gets commercialized. IMHO - I don't think it's gonna get the same attention from ORACLE's developers as they give to their own db software. New releases are probably gonna get a bit more buggy.

Prediction is a tricky business. I've not seen any compelling reasons presented as to why we should believe that MySQL will become less scalable, more bloated, less competitive, more commercialised (how it can do that with less attention from Oracle's developers would be an interesting trick) and more buggy.

IMO it's in Oracle's interest to keep MySQL customers happy - it's a bit of the market that a) they would have trouble pulling into Oracle (DB) anyway, and b) it's a good entry point for future customers of Oracle (DB).

Is it time to ditch it for PostgreSQL which is completely open source comparing to MySQL?

It sounds like you are quite confused on several fronts.

First, there are more than just Postgres and MySQL out there as contenders. Consider Maria - one really obvious alternative, but there are (of course) others.

Open source is a confusing term - you should read [url="http://www.gnu.org/philosophy/open-source-misses-the-point.html"]FSF's explanation of why 'Open Source' misses the point[/url] for some insight here.

But the important thing to note is that MySQL is already released under the GPL. This is what made the Maria (and various other) forks possible. I believe some engines are not quite so unrestricted, but I haven't done much research into this. Perhaps you could do some?

Has anyone had a positive experience with PostgreSQL?

My friend Anand has had lots of positive experiences with Postgres. I gather there's more than a few people that use it already, and seem to be happy with it. Perhaps you could install it and play with it for a few hours and give us your feedback.