Re: Role Models Wanted

Take a look at HERMES (http://hermesweb.sourceforge.net). The demo is
running on MySQL, but as I state in the README's, MySQL is only supported
for demos due to a lack of support for many things. If you want I would be
happy to set up a demo on a PostgreSQL site (like the one I use internally
for testing). 0.1.0 is currently out and it may not be until 0.3.0 that the
application really starts making use of the power of PostgreSQL,

Best Wishes,
Chris Travers
----- Original Message -----
From: "Steve Crawford" <scrawford(at)pinpointresearch(dot)com>
To: "pgsql General List" <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, July 23, 2003 1:55 PM
Subject: [GENERAL] Role Models Wanted

> I'm searching for projects that would serve as good PostgreSQL examples.
In
> fact it would be nice to have a place on the PostgreSQL web page that
> featured some good examples. (If such a place exists and I missed it,
please
> let me know.)
>
> Ideally the project would have the following characteristics:
>
> -Open-source (naturally, it's hard to use as an example otherwise)
>
> -Good database structure/normalization
>
> -Good error detection/recovery
>
> -Appropriate use of back-end capabilities including functions, triggers
and
> rules
>
> -Good security practices
>
> -Appropriate use of special PostgreSQL features (non-standard data types,
> inheritance, etc.)
>
> A single project might not fulfill all these requirements so feel free to
add
> personal comments or warnings, eg. "Check out the foo project. It is a PHP
> based snarf tracker with a very good database design and extensive use of
> PL/PGSQL functions. Don't emulate the security, however, since the code
fails
> to check for dangerous input leaving it vulnerable to SQL injection
attacks."
>
> Also feel free to add characterstics to my list.
>
> Cheers,
> Steve
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>