Postgre: Can't load plugin

Code Help Python
1

Question:
Hi I am trying to set up postgre in my replit instance. I keep getting errors (below) and i can’t figure out what the problem is.

Repl link:
https://replit.com/@dand31/BannerAppDev

Traceback (most recent call last):
  File "main.py", line 17, in <module>
    db = SQLAlchemy(app)
  File "/home/runner/BannerAppDev/venv/lib/python3.10/site-packages/flask_sqlalchemy/extension.py", line 221, in __init__
    self.init_app(app)
  File "/home/runner/BannerAppDev/venv/lib/python3.10/site-packages/flask_sqlalchemy/extension.py", line 329, in init_app
    engines[key] = self._make_engine(key, options, app)
  File "/home/runner/BannerAppDev/venv/lib/python3.10/site-packages/flask_sqlalchemy/extension.py", line 617, in _make_engine
    return sa.engine_from_config(options, prefix="")
  File "/home/runner/BannerAppDev/venv/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 803, in engine_from_config
    return create_engine(url, **options)
  File "<string>", line 2, in create_engine
  File "/home/runner/BannerAppDev/venv/lib/python3.10/site-packages/sqlalchemy/util/deprecations.py", line 281, in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]
  File "/home/runner/BannerAppDev/venv/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 552, in create_engine
    entrypoint = u._get_entrypoint()
  File "/home/runner/BannerAppDev/venv/lib/python3.10/site-packages/sqlalchemy/engine/url.py", line 754, in _get_entrypoint
    cls = registry.load(name)
  File "/home/runner/BannerAppDev/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 368, in load
    raise exc.NoSuchModuleError(
sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:postgres
1 Like
2

Did you pip install the correct packages?

3

You have to use postgresql:// URL instead of postgres:// now

Looks like your repl is private. If you still need help, please link a minimal repl which reproduces the issue

2 Likes