Flask Tutorial - 3. Setting up Flask with SQLAlchemy & PostgreSQL

📣 Other Social:

[DimoDimov]

Thanks @Chris! Thank you for creating something a bit more in depth and showcasing how it works (y)

[yusafosei-bonsu]

Great video! I was literally struggling so much on how to connect Flask with Postgres, but you made it so simple!

[univuniveral]

Good job. Please can you tell me if this flaskalchemy-posgresql can be deployed to the public web space.

[hemanthr]

i like the instructor saying jackass to people who repeatedly registers lol :P

[aryashree]

Hey Chris I want to screate a Schema for Postgres Table. So that, from Python I can use that schema to create any table and with any number of Columns/ with varying cloumn names.

[hamzamir]

you are lit! cured my headache. many thanks!!

[vijeandran]

HI, Instead of getting all the columns in GET request, How could I get only specific columns from the postgres table?

[Sree-qrib]

If anyone using mac, and gets psycopg2 installation error, use following commands (atleast these worked for me) 1. brew install postgresql 2. pip install psycopg2 I'm using Pgadmin, "brew install" only solved the problem

[bidhanmondal]

Hey chris, can you say about password adding with hashing using sqlalchemy to users table? bec for login and registration users need to provide that? but here you havent done or saving any password. can you provide some infromation for that?

[davidrodgers]

Hi Chris,

Im new to Postgres. I installed pgAmin 3 and when I try to connect to the localhost through the 'New Server Registration" it tells me "Server doesn't listen" I put my host as localhost and username as postgres. Any idea what I am doing wrong here?

Thanks,

David

[chamikey]

If you get the db doesn't exist error, you might have to specify the port. For example, mine is 5433, so I put localhost:5433 in


You can find the port number by right clicking on the postgresql server, going to properties, and it's on the connection tab

[cynthias.]

Hi Chris,
I'm using PyCharm and connected it to my postgresql server, but when I try to db.create_all() in the Python console and view database, there is no new database in flaskmovie. I didn't get an error in the console. Any idea what I did wrong?

[lindembergbarbosa]

awesome, thaks for your help. please create a tutorial with flask migrate too.

[blacksailorx]

Please make a video on SQLalchemy cascade 'delete' and 'update'.

[imransaid]

Hi Chris, when I try db.create_all() I keep getting the following runtime error: application not bound on db instance and no applicationbound to current context...all the stackoverflow discussions on the issue don't seem to provide the precise correct answer. Any idea how I could solve this?

[MickeyMouse-kejb]

do you simply replace 'localhost' with your custom domain name if you have one?

[jordanrob]

hey, im encountering errors importing db from app . i get feedback that db doesn't exist . if i type db or any other variable in the app.py file im told its not defined any solutions? im really stuck

[stanleylafond]

Chris, You never explained why you used an __init__ method. That part of your User class was not included in the Flask documentation.

[drnnokc]

When launching db.create_all() it seem to be working, since i don't get any error but there is no table created. Can you please help me?

-postgresSQL 9.6.5
-python 3.6.2
-Flask==0.12.2
-Flask-SQLAlchemy==2.3.1

[ZennerBear]

When I try to db.create_all() I'm getting an operational error from psycopg2 stating that my database (wich i created in postgres) does not exist. Any fixes to this?