Durable Workflows Can Be Built on `SQLite` Alone

// related

• #0001

  #0001Infra & SaaSGeekNews6 hours ago

  `Shopify` Replaces Redis Inventory Reservations With MySQL

  50radar

  ShopifyE-commerce SaaS — unified checkout and store ops

  Oversell prevention moved from cache-style reservations to transactional rows using SKIP LOCKED. Worth copying only when checkout correctness beats simple counter performance.

  • —MySQL 8 SKIP LOCKED lets workers claim available reservation rows without blocking the whole queue; useful for high-contention checkout paths.
  • —The redesign uses one row per sellable unit, not a quantity column. It trades table size for clearer locking and recovery semantics.
  • —The pattern fits limited-stock sales, tickets, and booking flows. For tiny catalogs, a simpler counter plus idempotent order checks is enough.

  Source: news.hada.io/topic?id=30006Read original →
• #0002

  #0002Infra & SaaSGeekNews6 hours ago

  How Container Registries Work: Push/Pull Images Directly

  40radar

  Registry bugs often hide below the docker push surface. Understanding blobs, tags, manifests, and platform metadata helps debug broken deploys faster.

  • —A registry is a content-addressable blob store; layers are referenced by digest, so missing blobs break pulls even when tags look valid.
  • —Tags are mutable pointers, not versions. Pinning image digests is safer for Vercel-style build pipelines and reproducible deploys.
  • —Platform mismatches come from manifest metadata. Multi-arch images need explicit checks before shipping ARM/local builds to x86 servers.

  Source: news.hada.io/topic?id=30004Read original →
• #0003

  #0003Infra & SaaSGeekNews7 hours ago

  Building Durable Workflows on `Postgres`

  50radar

  Checkpointing state in the database lets jobs resume after crashes. It cuts orchestration overhead when a small product already runs on Postgres, but complex branching still needs care.

  • —Durable workflows persist completed steps as checkpoints, so a crash restarts from the last finished step instead of rerunning everything.
  • —External orchestrators like Temporal, Airflow, and AWS Step Functions add a central coordinator plus storage; that raises operational weight.
  • —A Postgres-based design fits small SaaS backends already using the DB, especially for billing, emails, imports, and LLM batch jobs.

  Source: news.hada.io/topic?id=29999Read original →