pawelgrimm/pomi

Learn about PostgreSQL

Closed this issue · 2 comments

pawelgrimm commented

Acceptance criteria:

  • Learn enough about PostgreSQL to:
    • Create a table
    • Query the database
    • Schema change deployment
    • Update the database
pawelgrimm commented

Notes

Getting Started

Logrocket blog

Migrations

pg-migrator

PostgreSQL with Node.js: Migrations and schema dumps

ORM

Probably shouldn't use one, but maybe will use Knex as a query builder later

Why you should avoid ORM

pawelgrimm commented

As of commit 82b49d3, I've met the acceptance criteria, and also created indexes, a function, and triggers.