2 years ago
context in this discord thread.
I just created a thread in the discord then saw that we have a new community forum; figured I would move the discussion here instead.
Hey all, I noticed a small (but breaking in a few of my apps) change between the legacy databases and the new service based databases created by the migration tool. Specifically in the "protocol" portion of the DATABASE_URL .
The issue
It seems in the legacy databases, the DATABASE_URL variable started with postgresql://... while the new service databases default to postgres:// for the "protocol" piece of the connection string.
In particular this broke my Python-based flask apps that
used PostgreSQL for a database
used SQLAlchemy as an ORM
What I did to fix it
Compared the two variables in vscode
Noticed the legacy started with
postgresqland new database started withpostgresChanged the variable back to the
postgresqlformat in my new database serviceRestarted all services that relied on that variable.
What I expected to happen
Ideally, I would hope the migration tool would match whatever format/syntax your project is using for variables in the legacy database/plugin.
0 Replies