Koozali.org: home of the SME Server

MySQL Development Tools

Offline rrizley

  • *
  • 16
  • +0/-0
MySQL Development Tools
« on: September 28, 2010, 06:59:39 PM »
Just wanted to ask everyone what is their favorite development tool.  I am wanting to develop a web-based application using MySQL with web services.  I have tried Microsoft Visual Web Developer 2008 Express.

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: MySQL Development Tools
« Reply #1 on: September 28, 2010, 09:09:18 PM »
Just wanted to ask everyone what is their favorite development tool.  I am wanting to develop a web-based application using MySQL with web services.  I have tried Microsoft Visual Web Developer 2008 Express.
That totally depends on what you need the tool to do. You should be more explicit.

For developing databases you could be wanting to generate a database scheme, generate the scripts to create the database, it's tables, views, procedures etc. Perhaps you only need a tool to modify the data in the database through a GUI.

Regarding the application, what programming language do you want to use? Perl, PHP, ASP, something else?

For developing PHP applications I use PHPEdit. A very complete IDE. For editing, modifying or other actions on a MySQL database there are several tools, like for instance Navicat, but you might be satisfied with the MySQL Workbench (either the Commercial or the Community edition) or perhaps a webinterface, like PhpMyAdmin, that can be run on the server as well.

For simple modifications or small scripts I do not even use a development tool, instead I use a simple text editor or a command line client.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline rrizley

  • *
  • 16
  • +0/-0
Re: MySQL Development Tools
« Reply #2 on: September 28, 2010, 09:43:53 PM »
Thank you for your input.  We currently have a Visual Foxpro-based client information system that I want to convert to MySQL, and I want to go web-based and need to integrate it with web services.

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: MySQL Development Tools
« Reply #3 on: September 28, 2010, 09:53:48 PM »
Thank you for your input.  We currently have a Visual Foxpro-based client information system that I want to convert to MySQL, and I want to go web-based and need to integrate it with web services.
If you need to use webservices, you might want to consider some sort of SOAP, XML-RPC or REST based solution (if the webservices are not running on the same host or should not have direct access to the database).
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline Stefano

  • *
  • 10,894
  • +3/-0
Re: MySQL Development Tools
« Reply #4 on: September 28, 2010, 10:23:14 PM »
Thank you for your input.  We currently have a Visual Foxpro-based client information system that I want to convert to MySQL, and I want to go web-based and need to integrate it with web services.

you could give a look at servoy.. it is not free, but it does great things (and the application server runs flawlessy on SME)

my 2c