Error connecting to database with SQLAlchemy and fastAPI

Question

I have this setting on a fastAPI small application:

host_server = os.environ.get('host_server', 'localhost')
db_server_port = urllib.parse.quote_plus(str(os.environ.get('db_server_port', '5432')))
database_name = os.environ.get('database_name', 'mydatabasename123')
db_username = urllib.parse.quote_plus(str(os.environ.get('db_username', 'myusername123')))
db_password = urllib.parse.quote_plus(str(os.environ.get('db_password', 'mypassword123')))
ssl_mode = urllib.parse.quote_plus(str(os.environ.get('ssl_mode', 'prefer')))
DATABASE_URL = 'postgresql://{}:{}@{}:{}/{}?sslmode={}'.format(db_username, db_password, host_server, db_server_port,
                                                               database_name, ssl_mode)

database = databases.Database(DATABASE_URL)

locally it works, but when I try to deploy it to heroku, I change some things. I am use the DATABASE_URL env variable provided on Heroku:

DATABASE_URL = 'postgres://...'
database = databases.Database(DATABASE_URL)

or doing

DATABASE_URL = os.environ.get('DATABASE_URL')

database = databases.Database(DATABASE_URL)

metadata = sqlalchemy.MetaData()

engine = sqlalchemy.create_engine(
    DATABASE_URL, pool_size=3, max_overflow=0, echo=True
)

logs give me:

: at=error code=H10 desc="App crashed" method=GET path="/"

snakecharmerb · Accepted Answer · 2021-08-29 14:02:51Z

3

+200

"postgres" is no longer accepted as a dialect name in SQLAlchemy. The correct form is "postgresql", as you are using locally:

DATABASE_URL = 'postgresql://...'

Using 'postgres://...' raises

sqlalchemy.exc.ArgumentError: Could not parse rfc1738 URL from string 'postgres//...'

This change was introduced in SQLAlchemy 1.4.0b1

answered Aug 29, 2021 at 14:02

snakecharmerb

57.1k13 gold badges136 silver badges200 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error connecting to database with SQLAlchemy and fastAPI

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related