Скачать или смотреть Week 38 | Debugging Cron Jobs and Email Queues

The email outbox is working, the drainer function works perfectly when manually triggered, but the cron job automation isn't firing. This week: debugging pg_cron, exploring alternatives like Cloudflare Durable Objects, and squashing UI state management bugs in the guest list details pane.

📱 *Shokken App Progress:*
✅ Email outbox table implemented
✅ App successfully queues emails
✅ Manual drainer function working
🔄 Debugging cron job automation
🔄 UI bug fixes in guest list

🤖 *Blog Post:* https://endian.dev/blog/2025/38/

Chapters
0:00 Week 38 Introduction
0:01 Email outbox table setup complete
0:12 Guest notification flow working
0:28 Outbox doesn't process directly
0:42 Infrastructure efficiency explained
0:57 Cron job frequency (60 seconds)
1:09 Future considerations for timing
1:27 Cloudflare Durable Objects mentioned
1:55 Current status: manual works, auto doesn't
2:10 Cron job debugging needed
2:36 UI bug fixes in guest list
3:03 State reflection issues fixed
3:13 Next week's goals
3:29 Fix cron job priority
3:43 Verify edge function automation
3:50 UI bug squashing plans
4:14 User experience importance
4:46 Polish before launch

Key Topics Covered
pg_cron debugging strategies
Alternative cron implementations
Database queue optimization
Email drainer architecture
UI state management fixes
Error handling improvements
Testing strategies
Performance monitoring

Technical Highlights
**Problem**: pg_cron not triggering Edge Function calls
**Manual Success**: Drainer works perfectly when invoked directly
**60-Second Limit**: Minimum cron interval in Supabase
**Alternative**: Cloudflare Durable Objects for 10-second intervals
**UI Fixes**: State immutability issues in guest list

Implementation Details
Advisory locking for concurrent processing
Database triggers as cron alternatives
External cron services (Cloudflare Workers)
Partitioned tables for queue scaling
Comprehensive error recovery
Monitoring and alerting setup

Resources
📝 Blog: https://endian.dev
🐙 GitHub: https://github.com/endian-dev
📱 Shokken App: Coming to Google Play & App Store

About Shokken
Shokken is a modern waitlist management app replacing traditional buzzer systems with smart notifications. Built with Kotlin Multiplatform, targeting Android, iOS, Web, and Desktop platforms.

#Programming #CronJobs #EmailQueues #Debugging #Supabase #PostgreSQL #EdgeFunctions #KotlinMultiplatform #UIStateManagement #SystemReliability #BackendDevelopment #StartupDevelopment