Discussion in 'Closed Suggestions' started by Alexander, Sep 24, 2010.
PostgreSQL is a great alternative to MYSQL so built-in in support for it would be nice.
While I agree, I think they should concentrate on just MYSQL for the time being. It's A LOT of work up-keeping two database platforms, and MYSQL seems to be working just fine.
Whys is it a great alternative? What benefits does it have over mysql?
I think PostgreSQL support would be great in the future.
MySQL is now owned by Oracle which is well not a very trustworthy company.
They have already practically killed the open source edition of Solaris.
Things are likely to become complicated for MySQL as well in the future.
PostgreSQL is extremely poor for smaller sites. The only benefits are for larger sites. Additionally, Oracle would be committing suicide should they wish to kill off MySQL - in fact, the developers would fork it out, and continue development, independant of MySQL/Oracle.
we can only hope that MySQL survives the wrath of Oracle. of course it cannot be shut off from the open source scene. but there are still plenty of fears in the market.
If they abstract the database system, then mysql specific optimization disappears.
If oracle cuts of mysql, im sure there are more experienced developers out there that can continue it.
well the financial incentive might not be there. we can only hope that some other company adopts it. but then... mysql is losing its popularity amongst the giants of the web. twitter/facebook i believe are no longer relying on it.
I know they upgraded to 5.1 in July of this year. In fact, on the 17th, they pushed a few more updates to MySQL for FaceBook.
Twitter uses Cassandra, and in my opinion, this isn't suited for a forum use.
If someone better comes along i'm all for it [performance, security, paid vs open source etc].
ooh. here are some links...
Facebook Blog does not have anything major related to MySQL.
All of the Facebook stuff to do with MySQL has been made public at the notes.
Let me quote:
"Cassandra … is column-oriented and allows for the storage of relatively structured data. It has a fully decentralized model; every node is identical and there is no single point of failure. It's also extremely fault tolerant; data is replicated to multiple nodes and across data centers. Cassandra is also very elastic; read and write throughput increase linearly as new machines are added."
Cassandra doesn't provide the ad-hoc structure we need, it's lost. Cassandra I believe is available only on Linux. Implementation for such NoSQL databases would be very painful. Twitter does not use Cassandra for the tweets themselves; they continue to use MySQL.
But going back to the topic, PostgreSQL - how many of you have tried to use it on a small site?
looks like Facebook could be our hope to save MySQL if Oracle messes up with it!
Google uses it. Wikipaedia uses it. In fact, just go here: http://www.mysql.com/customers/
Back on topic, what are the benefits of Postgres over mysql in a forum setting?
In a large forum, the transactions are quicker.
Oracle owns Sun now, and suing Google over Java/Android.
Educate yourselves. http://arstechnica.com/open-source/...it-undermines-its-open-source-credibility.ars
well as i had stated above. this is just a perception and nothing has been done yet
Larry Ellison may not want to make more money, you are right. Let me just toss some information your way.
Oracle is going to integrate mysql into enterprise solutions. What makes you think he cares about your website?
Separate names with a comma.