postgres vs. mysql
- Started
- Last post
- 6 Responses
- i_was0
like you really need to know this, in fact you dont.
- spot130
This really only matters in web applications and large web sites but I'm thinking PostgreSQL is looking like the way to go. MySQL has been forked into many new projects since SUN became the owner and with tools like pgadmin (similar to phpmyadmin) seems like the open source market is slowly starting to move.
http://www.wikivs.com/wiki/MySQL…
- Crack_Junkie0
We use a combination of PostgreSQL and Redis here at work. Redis because it's insanely fast and perfect for large data and we write to PostgreSQL to save in event of the server going down. It's a pretty bad-ass setup.
- zaq0
MySQL is owned by Oracle now. PostgreSQL is still open source.
- vaxorcist0
this question used to cause religious wars....
At one shop I used to work at, we used database abstraction layers so we could switch DB's very fast, and test things on 2 db's.....
Note that of course, using a DB abstraction layer means you may be "genericizing" and not using whatever features one DB may have better than another, so your benchmarks may only be good for you, but beware of course that some Oracle license legal clauses prevent people from publishing their own benchmarks, hopefull the Island-Owning Sailboat Freak who keeps getting divorced and remarried won't impose his idiocy on mySQL now that he owns it.....