Home/ Questions/Error: Can't load plugin sqlalchemy dialects postgres – quick tips.
Next
Answered
Michael White
  • 10
Asked: 2022-05-18T18:39:02+00:00 In:

Error: Can’t load plugin sqlalchemy dialects postgres – quick tips.

  • 10

. Advertisement .

..3..

. Advertisement .

..4..

Hi developer experts, I have a small but frustrating use case, and so far, I couldn’t get my head around this problem & ideal solution. I am running my command and facing one problem with the can’t load plugin sqlalchemy dialects postgres. Below is the command I used:

from flask import Flask
 from flask_sqlalchemy import SQLAlchemy
 
 app = Flask(__name__)
 app.config["SQLALCHEMY_DATABASE_URI"] = "postgres://[email protected]:5432/template1"
 
 db = SQLAlchemy(app)

When I run it, I get the following error:

sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:postgres

I am looking forward to gaining some knowledge from all experts. Thank you, guys!

postgresql
Share

2 Answers

  1. Best Answer
    Expert

    The cause:

    This error happened because when working with Heroku, you used postgres in the DATABASE_URL which they gave, but SQLAlchemy 1.4 deleted the required postgres dialect name.

    Solution:

    To solve this error, you have to replace postgres:// by postgresql:// in the URL and change the variable in the Heroku dashboard to postgresql.

    The part before the :// in the URL is dialect. SQLAlchemy 1.3 earlier gave a deprecation warning but it was still accepted.

    Another way to fix this error is using python url to replace code in heroku as below:

    import os
import re

uri = os.getenv("DATABASE_URL") # or any other related configuration variable
if uri and uri.startswith("postgres://"):
uri = uri.replace("postgres://", "postgresql://", 1)
# using the connection string 'uri' for the rest of the connection code

    Let’s read this article to have more information:  https://help.heroku.com/ZKNTJQSK/why-is-sqlalchemy-1-4-x-not-connecting-to-heroku-postgres

    • 0

  2. postgresql:// should be used as the URI instead of postgres://. SQLAlchemy used both but no longer accepts postgres.

    • 23

Leave an answer

You must login to add an answer.

Need An Account,