From: Alessio Bragadini <alessio@albourne.com>
To: pgsql-hackers@postgresql.org
Subject: Re: [OT] Any major users of postgresql?
Date: Thu, 05 Jul 2001 10:32:47 +0300
Message-ID: <3B44181F.CC7639FE@albourne.com> (raw)
References: <200107031744.f63Hi4b21956@kzsu.stanford.edu>
Joe Brenner wrote:
> Sorry to bug the list with something a bit off topic, but
> I've been scrounging around for some examples of someone
> doing some fairly serious work with postgresql, and haven't
> yet been able to turn any up. Someone here must know a few
> off the top of their head...
It probably depends on what you call "serious". Anyway, the project I am
working on is a online community for alternate investments and is built
around a PostgreSQL (first 7.0, now 7.1) database: it's
<http://village.albourne.com; but unfortunately most of it is limited
only to subscribers so there is not a lot db-related to see. It's
PostreSQL + Apache + mod_perl on Digital Unix.
Another site is <http://www.animalhouse.it;, an Italian web site about
pet news and tips made by some friends of mine. It runs on a custom
content management system, again on the PostgreSQL + Apache + mod_perl
combination on Red Hat Linux. Being sponsored by a major portal, a lot
of hits are expected, but the site is brand new so no data is available
now.
Apart from the obvious wins of data integrity, transactions, etc. both
sites benefit from a number of SQL functions like triggers, foreign keys
with cascade behaviour, custom functions, and especially views, that
were simply not available under MySql. From all these, I would pick
views: I simply cannot see how you can arrange a coherent db design
(especially for a web project) without using views.
Hope it helps.
--
Alessio F. Bragadini alessio@albourne.com
APL Financial Services http://village.albourne.com
Nicosia, Cyprus phone: +357-2-755750
"It is more complicated than you think"
-- The Eighth Networking Truth from RFC 1925
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: alessio@albourne.com
Subject: Re: [OT] Any major users of postgresql?
In-Reply-To: <3B44181F.CC7639FE@albourne.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox