Librarium
Settings

Dash CRUD App with PostgreSQL - Part 2

Charming Data
blockchainbuild deploy python web app flask postgres herokudashdash plotly tutorialdash plotydata visualization pythondeploy a flask app to heroku with postgresqldeploy to herokuflaskherokuheroku postgreshow to add a postgres database on herokulearn how to use postgresql in this full courselearn postgresql tutorialpgadminplotlypostgresqlpostgresql tutorialpython dashpython flaskpython postgresqlpython web appsqlalchemysqlalchemy flask

In part 2 of Dash tutorial, we'll connect our CRUD App to PostgreSQL databases: one on our computer, and one online via Heroku. The database on the computer will allow you to test your database connection before deploying it to the web. The database on Heroku will allow others to use your dashboard app and save changes to the live.

Set-up-PostgreSQL Guide: https://drive.google.com/file/d/1nhqTKTF_8SwTV7iCuGXnOdIw3QOVWH8O/view?usp=sharing

Code: https://github.com/Coding-with-Adam/Dash-by-Plotly/blob/master/Dash_More_Advanced_Shit/CRUD_app/crud_dash_postgresql.py

CSV initial Data: https://drive.google.com/file/d/1qdhk81kyFZgbxex__r8MdGwe6zd2ypBr/view?usp=sharing

Necessary App Libraries: https://drive.google.com/file/d/1plTRwziSEY_vJ6k0BFVgHVO9A4TuxWpu/view?usp=sharing

SQLAlchemy: https://towardsdatascience.com/sqlalchemy-python-tutorial-79a577141a91

More on usage of SQLAlchemy with PostgreSQL: https://www.youtube.com/watch?v=w25ea_I89iM

Video layout: 00:00 - What to expect 03:16 - Dash App connection to PostgreSQL Database on Computer - Section 1 12:15 - Dash App connection to PostgreSQL Database Online (Heroku) - Section 2 28:48 - Review Dash App Code - Section 3 ... https://www.youtube.com/watch?v=Mf3s0P4aVKw

2021-01-18
0.0 LBC
Copyrighted (contact publisher)

195716571 Bytes