Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 1AFF59FC1BD for ; Fri, 25 May 2007 14:41:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 70892-06 for ; Fri, 25 May 2007 14:41:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mout2.freenet.de (mout2.freenet.de [194.97.50.155]) by postgresql.org (Postfix) with ESMTP id 7A6C49FC1B8 for ; Fri, 25 May 2007 14:41:23 -0300 (ADT) Received: from [194.97.55.147] (helo=mx4.freenet.de) by mout2.freenet.de with esmtpa (Exim 4.68) (envelope-from ) id 1Hrdn0-00065z-7d for pgsql-php@postgresql.org; Fri, 25 May 2007 19:41:22 +0200 Received: from lec67-1-81-56-104-13.fbx.proxad.net ([81.56.104.13]:22129 helo=tp570.private.tamay-dogan.net) by mx4.freenet.de with esmtpa (ID asmtp.tdnet@freenet.de) (port 587) (Exim 4.68 #1) id 1Hrdn0-0002hZ-2u for pgsql-php@postgresql.org; Fri, 25 May 2007 19:41:22 +0200 Received: by tp570.private.tamay-dogan.net (sSMTP sendmail emulation); Fri, 25 May 2007 19:41:08 +0200 Date: Fri, 25 May 2007 19:41:08 +0200 From: Michelle Konzack To: pgsql-php@postgresql.org Subject: Re: Application Design: Where to implement historical revisions of objects Message-ID: <20070525174108.GA6097@freenet.de> References: Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="BOKacYhQ+x31HxR3" Content-Disposition: inline In-Reply-To: X-Message-Flag: Improper configuration of Outlook is a breeding ground for viruses. Please take care your Client is configured correctly. Greetings Michelle. X-Disclaimer-DE: Eine weitere Verwendung oder die Veroeffentlichung dieser Mail oder dieser Mailadresse ist nur mit der Einwilligung des Autors gestattet. Organisation: Michelle's Selbstgebrautes X-Operating-System: Linux michelle1.private 2.4.27-2-386 X-Homepage-1: http://freenet-homepage.de/michelle.konzack/ X-Homepage-2: http://freenet-homepage.de/linux4michelle/ X-Uptime: 10:31:24 up 12 days, 12:40, 4 users, load average: 0.07, 0.05, 0.01 User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.181 tagged_above=0 required=5 tests=AWL=0.045, BAYES_50=0.001, FORGED_RCVD_HELO=0.135 X-Spam-Level: X-Archive-Number: 200705/9 X-Sequence-Number: 3798 --BOKacYhQ+x31HxR3 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hello Colin, Am 2007-05-23 13:10:42, schrieb Colin Ross: > In Practice: > An application has a model class of "PageContent" which represents the > content that is shown on a certain page. Users of the system are > authenticated, then able to edit the content. From an application design= =20 > point > of view, where should the logic and underlying system be for the manageme= nt > of historical revisions. I have something similar, exactly, a Database of military data and data sets are never modified but added. So, I give each dataset a serialnumber and a revision 0. Then if the dataset was modified I change the revision to a higher number and add the whole dataset into a new row. This thing is done using trigers. Greetings Michelle Konzack Systemadministrator Tamay Dogan Network Debian GNU/Linux Consultant --=20 Linux-User #280138 with the Linux Counter, http://counter.li.org/ ##################### Debian GNU/Linux Consultant ##################### Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSN LinuxMichi 0033/6/61925193 67100 Strasbourg/France IRC #Debian (irc.icq.com) --BOKacYhQ+x31HxR3 Content-Type: application/pgp-signature; name="signature.pgp" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFGVx+zC0FPBMSS+BIRAqSUAJ46cUH9sdWaZjyzC2C7T6j7ndQ0CgCgtmr8 1Ow8kJV7UEvW9HNnqhAtRYA= =BkKz -----END PGP SIGNATURE----- --BOKacYhQ+x31HxR3--