OT? : Open source development tools / programming language

[keith smith]

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 at thechatfieldgroup.com> wrote:

From: Simon Chatfield <simon at thechatfieldgroup.com>
Subject: Re: OT? : Open source development tools / programming language
To: plug-discuss at 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 at 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 at 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 at thechatfieldgroup.com
480-776-6390
  

-----Inline Attachment Follows-----

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss at lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.PLUG.phoenix.az.us/pipermail/plug-discuss/attachments/20101108/add0b76e/attachment.html>