💾 Archived View for sdf.org › rsdoiel › series › sql-reflections.gmi captured on 2024-05-12 at 15:13:55. Gemini links have been rewritten to link to archived content

View Raw

More Information

⬅️ Previous capture (2024-02-05)

-=-=-=-=-=-=-

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[1], notes on migration schema in SQLite 3

2. Rosette[2], notes on moving from MySQL 8 to Postgres 14.5 in a project

3. PL/pgSQL, a Quick Intro[3], notes on starting to write functions and procedures in Postgres 14.5

4. Postgres 14 on Ubuntu 22.04 LTS[4], quick distillation of setting up Postgres 14 on Ubuntu 22.04 LTS

5. Postgres Quick Notes, take two[5], Revised notes on setting up my Postgres instances with macOS extras

6. Installing pgloader from source[6], quick notes on compile pgloader on my M1 Mac Mini, macOS Sonoma 14.3

1: /blog/2021/04/16/Updating-Schema-in-SQLite3.gmi

2: /blog/2022/08/19/rosette-notes.gmi

3: /blog/2022/08/24/plpgsql-quick-intro.gmi

4: /blog/2022/08/26/postgres-14-on-ubuntu-22.04-LTS.gmi

5: /blog/2023/11/17/PostgreSQL-Quick-Notes.gmi

6: /blog/2024/02/01/installing-pgloader-from-source.gmi