Drizzle

DR01 - Drizzle Setup

Skill Breakdown:

• installation
• schema declaration

Resources:

• Setup (opens in a new tab)

Optional Resources:

• https://orm.drizzle.team/docs/overview (opens in a new tab)
• https://orm.drizzle.team/docs/quick-postgresql/postgresjs (opens in a new tab)
• https://orm.drizzle.team/docs/sql-schema-declaration (opens in a new tab)
• https://orm.drizzle.team/kit-docs/overview (opens in a new tab)

DR02 - Drizzle Schema

Skill Breakdown:

• column types:
  • integers (smallint, int, bigint)
  • autoincrementing integers (smallserial, serial, bigserial)
  • boolean
  • strings (text, char, varchar)
  • floating-point numbers (real, double precision)
  • JSON data (json)
• constraints:
  • default
  • not null
  • unique
  • check
  • primary key
  • foreign key

Optional Resources:

• https://orm.drizzle.team/docs/sql-schema-declaration (opens in a new tab)
• https://orm.drizzle.team/docs/column-types/pg (opens in a new tab)
• https://orm.drizzle.team/docs/indexes-constraints (opens in a new tab)

DR03 - Drizzle Basic Queries

Skill Breakdown:

• operators
• CRUD queries
• raw queries

Resources:

• Inserting, Updating and Deleting Data (opens in a new tab)
• Selecting Data (opens in a new tab)

Optional Resources:

• https://orm.drizzle.team/docs/column-types/pg (opens in a new tab)
• https://orm.drizzle.team/docs/operators (opens in a new tab)
• https://orm.drizzle.team/docs/crud (opens in a new tab)
• https://orm.drizzle.team/docs/sql (opens in a new tab)

DR04 - Drizzle Multi-Table Queries

Skill Breakdown:

• multi-table queries

Resources:

• Multiple Tables (opens in a new tab)

Optional Resources:

• https://orm.drizzle.team/docs/rqb (opens in a new tab)
• https://orm.drizzle.team/docs/joins (opens in a new tab)

DR05 - Drizzle Migrations

Skill Breakdown:

• migrations

Resources:

• Migrations (opens in a new tab)