A backend for AI-coded apps

Instant 1.0 is a backend-as-a-service designed for AI-coded apps, offering unlimited non-frozen projects via multi-tenancy, a built-in sync engine for real-time/offline/optimistic updates, and integrated services (auth, file storage, presence, streams). The architecture uses a client-side triple store with Datalog for offline queries, a Clojure backend with a WAL-based invalidator and grouped queues for reactive multi-tenant queries, and a single Postgres triples table (EAV pattern) augmented with count-min sketches for query planning. The post covers design tradeoffs including why SQLite was rejected for the client, how partial indexes handle schema constraints, and how Clojure's concurrency primitives enabled the grouped queue abstraction.