DEV Community

Mike Faraponov for ScaleChamp

Posted on • Updated on

Connect to ScaleChamp Managed PostgreSQL with SQLAlchemy

Create database instance in Control Panel:

  1. Select service, cloud, region:
    Alt Text

  2. Select plan:
    Alt Text

  3. Wait until instance will be in RUNNING state:
    Alt Text

  4. Then connect to it from your python application:

from sqlalchemy import create_engine

conn_args = {
    "sslmode": "verify-full",
    "sslrootcert": "<path to your ca.pem downloaded from UI>",
}

engine = create_engine("postgresql://<user>:<password>@<hostname>:5432/ssndb", connect_args=conn_args)

conn = engine.connect()
Enter fullscreen mode Exit fullscreen mode

To make sure no one can gain access to your database accept allowlisted IPs checkout firewalls section.
Voa'la. See you at ScaleChamp

Discussion (0)