Durable Objects, Workers - SQLite in Durable Objects GA with 10GB storage per object
1y ago
Source
CloudflareDurable Objects, Workers - SQLite in Durable Objects GA with 10GB storage per objectcloudflare.comSQLite in Durable Objects is now generally available (GA) with 10GB SQLite database per Durable Object. Since the public beta in September 2024, we've added feature parity and robustness for the SQLite storage backend compared to the preexisting key-value (KV) storage backend for Durable Objects. SQLite-backed Durable Objects are recommended for all new Durable Object classes, using new_sqlite_classes Wrangler configuration . Only SQLite-backed Durable Objects have access to Storage API's SQL and point-in-time recovery methods, which provide relational data modeling, SQL querying, and better data management. export class MyDurableObject extends DurableObject { sql : SqlStorage constructor ( ctx : DurableObjectState , env : Env ) { super ( ctx , env ) ; this . sql = ctx . storage . sql ; } async sayHello () { let result = this . sql . exec ( "SELECT 'Hello, World!' AS greeting" ) . one () ; return result . greeting ; } } KV-backed Durable Objects remain for backwards compatibility, and a migration path from key-value storage to SQL storage for existing Durable Object classes will be offered in the future. For more details on SQLite storage, checkout Zero-latency SQLite storage in every Durable Object blog .
You might also wanna read
Implementing a Durable Execution Engine Using SQLite for Persistent Workflows
The article explores building a Durable Execution (DE) engine using SQLite, explaining how DE engines make multi-step workflows persistent a
Understanding SQLite's Durability Settings and Performance Trade-offs
The article examines SQLite's durability settings, highlighting the confusion and conflicting information in its documentation regarding whe
SQLite as a Viable Alternative for Durable Workflow Execution
The article argues that SQLite can replace complex orchestration systems for durable workflow execution in many cases. It builds on DBOS's a
obeli.sk·1mo ago
Exploring Persistence and Durability in Key-Value Databases
The article discusses the author's experience working on a key-value database, exploring different approaches for persistence and durability
SQLite is All You Need for Durable Workflows - Blog
obeli.sk·1mo ago
Typhon Database: Three Configurable Durability Modes in a Single WAL for Flexible Workloads
This article is part of a series about building a database engine called Typhon in C#. It discusses how Typhon implements three different du
dev.to·1mo ago
Comments
Sign in to join the conversation.
No comments yet. Be the first.