[Feature Request] Schema Aliases and Versioned Schemas
От | AbdelAziz Sharaf |
---|---|
Тема | [Feature Request] Schema Aliases and Versioned Schemas |
Дата | |
Msg-id | CAObAeFim3uYus8EEFZ_dC7iLsJ6BDkUH-Pu-DTyjvuk28roGxQ@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: [Feature Request] Schema Aliases and Versioned Schemas
|
Список | pgsql-hackers |
Dear PostgreSQL Development Team,
I’d like to propose a new feature for consideration: schema aliases and versions
**Problem Statement:**
For migrating old db to new one, one must use an external tool or define a dedicated migration script where all possible issues could arise
**Proposed Solution:**
there is two ways I may think about
I’d like to propose a new feature for consideration: schema aliases and versions
**Problem Statement:**
For migrating old db to new one, one must use an external tool or define a dedicated migration script where all possible issues could arise
**Proposed Solution:**
there is two ways I may think about
- versioned schemas : where every version act as a separate schema and the `latest` one or the one the program request is the one in use and each new schema could inherit a table, index, view, ... without additional data
- aliases : where every new schema is defined and migrated separately then an alias is set for the one in use
**Benefits:**
- migration process for under dev projects will be more easier
- aliases : where every new schema is defined and migrated separately then an alias is set for the one in use
**Benefits:**
- migration process for under dev projects will be more easier
- App env stability, where no data need to be changed in the app other than the logic of newly modified schema, not the connection nor the schema or db name
- no need for external tools or servers to migrate or rollback
- minimal downtime between migrations and rollback
**why I post here**
it's addition to core pgsql
>> if it's not the right place : I could contact the mailing list you know it's supposed to take feature requests
Thank you for considering this feature request.
**why I post here**
it's addition to core pgsql
>> if it's not the right place : I could contact the mailing list you know it's supposed to take feature requests
Thank you for considering this feature request.
I look forward to feedback or further discussion on this idea.
Best regards,
Abdelaziz sharaf
Best regards,
Abdelaziz sharaf
В списке pgsql-hackers по дате отправления: