Nan Null wrote:
> I agree. However, it would be great if Java provides more functionality in JDBC.
I'm no expert, but seems pretty complete and standardized to me?
> Such as standardize on creating databases and other administration stuffs.
> Now Sun has MySQL, they're more interested in the inner working of it, and provide better Java support for all major database would be great.
>
Every major database I can think of and every 'minor' database I can
think of has a JDBC driver?
> I also hope of a top not database admin/client GUI in Java. SQuirreL SQL is nice, but there are still alot to be desired. sqldeveloper is nice, and I think most if not all of it is written in Java, but it's Oracle only.
>
I can't argue with you there, if you find one or write one, let me
know, I'll use it.
> Although setting up MySQL is easy, it would be great if it's much easier. I just don't see why not. It would be nice to unzip, and you have it.
> Then double click to have an admin/client where you can create a database, add users, grant permission, setup to start as a service, etc., all in one place.
>
Have you tried the GUI tools freely available for MySQL, from MySQL? I
use them all the time, seem pretty 'point and click' user friendly.
http://dev.mysql.com/downloads/gui-tools/5.0.html