Also I have done this many many times. Hit me up if you want detailed help. On 11/8/10, Bryan O'Neal wrote: > The use case you describe was what ms access was built for. It > requires the full edition for development but you can use the free > version for everyone else. After that I recommend jave with eclipse, > after that php. > As for security I recommend ssh tunnels but ssl works in a pinch. > Note that if you have active directory you can push out your DSNs and > tunnel configurations from the domain controller. > > On 11/8/10, Alex Dean wrote: >> I'd probably recommend Java. It's pretty good for cross-platform GUI >> apps >> (and plenty of other stuff), but there's definitely a learning curve if >> you're coming from a scripting language background. You'll also need to >> learn JDBC if you're going to talk to MySQL. >> >> Eclipse is a top-notch IDE for Java development. Take a look at >> NetBeans, >> also. >> >> You've mentioned doing PHP work in the past, so maybe also take a look at >> PHP+GTK. The language will then be familiar, but getting cross-platform >> deployment will probably be more complex. http://gtk.php.net/ >> >> Maybe also consider Python, which has a gui package (tkinter) as part of >> its >> standard library. I've never used it, so maybe others can comment on it? >> I >> just thought maybe learning Python would be easier/quicker for you than >> learning Java. http://wiki.python.org/moin/TkInter >> >> For MySQL, you need to configure the server to support SSL. >> http://dev.mysql.com/doc/refman/5.0/en/secure-connections.html I suggest >> doing that on some port other than 3306, since 3306 is normally for >> unencrypted mysql traffic. >> >> alex >> >> On Nov 8, 2010, at 8:00 AM, keith smith wrote: >> >>> "Main PLUG discussion list" >>> >>> Hi, >>> >>> I would like to write an application that would more than likely run on >>> Windows and interface with MySql. This would be an app that would >>> interface with a database allowing the user to add / edit / delete data. >>> >>> The need is very simple. I was looking at Flex and find that I would >>> probably need to use their Flex Builder which is $700. That is not >>> feasible at this point. Trying to develop an app without it might be >>> more >>> of a pain than what it is worth. >>> >>> I could always use Java, which comes with it's difficulties also. >>> >>> My need is very simple. I need to create a simple menu, some forms, and >>> the ability to interact with MySql to manage data remotely - IE port >>> 3306. >>> I would like to use an open source language, compiled to hide my work >>> would be nice, Visual development environment would be good also. At a >>> very minimum, I would like it to run on Windows. Mac and Linux would be >>> a >>> plus. Security is an issue also. Must be able to securely attach to >>> port >>> 3306 w/o someone being able to sniff out the user name and password. I >>> know this is not a language issue, it is a configuration issue. I >>> wonder >>> if there is something like SFTP/SSH for MySql. >>> >>> As I was writing this I think Java might be the solution. Write once >>> run >>> everywhere. Java is open source and free. >>> >>> Is there a visual development environment for Java that is free, easy to >>> learn and robust? >>> >>> Is there another language or languages I should consider? >>> >>> Thanks for your insight! >>> >>> >>> >>> >>> ------------------------ >>> Keith Smith >>> >>> --------------------------------------------------- >>> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us >>> To subscribe, unsubscribe, or to change your mail settings: >>> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss >> >> --------------------------------------------------- >> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us >> To subscribe, unsubscribe, or to change your mail settings: >> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss >> > > -- > Sent from my mobile device > -- Sent from my mobile device --------------------------------------------------- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss