Django
Migrations
Use the RunSQL
operation.
First, create a migration:
python manage.py makemigrations \
--empty \
--name electrify_items \
app_label
Then add a RunSQL
operation to the generated migration file, e.g.:
from django.db import migrations
class Migration(migrations.Migration):
dependencies = []
operations = [
migrations.RunSQL(
"""
ALTER TABLE items
ENABLE ELECTRIC;
"""
)
]
end
end
Event sourcing
One way of consuming a change feed from Postgres in Python is to use the psycopg2.extras.LogicalReplicationConnection.
See Integrations -> Event sourcing for more information.