db_flay

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

db_flay Ranking & Summary

Advertisement

  • Rating:
  • License:
  • GPL
  • Price:
  • FREE
  • Publisher Name:
  • Dr. Michael J. Chudobiak
  • Publisher web site:

db_flay Tags


db_flay Description

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.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 Related Software