SQL Reflections

This series is a collection of reflections and notes as I work with MySQL 8, SQLite 3 and Postgres 14 in my day job.

  1. SQLite Schema, notes on migration schema in SQLite 3
  2. Rosette, notes on moving from MySQL 8 to Postgres 14.5 in a project
  3. PL/pgSQL, a Quick Intro, notes on starting to write functions and procedures in Postgres 14.5
  4. Postgres 14 on Ubuntu 22.04 LTS, quick distillation of setting up Postgres 14 on Ubuntu 22.04 LTS
  5. Postgres Quick Notes, take two, Revised notes on setting up my Postgres instances with macOS extras
  6. Installing pgloader from source, quick notes on compile pgloader on my M1 Mac Mini, macOS Sonoma 14.3