By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,303 Members | 1,271 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,303 IT Pros & Developers. It's quick & easy.

Example Database

P: n/a
I am rather new to PostgreSQL.What I am looking for ist this:

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?

Have been searching for some hours now, but did not succeed. Maybe I am
just being blind.

Thanx for any hints!

Regards, Erwin Brandstetter

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 11 '05 #1
Share this Question
Share on Google+
6 Replies

P: n/a
On Mon, 18 Aug 2003, Dustin Sallings wrote:
Postgres has enough features that I would guess you're not going to
find a database that uses all of them.

You'll probably find it a lot easier to learn postgres by thinking
of something you want to do and trying to solve the problem with postgres.
I find it really difficult to learn a new development tool without
having a particular problem to solve.

I almost chimed in earlier, but I'd certainly second this.

As far as the freedom Postgres offers in terms of flexibility of design,
there's no way any single DB will illustrate it well.

I started off using it becuase it was a real database in the free space,
and then started using other features when they made sense.

The ORDB stuff I've only used once; I have to admit that I like a fully
relational database. But there are cases I haven't seen...

The views/rules/triggers capability is priceless. Or, rather, Oracle
will put a price on it for you, which is significantly more than
Postgres.

Play with it.

-j
--
Jamie Lawrence ja*@jal.org
"The media is reality."
- US Air Force Major General Gene Renuart

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 11 '05 #2

P: n/a
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?


You can look at the database generated and tested when you run make check on
source. That should cover things fairly well..

Of course, truly all encompassing database is bit difficult to construct..:-)

Bye
Shridhar

--
Heller's Law: The first myth of management is that it exists.Johnson's
Corollary: Nobody really knows what is going on anywhere within the
organization.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 11 '05 #3

P: n/a
OK. I understand that you prefer a different approach. For my part, I
like to combine different approaches. I understand also that you
consider it impossible to put all the stuff into one database. I think
it is possible after all, but that is not the point here.

My request remains. I am looking for example databases that demonstrate
good style in using and combining the features of PostgreSQL. I am sure
there is something out there in the net. Would somebody be so kind to
point me there?

Regards, Erwin

Jamie Lawrence wrote:
On Mon, 18 Aug 2003, Dustin Sallings wrote:

Postgres has enough features that I would guess you're not going to
find a database that uses all of them.

You'll probably find it a lot easier to learn postgres by thinking
of something you want to do and trying to solve the problem with postgres.
I find it really difficult to learn a new development tool without
having a particular problem to solve.


I almost chimed in earlier, but I'd certainly second this.

As far as the freedom Postgres offers in terms of flexibility of design,
there's no way any single DB will illustrate it well.

I started off using it becuase it was a real database in the free space,
and then started using other features when they made sense.

The ORDB stuff I've only used once; I have to admit that I like a fully
relational database. But there are cases I haven't seen...

The views/rules/triggers capability is priceless. Or, rather, Oracle
will put a price on it for you, which is significantly more than
Postgres.

Play with it.

-j

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 11 '05 #4

P: n/a
On Thu, 2003-08-21 at 01:50, David M. Cook wrote:
On Mon, Aug 18, 2003 at 04:19:44PM +0200, Erwin Brandstetter wrote:
An example database that demonstrates the usage of all the core
PostgreSQL features.


This looks rather interesting:

http://wfb2sql.sourceforge.net/

(CIA World Fact Book to SQL.)


But the CIA is Eeeeeeeevil, and PostgreSQL is Pure (it's is Debian
Main after all!).

How could you even *think* of corrupting PG in that manner?????
--
-----------------------------------------------------------------
Ron Johnson, Jr. ro***********@cox.net
Jefferson, LA USA

Regarding war zones: "There's nothing sacrosanct about a hotel
with a bunch of journalists in it."
Marine Lt. Gen. Bernard E. Trainor (Retired)
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 11 '05 #5

P: n/a
On Thu, 2003-08-21 at 02:21, Shridhar Daithankar wrote:
On Thursday 21 August 2003 12:44, Ron Johnson wrote:
On Thu, 2003-08-21 at 01:50, David M. Cook wrote:
On Mon, Aug 18, 2003 at 04:19:44PM +0200, Erwin Brandstetter wrote:
> An example database that demonstrates the usage of all the core
> PostgreSQL features.

This looks rather interesting:

http://wfb2sql.sourceforge.net/

(CIA World Fact Book to SQL.)
But the CIA is Eeeeeeeevil, and PostgreSQL is Pure (it's is Debian
Main after all!).

How could you even *think* of corrupting PG in that manner?????


Well, that was nice but in case somebody misses the point of joke, from the
website..


Well, actually, no, I was talking directly about the CIA itself.

Am I dating myself by presuming that most people think of the CIA
a a bunch of ultra-right-wing incompetent spooks that go around
toppling "freely" elected governments?
-------------
The CIA World Factbook
wfb2sql has been tested with the Factbook 2003 and 2002. The Factbook is
available for free at http://www.cia.gov/cia/publications/factbook/. Extract
from the Copyright-Statement: "The Factbook is in the public domain.
Accordingly, it may be copied freely without permission of the Central
Intelligence Agency (CIA).". The complete .zip-archive has as size of approx.
85 MB. Since wfb2sql doesn't need the included PDF-maps, you may also decide
to download the smaller version without the PDF-maps. This download is about
15 MB.

--
-----------------------------------------------------------------
Ron Johnson, Jr. ro***********@cox.net
Jefferson, LA USA

"they love our milk and honey, but preach about another way of living"
Merle Haggard, "The Fighting Side Of Me"
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 11 '05 #6

P: n/a
> 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
ma****@erhs.la

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 11 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.