Which Database is best?

Question

Hi
lam developing an application to manage huge fleets of vehicles.this is being developed in VB iam slightly confused with which database to be used, i dont want MS Access to be used. can any body suggest me alternate cost effective DB

I have used MySQL , and also tried using Firebird. is there any other better DB.

please suggest
Thanks

Answer 1

Depends on what exactly it is that you will be doing with this database. I've used a dos based database for 20 years and I still haven't found one better than it. The name of this database is "Filepro Plus". Here at the office we used it to make home visit reports and to keep records. With this database you have complete control I mean complete control (screens, reports, calculations, inputing etc etc) you make your own adjustments as you see fit. Let me give you and example: screens...most windows base applications screate a screen for you automatically- filepro you create your own and you decide the field sequence. In other words with window base applications you are limited to the applications capabilities.

Answer 2

You're right. For a huge fleet of vehicles, MS Access probably isn't the best thing to use. I'd go with Sql Server. VB doesn't really work well with MySql without some time-consuming programming, and the Sql Server functionality is built in.



Microsoft offers an "express" version of Sql Server. It doesn't have all the features of a full (dedicated) Sql Server, but it's free.

Answer 3

As far as free databases go, MySql is probably best. There's also SQL Server Express, which plugs in to VB nicely and is free, but it's a local database only similar to Access, but with the performance of SQL Server.

Answer 4

The term "huge" is ambiguous. You need to really figure out what huge means. If it is small to medium then MySQL could be a reasonable choice. If it really is huge meaning it is on an enterprise scale then you should probably consder Postgres, DB2, Oracle and the likes. Cost effective is arbitrary since at the enterprise level you generally have to pay.

Answer 5

Either SQL Server Express or mySQL if you're funds limited. SQL Server Express is a little friendlier to the developer IMO.

Answer 6

SQL 2005 express.

In fact many (I am one of them) feel that SQL 2005 is better then Orcale.