10/ 11·5 lessons·2 h

Writes

Advanced writes and database-side logic: MERGE and COPY, a job queue via SKIP LOCKED, the transactional outbox, LISTEN/NOTIFY, triggers and function volatility (IMMUTABLE/STABLE/ VOLATILE) — with an explicit "when NOT to put logic in the database" section.

/ lessons

Lessons

5 lessons · 2 h
  1. 01MERGE and COPY↳ continue from here#merge#copy#bulk-load25m
  2. 02A job queue on SKIP LOCKED↳ continue from here#skip-locked#job-queue#concurrency25m
  3. 03Transactional outbox↳ continue from here#outbox#events#cdc25m
  4. 04LISTEN / NOTIFY↳ continue from here#listen-notify#pg-notify#triggers20m
  5. 05Triggers and function volatility↳ continue from here#triggers#volatility#plpgsql25m