We help IT Professionals succeed at work.

MySQL and Desktop Applications

Medium Priority
461 Views
Last Modified: 2012-05-11
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!
Comment
Watch Question

Kevin CrossChief Technology Officer
CERTIFIED EXPERT
Most Valuable Expert 2011

Commented:
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.

Author

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?
Chief Technology Officer
CERTIFIED EXPERT
Most Valuable Expert 2011
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

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?
Kevin CrossChief Technology Officer
CERTIFIED EXPERT
Most Valuable Expert 2011

Commented:
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.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.