Skills
.Work. You
Rest

embedded-patterns

Community

Best-practice SQLite embedding across platforms.

Software Engineering#migration#concurrency#sqlite#backup#libsql#turso#embedded-patterns
Authorjsamuelsen11
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Patterns and guidance for embedding SQLite in mobile, desktop, serverless, and edge deployments. It covers connection management, concurrency, backup strategies, migrations, and libSQL/Turso integration for robust, production-ready databases.

Core Features & Use Cases

  • Connection Management: 1 writer + N readers pattern with PRAGMA initialization immediately after opening.
  • WAL Concurrency: guidelines for multi-reader concurrency and safe writer behavior across platforms.
  • Backup Strategies: online backups, VACUUM INTO, and checkpoint-and-copy to protect data.
  • Migrations & Testing: startup migrations, idempotent changes, and test strategies for embedded databases.
  • Embedded Replicas: using libSQL/Turso for local reads with remote writes.
  • Platform Patterns: iOS, Android, Electron, and serverless considerations.

Quick Start

Apply the embedded SQLite patterns by configuring a dedicated writer, multiple readers, WAL where applicable, and implement backups and startup migrations.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: embedded-patterns
Download link: https://github.com/jsamuelsen11/claude-config/archive/main.zip#embedded-patterns

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.