Full-stack development
5 posts
Cross-Table Search and Pagination: A FastAPI + PostgreSQL Query Refactor
Search identifiers, part numbers, and uploaded filenames with correlated EXISTS, while defining the order of filtering, stable sorting, and pagination.
Configuration Mapping and Data Synchronization: Boundaries for Dynamic Business Fields
How do parsed fields enter business records? Explore source priorities, missing-value semantics, creation-time mapping, and the relationship between configuration changes and human-confirmed data.
React Disclosure Interactions: Smooth Motion, Rapid Reversal, and Accessibility
Build collapsible regions with CSS Grid and retained DOM, handle rapid reversals, focus, inert, and reduced-motion preferences, and separate component tests from browser acceptance checks.
From Business Data to Excel: Implementing and Validating Template Exports
Why can two new columns affect an entire report? Build an XLSX validation path through data mapping, merged headers, print ranges, and formula caches.
Releasing a Static Site: Artifact Validation, Atomic Switching, and Failure Recovery
Using an Astro blog, connect checked artifacts, commit versions, live health checks, and failure recovery while keeping an explicit release cadence.