Jump to content
  • Advertisement
Sign in to follow this  
dhammer

MySQL

This topic is 3887 days old which is more than the 365 day threshold we allow for new replies. Please post a new topic.

If you intended to correct an error in the post then please contact us.

Recommended Posts

I'm reaching out for help with MySQL. I'm just going to come right out and say, I'm a noob when it comes to databases in general and MySQL more specifically. I'm trying to learn though, my goal at the moment is to be able to create a MySQL database to be used in a MUD that i am making. I am writing the MUD in C# and at the moment i am having a lot of trouble with MySQL basics. If anyone has any pearls of wisdom on how i can start on my path towards this goal i'd appreciate it. I've been surfing the web and most things are either assuming i know basic consepts that i don't yet or just don't seem to answer my question. Thanks

Share this post


Link to post
Share on other sites
Advertisement
I appreciate that website it has a lot of great information, here is my follow up question though. Once i know how to create, delete, and manipulate my databases using the console commands how do i begin using C# to read and manipulate my databases?

Share this post


Link to post
Share on other sites
A good place where I once started on is Tizag's MySQL Tutorial. It will get you started on the basic functions like updating and inserting data. It also goes more advanced into joins (which I still have trouble getting myself), subqueries and grouping. The tutorials use PHP along with it, but for you all that matters is the SQL commands.

Also learn about things such as indexing and database normalization. They will help you create effective data structures in relational DB systems like MySQL.

Share this post


Link to post
Share on other sites
To be honest i opted for MySQL because i knew very little about the different versions of SQL and MySQL is what i heard of. What are the benefits of SQL Server Express and how is it different?

Share this post


Link to post
Share on other sites
Quote:
Original post by dhammer
To be honest i opted for MySQL because i knew very little about the different versions of SQL and MySQL is what i heard of. What are the benefits of SQL Server Express and how is it different?


MySQL is free. MS SQL Server is not.

MS SQL server is basically a proprietary storage engine. You are only limited to the Sybase-derived engine. Where as MySQL is an open-storage engine giving you multiple choices such as MyISAM, BerkleyDB and InnoDb and a few others.

The SQL Syntax is essentially the same with just a few differences.

As far as application development, you probably don't want to connect to any database directly. Use SOAP or some form of secure messaging to communicate over a network.

MS SQL does have the advantage for developing in the .NET environment because it does have a built in OLE container/connection wizard to connect to your database.

mySQL IMHO has worked great for all of the small projects i've developed.

Share this post


Link to post
Share on other sites
MS SQL Server Express is pretty darn near free, if not actually free. Its advantages include built-in integration with Visual Studio (if you're using that toolchain) and a very full-functionality SQL query engine.

For C# projects using under a couple hundred megs of data, I usually use SQLite through the absolutely fantastic System.Data.SQLite library, which gives SQLite the exact same integration advantages that SQL Server Express has. The advantage of SQLite is that there's no server to administer--your database is simply held in a single file or in memory. This makes administrative tasks like backups and moving the database to a new server absolutely trivial. SQLite is, in its current incarnation, extremely fast for small (less than 1GB) data sets. However, it does not perform well with multiple connections to the database--but your typical MUD will be running only one instance of the app, so that won't be a problem.

Share this post


Link to post
Share on other sites
I would think it would be just as beneficial to find a wrapper around something lightwheight if you are using a database for game info storage.

A while ago, when I was working with wxWidgets, I used SQLite for storage. It was fast, and quite easy with the wrapper I had found.

Good luck!
FlyingIsFun1217

Share this post


Link to post
Share on other sites
Sign in to follow this  

  • 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!