Database theory question - Mailing list pgsql-novice

From Mag Gam
Subject Database theory question
Date
Msg-id 1cbd6f830804171243s36b66a66l5f41b7b6c587fab6@mail.gmail.com
Whole thread Raw
Responses Re: Database theory question  (Decibel! <decibel@decibel.org>)
Re: Database theory question  (Jan Danielsson <jan.m.danielsson@gmail.com>)
List 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

pgsql-novice by date:

Previous
From: "Andrej Ricnik-Bay"
Date:
Subject: Re: Remote / network connection fails
Next
From: Nils Zierath
Date:
Subject: Re: Remote / network connection fails