[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

MySQL and Desktop Applications

Posted on 2011-04-22
5
Medium Priority
?
425 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!
0
Comment
Question by:StumpedAndGrateful
  • 3
  • 2
5 Comments
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 35448367
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
 

Author Comment

by:StumpedAndGrateful
ID: 35448656
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
 
LVL 60

Accepted Solution

by:
Kevin Cross earned 2000 total points
ID: 35449381
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
 

Author Comment

by:StumpedAndGrateful
ID: 35450354
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
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 35485243
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question