db_flay Publisher's 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 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...
The Notable Features
The basic features:
* 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.
Fancy features for advanced applications:
* Apply regexp translations to certain fields - for instance, to convert part numbers into weblinks to related external websites (like an online catalog). You can see an example of this in the screenshot above - the Digi-Key stock numbers (which happen to end with "-ND") are formed into hyperlinks to the Digi-Key web site!
* Prefix data in certain fields with a URL (for instance, when the database stores a file name)
* A version suitable for use within the Plone Content Management System (CMS) is available: plonedbflay
What's New in This Release:. db_flay has been totally rewritten, and has been converted from mangled Perl to fresh, elegant, OOP Python.
System 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.
Program Release Status: Minor Update
Program Install Support: Install and Uninstall