Skip to content

Latest commit

 

History

History
29 lines (15 loc) · 627 Bytes

File metadata and controls

29 lines (15 loc) · 627 Bytes

Week 4 — Postgres and RDS

Class Summary

Provision an RDS instance

Temporarily stop an RDS instance

Remotely connect to RDS instance

Programmatically update a security group rule

Write several bash scripts for database operations

Operate common SQL commands

Create a schema SQL file by hand

Work with UUIDs and PSQL extensions

Implement a postgres client for python using a connection pool

Troubleshoot common SQL errors

Implement a Lambda that runs in a VPC and commits code to RDS

Work with PSQL json functions to directly return json from the database

Correctly sanitize parameters passed to SQL to execute