Migrating n8n from SQLite to PostgreSQL

What The n8n instance on our production server stopped processing work. One workflow, a telemetry collector that receives a stream of concurrent webhook calls, had overloaded the database and taken the whole instance down with it. The numbers when we looked: 300+ executions stuck in running state 346 executions in new state that never started 161 executions failed with LockAcquireTimeoutError The UI was slow enough to be unusable The error behind all of it: ...

June 8, 2026 · 5 min · 985 words · Sagar Nayak

ESP32 WiFi Ping Server for On-Prem Power Monitoring

What A minimal ESP32 web server that responds with OK when pinged. Used to detect on-prem power/network status in cloud-failover architectures. The typical setup: an on-prem server with a cloud standby. A Lambda or cron job pings the ESP32 every 30 seconds. Three consecutive failures trigger failover. When it responds again, on-prem is back. The server runs on the ESP32 over WiFi using ESP-IDF’s HTTP server component on port 80. If ESP-IDF is not yet installed on your machine, start with ESP32 Development Setup on Ubuntu. ...

November 22, 2025 · 7 min · 1282 words · Sagar Nayak