Skip site navigation (1) Skip section navigation (2)

Database theory question

From: "Mag Gam" <magawake(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Database theory question
Date: 2008-04-17 19:43:36
Message-ID: 1cbd6f830804171243s36b66a66l5f41b7b6c587fab6@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi All,

While reading this article, History tables and event logging --
http://www.ibm.com/developerworks/web/library/wa-dbdsgn2.html, I realized I
try to do event logging in SQL.

My question are: Is SQL a good tool for event logging? Does anyone have a
sample table sctucture for the most optimal way of event logging? Current I
have 2 tables. 1 table with timestamps, another with event. Can anyone
recommend a better way?

TIA

Responses

pgsql-novice by date

Next:From: Nils ZierathDate: 2008-04-18 08:36:11
Subject: Re: Remote / network connection fails
Previous:From: Andrej Ricnik-BayDate: 2008-04-16 21:38:04
Subject: Re: Remote / network connection fails

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group