Plone DB Flay database browser

Category: Database integration & external storage — Other products by this author

Screenshot — click to enlarge

Current release: Plone DB Flay database browser 0.4.4

Released Jun 27, 2008 — tested with Plone 3.1, Plone 3.0

DB Flay - now Plone 3.x compatible!

List all releases… Full release announcement…

Get Plone DB Flay database browser for all platforms

Product Package

Project Description

Project resources

• Releases
• Contact address
• Project page

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.

More Information

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