General discussion

Locked

What database to use?

By Save your breath ·
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

This conversation is currently closed to new comments.

13 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Comments

Collapse -

What database to use?

by TimTheToolMan In reply to What database to use?

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.

Collapse -

What database to use?

by TimTheToolMan In reply to What database to use?

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

Collapse -

What database to use?

by Save your breath In reply to What database to use?

Poster rated this answer

Collapse -

What database to use?

by Jay Eckles In reply to What database to use?

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

Collapse -

What database to use?

by Save your breath In reply to What database to use?

Poster rated this answer

Collapse -

What database to use?

by Save your breath In reply to What database to use?

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

Collapse -

What database to use?

by Save your breath In reply to What database to use?

Poster rated this answer

Collapse -

What database to use?

by Save your breath In reply to What database to use?

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

Collapse -

What database to use?

by Save your breath In reply to What database to use?

Poster rated this answer

Collapse -

What database to use?

by Save your breath In reply to What database to use?

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.

Back to Web Development Forum
13 total posts (Page 1 of 2)   01 | 02   Next

Related Discussions

Related Forums