Melih
How do I run database migrations safely in CI/CD?
Add the column nullable, move the backfill to a separate throttled step, run migrations in their own stage, and drop the old column in a later release.
Just Ask
Questions and answers on software architecture, PHP, Go and careers
Ask me anything about software architecture, careers, PHP, Go and the craft of building software; I answer here, in the open, for everyone. (Page 4/8)
Ask a question
Whatever's on your mind, don't hold back. Questions reach me directly; I answer the good ones and publish them on this page. Your email is never published.
Answered questions
Doruk
How do I set up secretless AWS access in CI/CD with OIDC and IAM roles?
Delete the long-lived AWS keys from GitHub Secrets and assume a repo/branch-scoped IAM role over OIDC; pull non-cloud secrets from a manager at runtime.
Korhan
How do I shrink Docker images with multi-stage builds and distroless?
Leave the build tools in the builder stage: make the final stage distroless/static or scratch for Go and fpm-alpine for PHP, and run as non-root.
Nadir
How do I safely manage Terraform state with S3 + DynamoDB locking?
Move state to a versioned, encrypted S3 backend and add a DynamoDB lock table (deprecated but working), keep state per environment, and apply only from CI.
Şükrü
How do I stop OPcache from causing 500s during a zero-downtime DeployerPHP deploy?
After flipping the symlink, gracefully reload PHP-FPM rather than restarting it; on Octane, octane:reload is mandatory and opcache_reset is optional.
Uğur
Time-series data: TimescaleDB or InfluxDB?
100M rows a day breaks a plain table, so chunk it by time with hypertables, materialize the averages as continuous aggregates, and compress the old chunks.
Taylan
How do I coordinate a zero-loss schema migration with dual-writing on a live table?
Instead of a blocking `ALTER TABLE` on 20M rows run expand/contract: add nullable columns, dual-write, backfill in throttled batches, then drop the old.
Sarp
Why should I use a Sorted Set for a live leaderboard in Redis?
Use a Sorted Set instead of plain string keys sorted in the app, since `ZADD` updates in O(log N) and `ZREVRANGE 0 99` returns the top 100 already ordered.
Rüzgar
When should I apply CQRS, and how do I sync the read and write models?
Move reporting to a read replica and adopt CQRS only when query shapes outgrow one schema, feeding the read model from outbox events, not dual-writes.
Halil
Should I choose NoSQL or PostgreSQL for flexible product attributes?
Keep products, prices and orders in PostgreSQL and put the variable attributes in one GIN-indexed `JSONB` column; reporting alone rules out splitting.