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
- 01MERGE and COPY↳ continue from here#merge#copy#bulk-load25m
- 02A job queue on SKIP LOCKED↳ continue from here#skip-locked#job-queue#concurrency25m
- 03Transactional outbox↳ continue from here#outbox#events#cdc25m
- 04LISTEN / NOTIFY↳ continue from here#listen-notify#pg-notify#triggers20m
- 05Triggers and function volatility↳ continue from here#triggers#volatility#plpgsql25m