Re: Fork: Proposed Architecture Changes in 2.0

["Joshua D. Drake" <..hidden..>]

On Wed, 2010-03-10 at 09:07 -0800, Roderick A. Anderson wrote:
> Well not really a fork as much as some additional thoughts that I didn't 
> see addressed and I wanted to keep them with the thread.
> 
> Two thoughts I'd like to kept in mind while building out v2.0.
> 
> 1. Running multiple "companies" with one web server instance, i.e. 
> NameVirtualHost in Apache.  This used to be an issue with mod_perl.  Not 
> sure if it is now.  I see two main places where this is useful.  An 
> accountant might want to host two or more companies on one server and a 
> service provider might prefer maintaining one web server verses one per 
> customer.

This can actually be done even if mod_perl does have a problem with it
because we can us set role within the app.

> 
> 2. Being able install into a schema in a database instead of creating a 
> database and installing.  This would allow a service provider to create 
> a "company/client" database and have several applications that use it. 
> In PostgreSQL terms one cluster (server) with many companies (databases) 
> using several applications (schema).  I have done this for LSMB via a 
> manual install so it works.

Yes, this would be good.

Joshua D. Drake


-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
Respect is earned, not gained through arbitrary and repetitive use or Mr. or Sir.