Yet another poll post on Friday. What, you think I’m getting lazy? Probably. What are you going to do about it. You are getting a poll today, and that’s that. I have another good one that is bound to incite some interesting flame wars in the comments. Let’s talk about databases!
What is your favorite database engine. One that you find yourself turning to, time and time again for most of your projects. Which database is the one you know like the back of your hand, and you can install and configure in your sleep.
For me, it has to be MySQL. And yeah, I know, they kinda suck now cause they decided to actually make money on their database. So they put all the cool stuff into the Enterprise version, and the public version gets neglected here and there. Still, I’ve been using it for years and have seen it grow from a little database project that could into one of the most widely used free DB engines in the world.
I used Oracle back in school – that’s what they were teaching us on. It was Java + Oracle all the way. Then me and my friend decided to jump ship and do our final project in MySQL and PHP – cause it was an online shopping cart kind of thing. At the beginning we like “WTF is this shit, you can’t do nested queries, and it’s like retarded”. But it was free, and we eventually fell in love with it – at least I did. MySQL came a long way since then and I many times in my adventure with it I would go: “Oh wow, I can do this now? Awesome!”
Some people have a lot of love for Postgress – which is apparently more free and more awesome than MySQL but I have personally never really had a chance to use it extensively. Some swear by Oracle, and some poor lost souls will use nothing but Microsoft SQL Server. What is your favorite?