SQL Reflections

This series is a collection of reflections and notes as I work with MySQL 8, SQLite3 and PostgreSQL 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
  7. Rethinking REST, a discussion on taking advantage of modern SQL and SQLite3 to switch to a read write abstraction replacing the CRUD abstractions expressed in REST

Back