Skip to content

Latest commit

 

History

History
97 lines (64 loc) · 2.64 KB

File metadata and controls

97 lines (64 loc) · 2.64 KB

Week 4 — Postgres and RDS

Postgres

Check local postgres connection and create cruddur db

Check db list

Check database list

Check db list

Add connection url env

Add connection env Add connection env 1

Check connection using env

Check connect with env

Add schema sql script

Add schema db

Add db seed script

Add db seed

Add db script

Add setup script

Add setup script

Add sessions script

Add sessions script

Add seed script

Add seed script

Add schema load script

Add schema load script

Add drop db script

Add drop db script

Add create db script

Add create db script

Add connect script

Add connect script

Check db script

Run create db

Run create db

Run db schema

Run db schema

Run db seed

Run db seed

Check record in table

Check record in table

Run drop db

Run drop db

Add package to requirements.txt

Add pkg for pycopg

Install requirements

Install requirements

Add connection url env to docker compose

Add connection url to docker compose

Add db lib to connect db in backend code

Add db lib

Get data from db for home activities

Update home activities

Check if data fetched from db by logging it

Logging json data from db

RDS

Create RDS db using AWS CLI

Create db using rds

Result from AWS CLI

Create db using rds result

Check in the RDS dashboard

RDS dasboard

Lambda

Lambda that created from console can be seen below here

Code can check here