Koozali.org: home of the SME Server

Contribs.org Forums => General Discussion => Topic started by: rrizley on September 28, 2010, 06:59:39 PM

Title: MySQL Development Tools
Post by: rrizley 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.
Title: Re: MySQL Development Tools
Post by: cactus 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.
Title: Re: MySQL Development Tools
Post by: rrizley 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.
Title: Re: MySQL Development Tools
Post by: cactus 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).
Title: Re: MySQL Development Tools
Post by: Stefano 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 (http://www.servoy.com).. it is not free, but it does great things (and the application server runs flawlessy on SME)

my 2c