473,221 Members | 1,943 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,221 software developers and data experts.

Example Database

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
6 6608
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
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
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
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
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
> 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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Patrick K. O'Brien | last post by:
I'm looking for a good schema to use as an example for an object database system. Something like a books/authors/publishers or teachers/students/courses kind of thing. There are plenty of...
2
by: James Johnson | last post by:
I have a question about creating a simple database. Here are the 2 tables. They are linked by the primary/foreign key 'client_id'. I think that I understand that part. I have 'KEY...
6
by: DH | last post by:
I have a VERY basic question about figuring database size. I've inherited a database which is generally similar to this basic one: Item, Red, Blue, Green, Yellow (text), (int),(int),(int),(int)...
8
by: RibGnaw | last post by:
Long, long ago when Access 97 first hit the streets a sample database called Northwind was shipped with it. At that time a number of articles had been posted on the correct procedure to remove all...
9
by: Pete | last post by:
Does anyone have a simple html vbscript or other type of snippet they can share that appends a record to a access database via ADO or DAO? I would like to allow users that don't have Microsoft...
2
by: William Herring | last post by:
I would like to set up a zope/database interface (using Postgres 7.4) with the following properties: - multiple users each with their own id and password - accessed via zope - they will enter and...
1
by: BCC | last post by:
Is there a way to create an alias that points to a databse? example : database name Retail Database desired result : declare an alias say Retail so everytime I refer to Retail it will point to...
3
by: Nathan Sokalski | last post by:
When I attempt to access a Microsoft Access database from my website, I recieve the following error: Server Error in '/' Application....
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.