# SQLStyle documentation

Run SQLite locally with live replicas, coordinated writes, backups, and recovery.

## [Getting started](https://sqlstyle.com/docs/getting-started.md)

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

## [Architecture overview](https://sqlstyle.com/docs/architecture.md)

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

## [Database core and capture](https://sqlstyle.com/docs/database-cores-and-capture.md)

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

## [Replication and catch-up](https://sqlstyle.com/docs/replication.md)

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

## [Backup and recovery history](https://sqlstyle.com/docs/backup-and-recovery-history.md)

Follow captured transactions from local DBH segments through object storage, controller acceptance, retention, and restore planning.

## [Application Stored Procedures](https://sqlstyle.com/docs/application-stored-procedures.md)

Define typed application operations that SQLStyle runs with the current database primary.

## [Multi-process operation](https://sqlstyle.com/docs/multi-process.md)

Understand how application processes share one database, assign capture ownership, and continue after the capture host exits.

## [Standard, Permissive, and Lightspeed integrity modes](https://sqlstyle.com/docs/lightspeed.md)

Choose user-connection, live-replication, and local-image integrity policy independently on each SQLStyle node.

## [Primary authority and failover](https://sqlstyle.com/docs/primary-and-failover.md)

Understand direct peer health, controller confirmation, recoverable candidate selection, and fenced transfer to a new primary.

## [Node capabilities](https://sqlstyle.com/docs/node-roles.md)

Configure controller permissions, capture ownership, and capture-loss recovery independently.

## [Object storage](https://sqlstyle.com/docs/object-storage.md)

Store backups and recovery history in your S3-compatible object storage.

## [Point-in-time recovery](https://sqlstyle.com/docs/restore-and-recovery.md)

Build recovery history in your object storage, verify it, and restore SQLite to the latest accepted state or an earlier point in time.

## [Status and SQL surfaces](https://sqlstyle.com/docs/status-and-sql-surfaces.md)

Query authority, topology, backup, and durability state through the managed SQLite connection.

## [What consumes controller-state writes](https://sqlstyle.com/docs/controller-state-writes.md)

See which database, account, and runtime actions consume the controller-state write allowance.

## [CLI reference](https://sqlstyle.com/docs/cli-reference.md)

Manage accounts, databases, keys, storage, recovery, and analytics from the CLI.