To view parent comment, click here.
To read all comments associated with this story, please click here.
You're the ONLY person I've EVER met who is using pgsql and wants to switch to a less functional database server. That's like getting rid of your "free" BMW and getting a "free" Yugo. Buying into hype/popularity/branding, per-chance? I hope you don't go that route, because it's going to make life hell for your SQL devs and worse yet for your system admins. I sure hope your database isn't used for mission critical transactional processing where data integrity AND validity is key.
I did read the announcement. However, history dictates what will likely occur. I simply postulated as to what will happen, and my opinion is as valid as anybody else's.
Regardless, good luck with your migration, I wish you all the best - but I do hope you listen to reason instead of "buzz". 
Thanks for the advice. No, it's not the "buzz" that I want. My project is a small, in-house data analysis tool written by me, for me. I'm tired of dealing with the quirks of PG (vacuuming all the time, lack of easy-to-set-up performance monitors, etc.)
It could just be my lack of knowledge, but enforcing data integrity with anything over 300,000 rows in my table seems to cause more hassle than help. Performance grinds to a halt with all those internal consistency checks. I didn't experience performance issues back before I rewrote the project to use PG (I used MySQL previously).
So, even though I know I will have to do some extra work client-side, I think the tradeoff will be worth it. We'll see if I ever have the spare time to find out, though!







Member since:
2006-06-29
Read the announcement.
"ALL OF OUR DATABASE SOFTWARE IS OPEN SOURCE, so we will continue to make all releases available over our BitKeeper tree and as source code tarballs"
They aren't taking away our access to the source. They're simply putting out binaries for customers that want them.
I use PostgreSQL right now, but I've been wanting to switch to MySQL ever since their 5.0 release. The announcement of a more targeted business support structure makes me all the more eager to use MySQL.