[wxPython-users] Grid Cell Renderer

[Rich Shepard]

On Wed, 2 Jan 2008, Mark Erbaugh wrote:

> I agree. After composing this reply, I'm considering storing the category
> string directly in the MATERIAL table. In this application, the only
> advantage of normalizing the category name is to allow the category name
> to change and that's unlikely enough that it could be handled with a mass
> update: update material set c_name=<NEW CATEGORY> where c_name = <OLD
> CATEGORY>

Mark,

   That looks like the ideal solution. I know that there's a lot of
unresolved debate in the database world about surrogate keys, and I tend to
be in the group that avoids them.

   The primary key should be meaningful, and using a serial number just to
have a numeric primary key adds no value to the table. Storing strings when
they carry meaning is a good idea.

Glad you have a solution path,

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863