enterprise-infrastructure

Scaling from SQLite to multi-worker requires a progressive infrastructure model driven by environment configuration and a StoreFactory that bootstraps Level 0 through Level 2 deployments while sharing database and queue backends across workers.

A StoreFactory centralizes resource initialization across stores, enabling dialect-portable SQL compatibility and consistent lifecycle governance from in-process Level 0 up to multi-worker Level 2 environments.

Idempotency for distributed task queues uses SQL-backed task queues combined with a worker registry, ensuring reliable distributed processing without duplicate execution across multi-worker deployments.

Configuring multi-worker backends requires setting KAILASH_DATABASE_URL and optional KAILASH_QUEUE_URL environment variables before initializing the StoreFactory to bootstrap the correct infrastructure level.

Maintaining dialect-portable SQL across backends is handled through a StoreFactory-backed lifecycle that abstracts database-specific syntax, enabling cross-database compatibility from SQLite to shared multi-worker database architectures.

Staying on SQLite is appropriate for Level 0 in-process environments where single-process operation suffices, avoiding the overhead of worker registries and SQL-backed task queues until scaling demands require Level 2 backends.