Paragraph
- Presentations: Some basic commands, pg 5—12
- Checkpoint 11: Intro to Databases & Working with PostgreSQL
- Checkpoint 12: Intro to SQL
- gist:Command-line-postgres-express-notes.md
In these drills, you'll practice executing basic CRUD (create, read, update, delete) operations in the psql shell.
- CLI - good for
- low bandwidth environments (talking to cloud servers)
- very fast interactions for users that already know which command to use
- can use scripts and the alias command to create powerful custom commands
- GUI - good for
- exploring functionality & learning
- Seeing structure and organization - how things relate to each other
Certain versions of the pg library do not play nice with certain versions of node.
The following combinations are known to work:
- Node v12 and pg@7
- Node >=v14 and pg@8
Additionally, different versions of pg on heroku requires certain ssl options to be set certain ways.