MySQL and Desktop Applications

I am debating about whether to use MySQL or MS SQL Server with a client-server Desktop Application.  I had planned to write the application in C#, but that is not set in stone.  I am a relative novice at client-server applications at this point.  I had heard that MySQL was more for web applications and not for desktop applications.  What are the limitations MySQL has with desktop applications?  MySQL is very, very attractive, because of the price.

Thanks so much for your help!
StumpedAndGratefulAsked:
Who is Participating?
 
Kevin CrossConnect With a Mentor Chief Technology OfficerCommented:
See the links above for the 'catch'.  *smile* MySQL has its limits also based on operating system.  It is pretty powerful and will likely fit most needs.  In the past, one reason to shy away was not having things like triggers and stored procedures, but as new versions have come out more functionality has been added --- just keep in mind that MySQL has a paid version also, so MySQL's free version should really be compared to MS SQL's free version for true apples and apples.

Try Java.  Other langaguages available too that I am less familiar with. :)
0
 
Kevin CrossChief Technology OfficerCommented:
It depends on your application's needs.  If you are programming in C#, though you can use .NET with MySQL, it may make a pure Microsoft platform more attractive.  Note that SQL Server 2008's new express edition can handle up to 10GB databases.  The limitation there is on processor (1) and memory (1GB).  Depending on your application, this may or may not be an issue.  For MySQL, there are similar limitations:

http://dev.mysql.com/doc/refman/5.6/en/limits-windows.html
http://dev.mysql.com/doc/refman/5.6/en/full-table.html

To answer your question, MySQL's limitations aren't specific to type of application, i.e., web versus desktop---they are simply limitations, so as long as they meet your needs, you should be fine.

0
 
StumpedAndGratefulAuthor Commented:
so, I can't really wrap my arms around why ppl would pay for MS SQL Server (beyond free Express edition) if MySQL is free?  There has to be some kind of catch?

I have heard a few times now that .Net works best with MS SQL Server.  it would not be hard for me to move from c#, as i am just learning the language (i'm coming from acces & vba - liked microsoft & that's why i picked c#).  If I go with MySQL for a desktop application, is there another programming language that works with it better than C#?  preferably one that's pretty popular?
0
 
StumpedAndGratefulAuthor Commented:
I guess I'm a little confused by the link, though I shouldn't be.  Can you tell me what the size limitation is on a MySQL database if it's running on Windows 7 64 bit?
0
 
Kevin CrossChief Technology OfficerCommented:
By using a 64-bit version of Windows, you open up the memory limitations imposed by 32-bit.  I always read the 32-bit file limit as 2GB, but it is 2TB; therefore, I have not seen anything specific for 64-bit Windows but should be fine there.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.