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
---------------------------------------------------
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
(text/plain)