Export a Report Through One Cursor
Separate all-rows XLSX export from page queries: consume one result cursor, preserve permissions and cell conversion, stage the file, and verify failure cleanup.
LOGBlog
Engineering Notes
Database-backed investigations, migration lessons, production recovery, and practical AI-assisted engineering.
Page 1 / 9
Add Event Detail Without Inventing History
Evolve aggregate-only counters into an event log by writing details and totals atomically, preserving irreducible legacy summaries, and using stable cursor pagination.
Keep Batch Deletes Inside the Persistence Boundary
Repair a batch deletion path that depended on a read projection by loading persistence models directly, validating the full batch, and returning the real transaction result.
Fixing Today-Only Metrics with Explicit Day Boundaries
Repair a metric labelled today that included the previous day by defining one local-day interval, isolating headline parameters, and reconciling the total with its detail population.
Deriving Workflow Status from Real Transition Evidence
Repair a workflow report that advances too early by filtering invalid events, normalizing legacy stages, recovering from business evidence, and recording milestones only when transitions occur.
Designing Rerunnable Oracle Schema Synchronization with Wrong-Target Guards
Turn an Oracle change list into a fail-closed synchronization program with target identity checks, full preflight validation, conditional DDL, business-key MERGE, and repeat-run proof.