What database to choose
-
Hello everyone, I am planning on developing an accounting application, and while planning what language to use etc... I came started to think about databases, and my question is here. I need a database that can be distributed with a setup file but is still powerful enough to handle a large amount of data and multiple users accessing the database at the same time but also offers good security which is also important, so can anyone recommend me a good database? and if it is open source its much better. I was maybe thinking of using MS SQLSERVER EXPRESS 2005. Thank you very much everyone really appreciate any help. Regards, Christian Pace
-
Hello everyone, I am planning on developing an accounting application, and while planning what language to use etc... I came started to think about databases, and my question is here. I need a database that can be distributed with a setup file but is still powerful enough to handle a large amount of data and multiple users accessing the database at the same time but also offers good security which is also important, so can anyone recommend me a good database? and if it is open source its much better. I was maybe thinking of using MS SQLSERVER EXPRESS 2005. Thank you very much everyone really appreciate any help. Regards, Christian Pace
There are limitations on SQL Server Express. Check it out to see if your "large amount of data" will exceed the limits. You can consider MySQL. I have been using MySQL in my projects for a few years. I am happy with it. It's reliable, powerful, and easy to use.
-
There are limitations on SQL Server Express. Check it out to see if your "large amount of data" will exceed the limits. You can consider MySQL. I have been using MySQL in my projects for a few years. I am happy with it. It's reliable, powerful, and easy to use.
loyal ginger wrote:
There are limitations on SQL Server Express.
Too true. Check others before Express. I can only go by my experience and so have no answer as to which to pick but do not pick Access. I have nightmares over trying fix a migration from Access that did things like make zip code a float.
-
Hello everyone, I am planning on developing an accounting application, and while planning what language to use etc... I came started to think about databases, and my question is here. I need a database that can be distributed with a setup file but is still powerful enough to handle a large amount of data and multiple users accessing the database at the same time but also offers good security which is also important, so can anyone recommend me a good database? and if it is open source its much better. I was maybe thinking of using MS SQLSERVER EXPRESS 2005. Thank you very much everyone really appreciate any help. Regards, Christian Pace
You may want to build into your design the flexibility of supporting multiple databases, like Oracle, MS-SQL, MySQL, etc. This way let your customer determine which database he/she will deploy your application. Do this by building a Data Access Layer that implements all of the interaction with the database in one location. Check this article out Implementing a Provider Independent Data Access Layer in .NET[^]
-
You may want to build into your design the flexibility of supporting multiple databases, like Oracle, MS-SQL, MySQL, etc. This way let your customer determine which database he/she will deploy your application. Do this by building a Data Access Layer that implements all of the interaction with the database in one location. Check this article out Implementing a Provider Independent Data Access Layer in .NET[^]
Yes this is really a good idea but i want to ask you one thing. This way you are "saying" that has knowledge in IT and knows how deploy a database and maintain it etc. What I would like to implement in my application is a database that is installed automatically in the system when the user installs the application so the user doesn't need to have any IT know how. Do you understand what I am saying? and thank you for your post anyways I agree with it and its a really good idea
-
loyal ginger wrote:
There are limitations on SQL Server Express.
Too true. Check others before Express. I can only go by my experience and so have no answer as to which to pick but do not pick Access. I have nightmares over trying fix a migration from Access that did things like make zip code a float.