Description

mySQLweb is a Perl script (or "web based front-end" if it sounds better) which provides web interface for building and executing SQL queries. It allows user to:

• add and remove tables to and from current query
• set relations between tables
• choose which fields to display
• apply certain criteria and/or function to certain field
• group and order by specified fields

All results are output in a table taking one or more pages. Default is 50 records per page but changing it is a matter of configuration. The design of mySQLweb front-end can be easily changed to anything you like, as it is nothing more then XHTML template - formatted using CSS.

Purpose

mySQLweb would preview the query generated on the base of choices made by user and then it would execute it. For beginners, this web front-end, could be very helpful in learning fundamental SQL syntax. More experienced users could use mySQLweb to save some typing or write advanced SQL queries directly (omitting the query builder).

Dependencies

• Relatively new version of CGI.pm module. See the source code for more information!
• DBI.pm module, and DBD::mysql database driver.

mySQLweb was meant to work with MySQL at back-end. It is possible (and not that hard) to modify it to work with other RDBMS, but so far it uses MySQL specific syntax (show databases, show tables, describe table).

History

version 0.3 (from X.2002)

• minor design modifications
• improved security (fixed XSS vulnerability)

version 0.2 (from IX.2002)

First, published version. Added use of XHTML template and CSS formating.

version 0.1

Written in the beginning of year 2002. Never made publicly available.

Resources

Home pages:

• http://milen.netbiuro.com/mySQLweb
• http://sourceforge.net/projects/mysqlweb/

Preview:

http://milen.netbiuro.com/cgi-bin/mySQLweb.pl (NOTE: This preview has restricted functionality!)

Download:

• from this site: mySQLweb-0.3.tar.gz [ 12K ]
• from SourceForge.net: mySQLweb-0.3.tar.gz