Connecting Python to a Heroku PostgreSQL DB?

Question

I am exploring various features of the Python language. I have created a Postgres db on Heroku, am am looking to connect to it. I have the host, database user, port and password settings. I am not looking to deploy to Heroku, just connect locally to this db. Where can I get started?

freezed · Accepted Answer · 2018-10-12 09:15:30Z

10

From Heroku Postgres doc, with psycopg2 :

To use PostgreSQL as your database in Python applications you will need to use the psycopg2 package.
pip install psycopg2-binary
And use this package to connect to DATABASE_URL in your code.
import os
import psycopg2

DATABASE_URL = os.environ['DATABASE_URL']

conn = psycopg2.connect(DATABASE_URL, sslmode='require')

answered Oct 12, 2018 at 9:15

freezed

1,3491 gold badge18 silver badges40 bronze badges

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

Comments

Petter Engström · Accepted Answer · 2013-10-01 06:46:22Z

1

I don't know anything about Heroku, but maybe psycopg is what you're looking for?

answered Oct 1, 2013 at 6:46

Petter Engström

1,1098 silver badges5 bronze badges

Collectives™ on Stack Overflow

Connecting Python to a Heroku PostgreSQL DB?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related