SQLite Isolation and Data Model

Understand the hybrid MySQL and per-tenant SQLite architecture in CurbPress.

Screenshot placeholder: Diagram or admin view showing MySQL control plane and per-tenant SQLite files.

Hybrid Architecture

WordPress/MySQL stores settings, license data, tenant registry, tenant users, domains, CPT registry, and migration records. SQLite stores tenant application data.

SQLite Files

Tenant database files are named by UUID and sharded under the first two UUID characters. Connections use PDO, WAL mode, foreign keys, and busy timeout.

Sites, CPTs, and Data Models

Scan WordPress custom post types and map tenant data tables in CurbPress.

Migrations and Scale Checklist

Use CPT scanning and dynamic migrations carefully as tenant count grows.