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

ERwin
ER/Studio
Database Design Studio Lite
CASE Studio 2
DeZign

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)
TORA http://www.globecom.se/tora/
TOAD
Data Architect (The Kompany) http://www.thekompany.com/products/dataarchitect/

From: Rod Roark rod@sunsetsystems.com
To: vox-tech@lists.lugod.org
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
support.

Browsing Freshmeat, I found a thing called Gedafe which looks really
interesting. Its home page is http://isg.ee.ethz.ch/tools/gedafe/.

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


From: dylan dylan@iici.no-ip.org
To: vox-tech@lists.lugod.org
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 timriley@timriley.net
To: vox-tech@lists.lugod.org
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 http://appaserver.org . 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 david@calteg.org
To: vox-tech@lists.lugod.org
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.
http://phppgadmin.sourceforge.net/

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.