From: | "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com> |
---|---|
To: | "Michael D(dot) Allen" <mallen(at)erhs(dot)la>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Example Database |
Date: | 2003-08-22 04:54:50 |
Message-ID: | 71E37EF6B7DCC1499CEA0316A2568328010570D2@loki.globexplorer.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Informix has its "stores" demo database (more as a training exercise that a real demo); some of the extensions include extensions to the stores db.
Not sure there aren't two things:
a) a place to show off features to prospective users. Ideally it tells how it works as well.
b) a playground/demo area for those who have installed one.
I think this thread relates to (a); the SQL demo and informix' demo are both more in category (a).
Greg Williamson
DBA GlobeXplorer LLC
-----Original Message-----
From: Michael D. Allen [mailto:mallen(at)erhs(dot)la]
Sent: Thu 8/21/2003 8:55 PM
To: pgsql-general(at)postgresql(dot)org
Cc:
Subject: Re: [GENERAL] Example Database
> On 18 Aug 2003 at 16:19, Erwin Brandstetter wrote:
> An example database that demonstrates the usage of all the core
> PostgreSQL features. It is one thing to read extensive documentation,
> but it is much more intuitive for me to see an example database, that
> demonstrates the whole thing interacting. I mean, not just the basic
> elements, but an optimized (and maybe nicely documented) database
> getting the best out of views, triggers, indices, rules, stored
> procedures and so on - maybe even a reference database from the
> PostgreSQL developers themselves?
Yes, this would be very nice indeed. Oracle is an extremely complex
(overgrown)database with a ton of features, but it ships with a set of
example schemas that show off a variety of features pretty well. I'm
speaking of the set of schemas that try to model a company: OE, HR, etc.
SQL Server ships with Northwind and pubs, as another example. But, we would
need a good supplementary document that goes along with whatever
materialized, perhaps guiding new users along in a tutorial manner.
--
Michael D. Allen
mallen(at)erhs(dot)la
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
From | Date | Subject | |
---|---|---|---|
Next Message | Shridhar Daithankar | 2003-08-22 06:26:16 | Re: 7.4b1 vs 7.3.4 performance |
Previous Message | Mike Mascari | 2003-08-22 04:47:14 | Re: strftime |