Plone DB Flay database browser (0.4.4)

Introduction

plonedbflay generates a simple - but productive - web interface for Posgresql databases. The target user is a secretary, rather than a database administrator. (You will need a database administrator to configure the script initially.)

plonedbflay lets users view data, edit data, copy data, and delete data in multiple databases.

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)