Re: Approaches for Lookup values (codes) in OLTP application

From: Richard Huxton <dev(at)archonet(dot)com>
To: "James B(dot) Byrne" <byrnejb(at)harte-lyne(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Approaches for Lookup values (codes) in OLTP application
Date: 2008-02-15 17:38:01
Message-ID: 47B5CDF9.1070306@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message James B. Byrne 2008-02-15 18:12:43 Re: Approaches for Lookup values (codes) in OLTP application
Previous Message James B. Byrne 2008-02-15 17:09:06 Approaches for Lookup values (codes) in OLTP application