Re: Design database schemas around a common subset of objects - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Design database schemas around a common subset of objects
Date
Msg-id 8555f244-6bc0-51b0-9143-8caeaed150a7@aklaver.com
Whole thread Raw
In response to Design database schemas around a common subset of objects  (Erik Wienhold <ewie@mailbox.org>)
Responses Re: Design database schemas around a common subset of objects
List pgsql-general
On 11/6/21 17:02, Erik Wienhold wrote:
> I'm brainstorming ideas on how to design database schemas that share a
> common subset of objects and stumbled on some issues.  Maybe someone has
> experience with such a design.  Any ideas are welcome!
> 


> 
> Because of this issue I'm hesitant going with an extension for this use
> case, especially once we have versions with backward-incompatible changes.
> Instead I'm thinking about something similar to the update scripts we use
> for extensions but checking them into version control for each customer
> project.

My questions for this are:

1) How stable are the core objects?

2) How divergent are the customer specific requirements?

3) Given 1) and 2) would it be possible to craft extensions that where 
not customer specific?

4) Are you using or have you looked at Sqitch(https://sqitch.org/)?

> 
>     Erik
> 




-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Erik Wienhold
Date:
Subject: Design database schemas around a common subset of objects
Next
From: Erik Wienhold
Date:
Subject: Re: Design database schemas around a common subset of objects