About Site Map Submit Contact Us Log in | Create an account
Create an account Log In
Average Rating
User Rating:
Visitors Rating:
My rating:

Write review
  • License: Freeware
  • Last update: 6 years ago
  • Total downloads: 109
  • Price: Free |
  • Operating system: Linux
  • Publisher: Dr. Michael J. Chudobiak
See full specifications

linux default icondb_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

Is db_flay your software?

Manage your software

Most Popular

linux default icon A2Billing 1.6.0
A2Billing is a billing system interactive with Asterisk to give any Telecom company traditional offering VOIP... Read more
linux default icon FrontAccounting 2.3.10
FrontAccounting is free and released under the GNU General Public License.
linux default icon PgAdmin III for Linux 1.14.1
pgAdmin is the most popular and feature rich Open Source administration and development platform for... Read more
linux default icon RazorSQL for Linux 5.6.3
RazorSQL is an SQL query tool, database browser, SQL editor,....
linux default icon Salat Book 1.00
Salat / Namaz prayer database and tracking application