Msql::RDBMS - Relational Database Management System for Msql
use Msql::RDBMS; $rdbms = new Msql::RDBMS; $rdbms->show;
This is a fully catalog driven database management system for Perl 5 and mini-SQL. You should use it in conjunction with the sqldef.pl script, found in the utility/ subdirectory of the installation; this script will generate data definition language for your tables.
You must pass the name of a schema definition file to sqldef.pl (an example, schema.def, is included in the examples/ subdirectory of the distribution). Example usage:
The above example will send the data definition language to STDOUT. To send it to mini-SQL (this will wipe out all of the data in the specified database):
sqldef.pl schema.def | msql database-name
The schema.def file contains a little bit of documentation on how the data is organized within the file, and how you can set up your own tables.
You can call up the entire Relational Database Management System from your browser with a URL like this:
Where sample.cgi is a Perl script containing the three lines of code shown in SYNOPSIS.
You can get some debugging information, which consists of a CGI::dump, and an SQL statement, if relevant, by including debug=1 in the URL.
Generate forms for interactive data definition. Enforce referential integrity (cascade/block deletes). * Add support for many-to-many relationships. * Enforce uniqueness for label columns. * Add fancy display options that support automagic hyperlinking of URLs and email addresses.
* denotes feature present in the original PHP/FI version.
Brian Jepson <firstname.lastname@example.org>
You may distribute this under the same terms as Perl itself.