Jump to content
  • Advertisement
  • entries
    437
  • comments
    1000
  • views
    336847

GDNet+

Sign in to follow this  
evolutional

128 views

Not GDNet+? Sign up now. [wink]

So yeah, I was looking to implement some SPs and even triggers into my ASP powered web system, then I realised that the installed version of MySQL was at 4.x. It doesn't support SPs or triggers, indeed it seems that only the basic fundamentals of RDBMS seem to be in place. I've seen people criticise MSSQL over MySQL and say that MySQL is better because it's free, yeah - if you like a database without any features that would allow you to better separate your application / data layers. It's a shame this server on Brinkster doesn't support a better RDBMS, but then again as I've always said, you get what you pay for.

Oh aye, I've just remembered - I'm going to dig out my old code and publically humiliate myself soon with how crap it is. It should be a good lesson for myself and others to see me post mortem a few of my failed, dead projects.
Sign in to follow this  


4 Comments


Recommended Comments

The problem with SQL in general is that there are so many different implementations that it's difficult to remember which one you're currently working with. Last semester I was working on a MSSQL statement and I started doing a MySQL join and it resulted in a 20% deduction because it didn't work correctly....

Share this comment


Link to comment
Having worked extensively with both MySQL and MSSQL, I can say with certainty that I vastly prefer MSSQL. MySQL is fine for what I would call "toy" projects, but when you start trying to do larger, more complex projects, MySQL pretty quickly becomes a bottleneck to deal with the workarounds to get things working the way you want.

I also am not trying to be a MS-phile either. Oracle is also much more powerful and flexible than MySQL, and I've used it as well. Personally, I've found MSSQL to be just about as powerful for most things and a lot simpler to learn and use. But the difference between Oracle and MSSQL is almost more a matter of taste than functionality, unlike the difference between those two and MySQL.

I will say, though, that my experience with MySQL is several years old at this point and I know that it now has things like transactions, etc. But I strongly suspect that it's still a matter of you get what you pay for, and MySQL is...free.

Oh, and don't get me wrong here, either. MySQL IS very useful for many smaller applications, in my experience and it's probably the best free database out there. It's all a matter of what you need.

OK, done ranting now =)

Share this comment


Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Advertisement
×

Important Information

By using GameDev.net, you agree to our community Guidelines, Terms of Use, and Privacy Policy.

We are the game development community.

Whether you are an indie, hobbyist, AAA developer, or just trying to learn, GameDev.net is the place for you to learn, share, and connect with the games industry. Learn more About Us or sign up!

Sign me up!