Which database to use?

[Joell]

Hi all,

I have been asked to develop a small system that is to be used on 1-2 Win2000 computers. The problem is I cant decide which database I should couple with Delphi. I have used Database Desktop 7 (Paradox Tables) with my other Delphi applications before and had quite a few problems maintaining the structure of the tables (esp modifying them!) and I am not keen on repeating the process. Other databases I have used on their own include Oracle SQL and Access. SO coming down to the problem, I'm asking for opinions on the databases you guys have used with Delphi and the level of 'difficulty' in using them as compared to Paradox tables.

P.S. Keep in mind I am still quite a novice programmer =D Cheers.

 

[jwenting]

If the application is to be used standalone (so no networked database) using Paradox or MS Access for it is the way to go.
If you're going for a multiuser environment, take a look at Firebird (

http://firebird.sourceforge.net).

You could use it on each user PC as well, but that might be a bit of overkill.

 

[svanels]

If it is networked use Interbase (from Borland)

Steven van Els
SAvanEls@cq-link.sr

 

[TonHu]

We all know: FireBird == InterBase gone open source ;-)

Any actively supported database will do, I use MySQL myself, but could have used Access, PostGreSQL, or any SQL 'based' database. This to easily maintain 'future-compatibility', as SQL is a *big* standard already. Paradox is a dead end IMHO.

HTH
TonHu