Gedafe is a Generic, Web-based, PostgreSQL Database Front-end written in Perl.

Gedafe is a Generic, Web-based, PostgreSQL Database Front-end written in Perl. It pulls all information it needs right from the underlying database. No database specific configuration is required in the front-end itself. Gedafe is nevertheless End-User-Friendly. This means that it provides a full featured Database Application Web-interface ready to be used by normal people.
The main idea behind Gedafe is to put all the application logic into the database along with meta-information on how to present the data. This allows to use a generic front-end which gathers that information and then builds the user interface accordingly.

Features:
- User authentication is done only at the database-level, it is transparent to the requested URL (after a login you get the page you requested initially). Authentication is based on cookies that expire server-side.
- Templates allow to customize the Gedafe generated Web interface
- POST is used only for data that modifies the database. Every view is encoded in the URL. This means that you can set bookmarks to screens inside Gedafe.
- Double Submit Protection. It is not possible to submit the same form twice. This ensures that data is only entered once even when Gedafe is used under non standard conditions.
- Gedafe can read additional setup information from special META tables stored alongside the production data in the database. This allows to enable additional Gedafe features or to override settings which Gedafe derived from looking at the table structure and naming scheme.
- Built-in support for external reporting modules allow to easily generate complex reports using external Perl modules.
- Every table Gedafe displays can be downloaded with a single click in comma separated format ready for import into a spreadsheet.