Technical notes on web development, DevOps, and AI integration.
1 article
Service types carry metadata ENUMs cannot: category bindings, active windows, stable codes.
TL;DR: Lookup tables beat ENUMs for service types since adding values needs a plain INSERT instead of a schema change. The design uses a nullable category_id with ON DELETE SET NULL so deleting a category never destroys rows. Go validates first, the FK backs it up, and INSERT ...