Plone DB Flay database browser

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.

Project Description

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)

Demo Site

Please visit http://www.avtechpulse.com:8080/demo#demo for a demo site.

Installation Guide

An installation guide is available.

More Information

Please visit http://www.avtechpulse.com:8080/demo for the full details.

Commercial Support

I do not provide direct support for plonedbflay. However, Eurotux has worked on plonedbflay for me, so they are familiar with the product and may be able to provide you with commercial support ($$$) and custom development.