Thank you for your feedback. It is a web based PHP app. It has a control panel for editing the data. I was thinking it might be nice to have a desktop application that has the same features as the browser based application.
------------------------
Keith Smith
--- On Mon, 11/8/10, Simon Chatfield <
simon@thechatfieldgroup.com> wrote:
From: Simon Chatfield <
simon@thechatfieldgroup.com>
Subject: Re: OT? : Open source development tools / programming language
To:
plug-discuss@lists.plug.phoenix.az.us
Date: Monday, November 8, 2010, 8:04 AM
Hi Keith, you've asked a bunch of questions here, and to be honest,
based on what you're asking and how, I would recommend you source a
developer to take on the effort for you. But, here are my thoughts.
Keep it server side, throw a web server on the machine with the
database (or ideally, on a server sitting next to the database
machine), behind a firewall. Password protect the web application so
your mysql is hidden and secure within your own network. Choice of
language at this point is entirely up to you, php, java, etc.
If you must have client/server, sounds like Java is your best bet,
there are many Integrated Development Environments (IDEs) you can
choose from, netbeans comes with some java distributions so might be
your easiest bet. If you go this route with a remote application
talking to your database, I further recommend that you have a server
side component which manages the database and communication back and
forth to the client application. This is mainly for security
purposes, but will also ensure that the client application doesn't
do anything the server doesn't know about.
If you insist on having mysql ports open to the internet, set up
ACLs so you can restrict connections based on IP or other method.
-Simon
On 11/8/2010 7: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
--
Simon Chatfield
President/CEO
The Chatfield Group, Inc.
simon@thechatfieldgroup.com
480-776-6390
-----Inline Attachment Follows-----
---------------------------------------------------
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 
(text/plain)