Which of all DBMS?
-
Hello, I am trying to develop a program that uses data from a DBMS. But the problem is that I don't know which one(DBMS) I should use. The program is going to handle a couple of tables with a few thousands of records each. I have in mind MS-ACCESS and MySql but recently I discovered FIREBIRD which is released under the GPL licence(completely free to distribute with my software or at least this is what I understood).I am new to theese matters so please I need your advise...
-
Hello, I am trying to develop a program that uses data from a DBMS. But the problem is that I don't know which one(DBMS) I should use. The program is going to handle a couple of tables with a few thousands of records each. I have in mind MS-ACCESS and MySql but recently I discovered FIREBIRD which is released under the GPL licence(completely free to distribute with my software or at least this is what I understood).I am new to theese matters so please I need your advise...
Have you considered SQL Express, it is also free to distribute and will more than be able to handle the workload you are describing. It also has a GUI admin console and fully integrates into all versions (even the free express ones) of Visual Studio. As far as Firebird, never used it so can't say. Al
-
Hello, I am trying to develop a program that uses data from a DBMS. But the problem is that I don't know which one(DBMS) I should use. The program is going to handle a couple of tables with a few thousands of records each. I have in mind MS-ACCESS and MySql but recently I discovered FIREBIRD which is released under the GPL licence(completely free to distribute with my software or at least this is what I understood).I am new to theese matters so please I need your advise...
For a few thousand rows and freely distributable you may want to consider the size of the extra files you are distrubuting and how easy it is to have your installation file connect everything up on installation. * SQL Server 2005 Express Edidtion is quite bulky, so you may not want that. * SQLITE might also be appropriate for you - It is public domain and I think there are only one to two DLLs that you need to add to you to your install. What I'd do is draw up a matrix containing all the database products you are looking at across the top and all the features you are interested in down the side. For example:
DB -> SqlServer MySQL Firebird SQLITE
/Feature ExpressRedist.. Y ? ? Y
Install
Size Large ? ? 1-2 DLLs
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog -- modified at 3:58 Wednesday 17th May, 2006