4GL Patterns #12 – Deploying Reference Tables

Sunday, 7 December 2008

Coda Server uses a concept called Reference Tables. I first heard the term used by Ken Downs.

The interesting twist brought by Coda Server is in deployability.

In the countries table, … use the REF TABLE .. Ref tables are identical to regular tables, except that they are replicated automatically across the development, testing, and production environments. Any rows added, updated or deleted in those environments immediately percolate to all of the others. This is perfect for data such as countries which generally don’t change based on your application’s whims.

Bookmark and Share

You should follow me on twitter here

Tags: , ,

The entry '4GL Patterns #12 – Deploying Reference Tables' was posted on December 7th, 2008 at 11:05 am and is filed under database. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

One Response to “4GL Patterns #12 – Deploying Reference Tables”

  1. 4GL Patterns #8 - Table Patterns | Chui’s counterpoint writes:
    No. 1 — December 7th, 2008 at 4:37 pm

    [...] Reference Table – small number of columns, small number of rows, permanent. e.g. U.S. States. Also see Reference Table Deployability [...]

«
»