John,
Check out:
Xenon-SQL, the Java based interactive SQL Editor.
"Allows you use connect to relational database like MySql,
Sybase, and Oracle and submit SQL queries and commands
to the target databases."
At:
http://www.xenonsoft.demon.co.uk/software.html
It might give you some ideas towards your project.
Regards,
Shawn Patton
--------------------
John Holland wrote:
> I've been playing a little with the idea of a project with a Java front
> end and some sort of Linux backend database. I just want some
> confirmation of what I have seen in a very little bit of tinkering-
>
> mysql - seems to be quite fast, has good performance with jdbc.
> No transactions, no stored procs or triggers.
> Has foreign keys
>
> Costs, but not much
>
> Postgres - seems awfully slow - I installed 6.4.2 and tried a couple of
> things but it just seems SLOW when dealing with large numbers or records.
> Transactions, stored procs, triggers, jdbc (slow but there).
> Foreign keys only available via non DDL kludged triggers - not that
> hard to do but not at all standard or portable.
>
> Oracle - has everything, is fast - BIG $ to do it right
> Enormous footprint
>
> Any comments on these observations would be appreciated.
>
> John Holland
>
> -----------------------------------------------------------
> Send a mail to [EMAIL PROTECTED] with
> unsubscribe mysql [EMAIL PROTECTED]
> in the body of the message to unsubscribe from this list.
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
