DEV Community

loading...
ScaleChamp

Connect to ScaleChamp Managed PostgreSQL with SQLAlchemy

spacenomad profile image Mike Faraponov Updated on ・1 min read

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)

Forem Open with the Forem app