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.