- Last post
- 6 Responses
like you really need to know this, in fact you dont.
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.
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.
or you an use mongoDB
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.....