Re: multi-company design/structure ? - Mailing list pgsql-general

From John
Subject Re: multi-company design/structure ?
Date
Msg-id 200910201145.41963.jfabiani@yolo.com
Whole thread Raw
In response to Re: multi-company design/structure ?  (Wolfgang Keller <feliphil@gmx.net>)
Responses Re: multi-company design/structure ?
Re: multi-company design/structure ?
List pgsql-general
On Tuesday 20 October 2009 10:11:53 am Wolfgang Keller wrote:
> > Is it better to create multi databases or create multi schemas?
>
> You're missing one option imho: One database, one schema.
>
> > I am writing a program that can have multi instances.  Sort like a
> > finanical accounting system that can have multiable companies. Where each
> > company has a different name but the tables are an exact match to each
> > other.
>
> Then you could simply add a "company-id" column to every table (and make
> this column part of the primary key of each table). And if you run multiple
> instances of the program within _one_ company, then you can also add an
> "instance-id" column (and make this column also part of the primary key of
> each table).
>
> Sincerely,
>
> Wolfgang

I never even considered using the one database with added company
field/column.  On the surface is sounds OK but I'm not to sure.  Each SQL
statement would require company_id.  Hmmmm.

Johnf



pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: PostgreSQL driver for Joomla review
Next
From: Rich Shepard
Date:
Subject: Re: multi-company design/structure ?