A Node.js service was writing UTC timestamps to a PostgreSQL database configured for Europe/Berlin. Nobody noticed the mismatch until a DST transition made an entire hour of orders vanish from daily reports.
- Published On
postgresql
Tags
consulting (25)developer-experience (13)architecture (8)debugging (4)reliability (4)code-quality (4)ai (4)performance (3)microservices (3)testing (3)observability (3)engineering-culture (3)database (2)technical-debt (2)productivity (2)ci-cd (2)devops (2)tooling (2)javascript (2)postgres (2)goals (2)postgresql (1)orm (1)refactoring (1)on-call (1)alerting (1)incident-management (1)typescript (1)kubernetes (1)distributed-systems (1)caching (1)platform-engineering (1)security (1)dependencies (1)deployment (1)code-review (1)feature-flags (1)api (1)contracts (1)logging (1)mongodb (1)migration (1)workflow (1)nestjs (1)angular (1)sandbox (1)sonarcube (1)learning (1)journey (1)mdx (1)