{"schemaVersion":1,"id":"cloudflare-do-sqlite","revision":"2026-09-14.1","name":"Durable Objects + SQLite","monogram":"DO","category":"Composition","openness":"Not established","license":"Hosted runtime; SQLite engine is public domain","color":"#64cdb5","summary":"Per-object SQL storage colocated with application logic.","website":"https://developers.cloudflare.com/durable-objects/best-practices/access-durable-objects-storage/","repository":"","environment":"Cloud runtime","contributor":"Testedknowhow database research","affiliation":"Commissioned by a Nimbalyst maintainer. Documentation synthesis; no independent review or product execution.","contentLicense":"Unlicensed prototype; redistribution decision pending","reviewStatus":"unreviewed","lastChecked":"2026-09-14","expiresAt":"2026-10-14","applicability":{"versions":["Unpinned upstream documentation accessed 2026-09-14; pin engine, extension and service versions before use."],"environment":"Each object owns private storage. Application implements Worker routing and cross-object coordination.","excludes":["Runtime verification","Workload benchmarks and cost comparisons","Unlisted extensions, service tiers and deployment configurations"]},"database":{"models":["Relational"],"deployment":"Cloud runtime","kind":"Composition","components":["sqlite"],"boundary":"Each object owns private storage. Application implements Worker routing and cross-object coordination.","evidenceIds":["cloudflare-do-sqlite-s0"]},"claims":[{"id":"cloudflare-do-sqlite-db-sql","capability":"db-sql","statement":"Queries tables through the object SQL API.","method":"documented","outcome":"claimed","scope":"Documented for this target; no runtime tests recorded.","evidenceIds":["cloudflare-do-sqlite-s0"],"contradictions":[],"support":"yes"},{"id":"cloudflare-do-sqlite-db-transactions","capability":"db-transactions","statement":"Provides transactional storage within one object.","method":"documented","outcome":"claimed","scope":"No cross-object transaction guarantee is claimed.","evidenceIds":["cloudflare-do-sqlite-s0"],"contradictions":[],"support":"yes"},{"id":"cloudflare-do-sqlite-db-pitr","capability":"db-pitr","statement":"Provides point-in-time recovery for SQLite-backed object storage.","method":"documented","outcome":"claimed","scope":"Documented for this target; no runtime tests recorded.","evidenceIds":["cloudflare-do-sqlite-s0"],"contradictions":[],"support":"yes"},{"id":"cloudflare-do-sqlite-db-colocated","capability":"db-colocated","statement":"Runs object code beside its attached SQLite storage.","method":"documented","outcome":"claimed","scope":"Documented for this target; no runtime tests recorded.","evidenceIds":["cloudflare-do-sqlite-s0"],"contradictions":[],"support":"yes"},{"id":"cloudflare-do-sqlite-db-managed","capability":"db-managed","statement":"Cloudflare hosts compute and storage.","method":"documented","outcome":"claimed","scope":"Application must implement routing, object logic and additional database tooling.","evidenceIds":["cloudflare-do-sqlite-s0"],"contradictions":[],"support":"partial"}],"evidence":[{"id":"cloudflare-do-sqlite-s0","url":"https://developers.cloudflare.com/durable-objects/best-practices/access-durable-objects-storage/","title":"Durable Objects storage","locator":"Access storage; SQL in Durable Objects vs D1","capturedAt":"2026-09-14","kind":"vendor-documentation","revision":null,"redistribution":"Link and original paraphrase only; upstream rights retained."}],"gaps":["Which pinned versions, topology and service tier fit the intended workload?","What are measured correctness, latency, recovery and total operating cost under that workload?"],"invalidationTriggers":["Upstream version, license, API, service plan or storage topology changes."],"verificationPlan":["Pin the target configuration and define workload fixtures, access and budget.","With authorization, test concurrent writes and recovery against explicit correctness expectations.","For vector workloads, measure filtered recall against an exact-search baseline and record index settings."],"attestations":[]}