Hi -
Just curious if some of the database programmers would be interested in commenting on GUI's for db front ends. Swing is much maligned, but seems stable enough [Oracle can't deprecate something in the "core definition" of the
Java language, right?] and rich enough to do the job (basically recreating an MS Access database application using Java as a front end for MySQL).
I know it is possible to run various scripting languages via Java libraries. Is Jython, or, another scripting language known to be well suited for GUI building? Any thoughts on the pros and cons of such an approach? I was intrigued by JavaFX, but it seems to have had its plugged pulled.
In the posts I've investigated here, folks are mentioning HTML &
JSP front ends. That might be feasible as well, but the particular project I'm envisioning would run on a company network, so I figure I might as well take advantage of Swing rather than going through a browser.
I'm still investigating possibilities. Mostly, the Microsoft churn is causing headaches as Access gets more bloated and the new versions (2007, 2010) seem to run slower than good old 2003 Access, and there is understandable resistance to moving to a SQLServer backend.
Java running MySQL should be a lot speedier than MSAccess, I figure. Any disagreements on that estimation? I'll be able to do a lot to restrict the amount of information flowing over the network, whereas Access seems to want to send over entire tables when you only need a record.
I'm also curious if there is a
JDBC for MSAccess available that doesn't cost in the neighborhood of $1000. I'm confused about whether and how the dual connection via ODBC would work. But I figure I can also write some export routines in VBA to create files for Java to load (listing MS Form and Report objects and properties) to be used in recreating the existing forms and reports.
I started studying Java about a year ago and SO MUCH prefer the Java environment to dealing with Microsoft. Way to go, Java Community! Would love to be able to pull this off and be free of MS.
Thanks for your thoughts. I hope this wasn't too general a question for the JDBC area, but I wanted to target the opinions of db programmers.
Phil Freihofner