Discussion Locked

What database to use?

0 helpful
13 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am at the elaboration stage of a project. The remit is to build a number of user interfaces in Java to connect to a (SQL) database. This will initially be used on Windows machines, but may also be ported to Linux/Mac etc.

What database would you recommend (and why)?

TIA,
Quentin Pain

13 replies

by timthetoolman

Hi,

A couple of clarifying questions...

Is it the database that may potentially move platforms? Or simply the java client?

How many concurrent users is the database likely to have to handle? Any idea of transactions/sec?

Do you have a projected size of database?

Do you require high availability?

Can you give me an idea of the budget?

Cheers,
Tim.

by timthetoolman

Oh, and I should have asked... you mentioned windows but is that the platform for the database server? Or some other?

by jay eckles

If the SQL database would initiall be used on a Windows machine but might also be ported to Linux/Mac, then I would look for a cross-platform database management system. I know that MySQL will work on both Windows and Linux as well as several otherflavors of Unix, but I'm not sure if it has a version for Macintosh. I know on Macintosh Filemaker Pro has a lot of market share.

I think what I would do is modularize the database connectivity code - put it in its own class and give it a good interface. Then, when you're "porting" your application to another platform, the only code you'd have to change would be the database connectivity. Alternatively, have the Java application check what system it's running on then try to connect to a certain database driver depending on the result: SQL Server on Windows, MySQL on Linux, Oracle on Solaris, Filemaker on Mac, whatever.

Good luck.

Jay Eckles
www.jayeckles.com

by save your breath

Hi Tim,

I should have been clearer. My apologies. I need to create an application that can be run on anything from a stand-alone machine to a lan.

In short, I need advice on choosing a database which I can distribute on multiple platforms - and which I can connect to using Java.

Concurrent users around 6. DB Size will be around 10k records spread over 20 or so tables. The budget hasn't been set yet. The question is, can it be done with existing 3rd party software (ie. a database engine).

A Windows version is the priority, so if nothing else is available cross-platform, then what DB engine would you recommend?

Thanks,
Quentin Pain

by save your breath

Hi Tim,

I should have been clearer. My apologies. I need to create an application that can be run on anything from a stand-alone machine to a lan.

In short, I need advice on choosing a database which I can distribute on multiple platforms - and which I can connect to using Java.

Concurrent users around 6. DB Size will be around 10k records spread over 20 or so tables. The budget hasn't been set yet. The question is, can it be done with existing 3rd party software (ie. a database engine).

A Windows version is the priority, so if nothing else is available cross-platform, then what DB engine would you recommend?

Thanks,
Quentin Pain

by save your breath

Thanks Tim and Jay. The interface (on any platform) needs to be able to talk to the database (on any platform). Because the flavour of SQL varies, I am hoping that one database vendor will have a multi-platform version.

by timthetoolman

Hi,

Yep, I agree with the other answer of MySQL.
Its cheap and will port to other platforms better than most.

MS SQLServer and Oracle are overkill for your requirements.

Cheers,
Tim.

This discussion is closed to new replies.