Posts

All the articles I've posted.

• OAuth Callbacks and Hash Routing: Why Can't the Router Read the Parameters?

  10 Oct, 2026

  Distinguish OAuth callback queries from Vue hash-route parameters using example URLs, and examine initialization order, ordinary callback endpoints, and the boundaries of authorization-code and state handling.

• Why Do PostgreSQL Auto-Generated IDs Conflict After a Data Import?

  10 Oct, 2026

  Explain sequence drift after importing explicit IDs, compare ALTER SEQUENCE RESTART with setval, and cover empty tables, concurrency, and rollback.

• Why Do Three Consecutive setState Calls Only Increment Once?

  10 Oct, 2026

  A counter example explains React state snapshots, update queues, batching, and why functional updates can accumulate three increments.

• Time in Task Systems: Instants, Local Time, and All-Day Tasks

  10 Oct, 2026

  Distinguish instants, local clock time, and all-day dates when designing task storage, time-zone handling, calendar queries, and reminders.