Choosing the right RDBMS...

From: Lucio (ifts_at_pixel.it)
Date: 02/27/04 

Date: 27 Feb 2004 04:31:25 -0800

Hello everybody.

I have to choose a RDBMS for my java apps and I'd like
to find one that meets the following:

1 - opensource
2 - table size limit independent of the undelying arch
3 - jdbc driver with support for updatable resultsets
4 - installation and configuration procedure well
    documented or easy like Firebird

Until now I've tried MySQL and Firebird.
Both seem to lack easy support for unlimited table size
due to the fact they use standard files, AFAIK. MySQL
offers the LFS solution to this, but
- it's not a clean solution as it requires at least
  a kernel rebuild.
- it is available only under Linux, so the table size
  limit still depends on the underlying architecture.
Moreover JayBird lacks support for updatable resultsets.

Is there anything that meets my requirements?

Relevant Pages

  • Re: Choosing the right RDBMS...
    ... > Until now I've tried MySQL and Firebird. ... > Both seem to lack easy support for unlimited table size ... Suse Linux Professional 8.1 on Athlon 1.1 Ghz 512 Mb ...
    (comp.lang.java.databases)
  • Re: Some free utilities for Java, with Hebrew support.
    ... protocol and server and add "extensions" to make their product more ... Provided you want to remain compatible with the "stock" MySQL ... the server you were using to support something ... client libraries don't support or in changing the protocol to break ...
    (comp.lang.java.programmer)
  • Re: SQL difference - mySQL and MS SQL
    ... MySQL is pretty far behind most of the other database ... They just added support for things such as stored ... I have never seen such a reference, and it highly depends on the version ... version 4 is nowhere near Microsoft SQL Server (in any version I've ...
    (microsoft.public.sqlserver.connect)
  • Mambo 4.0.14 Stable Bugs
    ... "into outfile" feature of MySQL. ... Because older versions don't support UNION function. ... In this case, username, md5() hashed password and email address of user ...
    (Bugtraq)
  • Re: Server Database - MySQL?
    ... Now that MySQL has reached version 5, it finally has support for transactions, triggers, stored procedures, and views. ... Postgres and Firebird have supported all those things for a while, so you might find better third-party support for those features with those databases than you would with MySQL. ... When I first started doing database stuff with Delphi, my only experience had been with Access and MySQL. ...
    (comp.lang.pascal.delphi.misc)