Re: Approaches for Lookup values (codes) in OLTP application - Mailing list pgsql-general

From Richard Huxton
Subject Re: Approaches for Lookup values (codes) in OLTP application
Date
Msg-id 47B5CDF9.1070306@archonet.com
Whole thread Raw
In response to Approaches for Lookup values (codes) in OLTP application  ("James B. Byrne" <byrnejb@harte-lyne.ca>)
Responses Re: Approaches for Lookup values (codes) in OLTP application
List pgsql-general
James B. Byrne wrote:
> I am considering how best to handle the issue of attribute encoding for an
> OLTP application conversion.
[snip]
> The conversion project framework is Ruby on Rails which embeds the practice of
> arbitrary integer primary keys assigned by sequencers rather than so-called
> "natural" keys or predicates that define the unique portion of the table-row.

I'm not a Rails guy, but everything I've read about it suggests if
you're going to gain any advantage from it, then you should follow its
way of doing things. That means not converting anything, but rather
writing a rails app that does the same as your current app (if I'm
making myself clear).


--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Pains in upgrading to 8.3
Next
From: "James B. Byrne"
Date:
Subject: Re: Approaches for Lookup values (codes) in OLTP application