Also I have done this many many times. Hit me up if you want detailed help.
On 11/8/10, Bryan O'Neal <
Bryan.ONeal@theonealandassociates.com> 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 <alex@crackpot.org> 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" <plug-discuss@lists.plug.phoenix.az.us>
>>>
>>> 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