db_flay 2.00

db_flay generates a simple - but productive - web interface for databases.

  Add it to your Download Basket!

 Add it to your Watch List!


Rate it!
send us
an update
GPL (GNU General Public License) 
Dr. Michael J. Chudobiak
ROOT \ Database \ Administrative frontents
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

#database frontend #web interface #database interface #db_flay #database #frontend #web

Add your review!