PostgreSQL Savepoints: Partial Recovery in a Transaction
Use PostgreSQL savepoints with explicit partial-failure rules, rollback boundaries, correct release behavior, driver checks, and external side-effect limits.
Hackbitez journal
Category: Software
Software guides for Python, Git, PostgreSQL, Docker, and Kubernetes. Understand configuration, data boundaries, testing, troubleshooting, and recovery.
PostgreSQL Materialized Views: Refresh and Freshness
Plan PostgreSQL materialized views with a clear freshness contract, compatible refresh mode, unique-index requirements, safe scheduling, and result validation.
PostgreSQL Serializable: Retry the Complete Decision
Use PostgreSQL Serializable with whole-transaction retries, fresh decisions, bounded attempts, protected external effects, and realistic concurrent tests.
Kubernetes Resource Quotas: Admission and Team Budgets
Plan Kubernetes resource quotas with namespace budgets, LimitRange defaults, rollout headroom, object limits, admission checks, and capacity-aware monitoring.
Kubernetes Init Containers: Repeatable Startup Work
Design Kubernetes init containers with repeatable setup, narrow mounts and credentials, bounded dependency waits, resource planning, and failed-start tests.
Python Dataclasses: Defaults, Identity and Validation
Use Python dataclasses with safe mutable defaults, deliberate equality, explicit validation, careful serialization, and tested frozen-object limits.
Python Context Managers: Resource Ownership and Cleanup
Design Python context managers with explicit resource ownership, reliable cleanup, exception behavior, ExitStack composition, and failure-path tests.
Git Cherry-Pick: Move Changes Without Losing Context
Use Git cherry-pick with reviewed commit dependencies, clean worktrees, careful conflicts, traceable backports, tests, and deliberate shared-history decisions.
Git LFS: Pointer Files, Artifact Access and Recovery
Plan Git LFS with committed attributes, pointer-aware checkout, artifact access, CI verification, quota review, and complete backup and migration checks.
PostgreSQL UPSERT: Conflicts, Keys and Update Meaning
Design PostgreSQL UPSERT with correct conflict keys, explicit update rules, batch deduplication, authorization, concurrency tests, and useful result handling.