Documentation

Build with SQLStyle

Learn how to embed SQLite with direct replication, hosted primary coordination, backups, and point-in-time recovery.

View as Markdown Complete docs corpus

Choose a path

Start with the account-to-application flow, then use the architecture section to understand the parts involved in replication or recovery.

Start

Getting started

Create an account, configure the SQLStyle CLI, and open a local database through the SDK.

Architecture

Architecture overview

See where SQLStyle runs, what capture publishes, and how replication, backup history, and controller authority fit together.

Architecture

Database core and capture

Understand how the Bedrock database core feeds capture for WAL2 retention, page encoding, ring publication, and DBH handoff.

Architecture

Replication and catch-up

Follow a replica from live page delivery through local DBH catch-up, ring-pressure eviction, and rsync replacement.

All documentation

Start

Getting startedCreate an account, configure the SQLStyle CLI, and open a local database through the SDK.

Architecture

Architecture overviewSee where SQLStyle runs, what capture publishes, and how replication, backup history, and controller authority fit together.Database core and captureUnderstand how the Bedrock database core feeds capture for WAL2 retention, page encoding, ring publication, and DBH handoff.Replication and catch-upFollow a replica from live page delivery through local DBH catch-up, ring-pressure eviction, and rsync replacement.Backup and recovery historyFollow captured transactions from local DBH segments through object storage, controller acceptance, retention, and restore planning.Multi-process operationUnderstand how application processes share one database, assign capture ownership, and continue after the capture host exits.Standard, Permissive, and Lightspeed integrity modesChoose user-connection, live-replication, and local-image integrity policy independently on each SQLStyle node.Primary authority and failoverUnderstand direct peer health, controller confirmation, recoverable candidate selection, and fenced transfer to a new primary.

Concepts

Application Stored ProceduresDefine typed application operations that SQLStyle runs with the current database primary.Node capabilitiesConfigure controller permissions, capture ownership, and capture-loss recovery independently.

Guides

Object storageStore backups and recovery history in your S3-compatible object storage.Point-in-time recoveryBuild recovery history in your object storage, verify it, and restore SQLite to the latest accepted state or an earlier point in time.

Reference

Status and SQL surfacesQuery authority, topology, backup, and durability state through the managed SQLite connection.What consumes controller-state writesSee which database, account, and runtime actions consume the controller-state write allowance.CLI referenceManage accounts, databases, keys, storage, recovery, and analytics from the CLI.

For AI agents

SQLStyle publishes the same Markdown used for these pages. Use the compact index for discovery or the complete corpus for a single import.

/llms.txt — concise topic index and preferred entry points.
/llms-full.txt — all public documentation in one response.
/docs/<topic>.md — canonical Markdown for one topic.
/docs-manifest.json — structured topic metadata.