We help IT Professionals succeed at work.

Which type of database to use?

Mr_Fulano
Mr_Fulano asked
on
Hi, I need to create an application where the end user will enter data and it will be captured into a database. My development platform will be Apple's Objective C and Cocoa Touch. However, one of the requirements for the application is that a .NET version be developed at a later date so that non-Mac users can also have a PC version.

The contents of the database will be text based data and some images. The application will also need to be network capable, so that users in different locations can input data and it will all end up in one central repository.

My question is; what type of database should I use? - I would much rather use something that is openly available. In other words, I wouldn't want my end users to have to go out an purchase a database application suite specifically to use with my application.

I currently have at my disposal, MS Access and I'm sure I can download the free version of SQL, but is there a better choice? - I'm sure there is...

Thanks you for your assistance,
Fulano
Comment
Watch Question

SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2019
Commented:
If you want to concentrate on both Mac and Windows OS, then you can go for MySQL since you have MySQL available for both Mac and Windows environments..
If you are targeting only Windows ( mainly), then I would recommend you to go for SQL Server 2008 Express ( free version)

And of course, the free version of MySQL and SQL Server Express has some limitations and you need to worry about it if your application is going to be a large one in which case I would recommend go for some Full versions to get better performance.

Reason why I am saying large database is because you are going to save Images in your tables which would make your database grow faster..

Author

Commented:
Hi rrjegan17, this may sound like a silly question, but what are the difference between MySQL (Free) and MySQL (Full). I plan to design the system for both platforms.

Thank you,
Fulano
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2019

Commented:
Nope, you can find edition comparison here:

http://www.mysql.com/products/which-edition.html

And Enterprise edition is recommended for Mission Critical, reliable, large scale databases with Technical support and Extensive Monitoring tools.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2019

Commented:
>> I plan to design the system for both platforms.

Then you can go for MySQL else I would suggest MySQL for Mac and MSSQL for Windows..

Author

Commented:
Hi rrjegan17, thank you for your advice. I downloaded mySQL and have begun working with it to determine if it will be a good fit for my applications. I expect it will.

I did have one last question before I close this out and award you all the points.

In looking at the license for the FREE version of mySQL, it states that mySQL can be freely distributed gratuitously and for a fee. However, it states that any distributions must convey the all rights to those who it is distributed. OK, so what exactly does that mean? Does that mean that I have to provide "MY" source code to my end users to comply with the mySQL license...I wouldn't think so!

Do you know anything about this provision in their license/

Thanks,
Fulano
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2019

Commented:
>> Does that mean that I have to provide "MY" source code to my end users to comply with the mySQL license

Not, exactly..
Hope you missed the First point "The ``Program'', below, refers to any such program or work, and a ``work based on the Program'' means either the Program or any derivative work under copyright law: that is to say, a work containing the Program or a portion of it, either verbatim or with modifications and/or translated into another language. " in the link below

http://dev.mysql.com/doc/refman/4.1/ja/gpl-license.html

As per that Program refers to MySQL and its source code and work based on the program ie., your application which is subject to Copyright. You can pass Copyrighted information at your convenience or bound to any licenses but it should not affect the freely distributed MySQL.
So its in your hand to either pass in the source code of your application but the license to distribute the Program ie., MySQL should be under GNU Public license.

Author

Commented:
Great...thanks!

Author

Commented:
Great answer!
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2019

Commented:
Welcome..
And glad to assist you with..