This category aims to cover Entity-Relationship Diagram applications
(used for data modeling in relation to large databases), such as:

Database Design Studio Lite
CASE Studio 2

And _also_ less-specialised diagramming software such as:

Microsoft Visio (formerly from Visio Corporation)

Please note that Visio is _not_ ERD software, as is so often asserted,
though it is frequently made to fulfill that role using expensive
plug-ins and extremely expensive back-end databases (notably Oracle).
However, the misconception is so pervasive that I have included
_genuinely_ comparable diagramming apps such as dia and Kivio.

Linux offerings include:

dia (diagramming)
Kivio (diagramming)
Data Architect (The Kompany)

From: Rod Roark
Subject: [vox-tech] SQL front-ends for web browsers
Organization: Sunset Systems
Date: Fri, 24 Oct 2003 17:34:19 -0700

I've been looking around for a time-saving tool for prototyping and/or
developing web-based database applications, preferably with PostgreSQL

Browsing Freshmeat, I found a thing called Gedafe which looks really
interesting. Its home page is

Has anyone here used this, and/or does anyone have suggestions for other
such tools?

From: dylan
Subject: Re: [vox-tech] SQL front-ends for web browsers
Date: Fri, 24 Oct 2003 20:08:37 -0800

how about 'dadabik'

From: Tim Riley
Subject: Re: [vox-tech] SQL front-ends for web browsers
Date: Fri, 24 Oct 2003 21:29:41 -0700
X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.16-22 i686)

Check out . It stores your database in a
database, and then it spits out web forms to allow you to query,
insert, update, and delete data.

Your drawings are of tables, attributes, and relationships. Appaserver
has a table for each of these, which you use Appaserver to populate.

From: David Siedband
X-Mailer: Apple Mail (2.606)
Subject: Re: [vox-tech] SQL front-ends for web browsers
Date: Mon, 27 Oct 2003 19:08:44 -0800

For a more generic prototyping tool have a look at.

For a more customized web interface check out Zope
Just set up you database adapter, code a few ZSQL queries and some DTML
or ZPT templates and you're sorted.