db_flay 2.00

db_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.


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.

last updated on:
January 25th, 2006, 8:35 GMT
developed by:
Dr. Michael J. Chudobiak
license type:
GPL (GNU General Public License) 
ROOT \ Database \ Administrative frontents


In a hurry? Add it to your Download Basket!

user rating



Add your review!