db_flay 2.00 review
Downloaddb_flay generates a simple - but productive - web interface for databases
|
|
db_flay generates a simple - but productive - web interface for databases. The target user of db_flay is a secretary, rather than a database administrator. (You will need a database administrator to configure the script initially.)
db_flay lets users view data, edit data, copy data, and delete data in multiple databases.
The copy feature is especially useful as a time-saver! For some reason, many other database tools leave this feature out...
Here are some key features of "db flay":
View, edit, copy, delete data in multiple databases.
Generates query forms for searching through the database.
Pre-defined queries can be used instead of a query form.
Can pre-populate query form fields with foreign keys, or
can pre-populate query form fields with existing data.
Can auto-increment serial-type fields when adding new data.
Pre-defined sorts, or click on field label to sort by that field.
*, % and spaces are interpreted as multi-character wildcards.
Requirements:
db_flay.pl should live in its own directory, along with the configuration file(s). Your web server (I use Apache on FC4) should allow perl scripts to execute in this directory. Putting db_flay somewhere in the "cgi-local" directory will probably make it "just work", at least with common Linux distributions.
The db_flay.pl script uses the perl CGI, DBI, and Time::HiRes modules. If you don't have them, you can get them from CPAN. The Time::HiRes module is just used to measure execution times, so if it causes problems, just delete the lines referring to the $time_start and $time_exec variables, and the "use Time::HiRes" statement.
What's New in This Release:
db_flay has been totally rewritten, and has been converted from mangled Perl to fresh, elegant, OOP Python.
db_flay 2.00 keywords