public inbox for [email protected]  

help / color / mirror / Atom feed

From: AbdelAziz Sharaf <[email protected]>
To: [email protected]
Subject: [Feature Request] Schema Aliases and Versioned Schemas
Date: Fri, 22 Nov 2024 14:30:32 +0200
Message-ID: <CAObAeFim3uYus8EEFZ_dC7iLsJ6BDkUH-Pu-DTyjvuk28roGxQ@mail.gmail.com> (raw)

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
- 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
- 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.
I look forward to feedback or further discussion on this idea.

Best regards,
Abdelaziz sharaf

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: [Feature Request] Schema Aliases and Versioned Schemas
  In-Reply-To: <CAObAeFim3uYus8EEFZ_dC7iLsJ6BDkUH-Pu-DTyjvuk28roGxQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox