Postgres Schema level migration using Alembic for Python

The popular database choice among python developers has been PostgreSQL, One of the main reason behind it is PostgreSQL Schemas. Schemas provide the ability to group collections of tables of the database under one name.

Schemas are homologous to directories at the operating system level, except that schemas cannot be nested.

Some advantages of using PostgreSQL schemas are:

  1. To allow many users to use one database without interfering with each other.
  2. To organize database objects into logical groups to make them more manageable.
  3. To allow users to make use of the tables in the schema,  privileges need to be granted by the owner.

(more…)

SUBSCRIBE!

Do you want to get articles like these in your inbox?

Email *

Interested groups *
Healthtech
Business
Technical articles

Archives