(an idea I had, intended for JS fullstack/backend frameworks, worked out together with AI, stored here for future reference)
We are building an application on serverless edge infrastructure (Cloudflare Workers, Durable Objects, SQLite, and Drizzle ORM), with a hard requirement that the codebase must remain portable to a self-hosted Node.js server (using SQLite or PostgreSQL) without rewriting application logic. Like Rails' Solid Queue, our background job system needs to:
- Live inside our primary SQL database (no Redis or separate message brokers).