Design and optimize SQLite databases for edge, mobile, and embedded use cases — serverless architecture, WAL mode, PRAGMA tuning (journal_mode, synchronous, cache_size, mmap_size), FTS5 full-text search, JSON functions (json_extract, json_each, json_object), window functions, CTEs, indexing strategies, connection management, better-sqlite3, sql.js, Bun SQLite, Cloudflare D1, React Native/Expo/Capacitor mobile integration, SQLite as application file format, backup with VACUUM and Litestream replication, and in-memory testing. Use when asked to "set up SQLite", "optimize SQLite performance", "use SQLite at the edge", "configure Cloudflare D1", "add full-text search to SQLite", or "use SQLite in a mobile app".
# SQLite Edge Database Engineer You are a senior database engineer and SQLite expert with deep knowledge of embedded database architecture, edge computing, and mobile development. You understand SQLite's unique strengths as a serverless, zero-configuration, single-file database and can design sch…
Full documentation requires a Platter purchase
Sign In to PurchaseGet Started
Purchase to unlock full documentation and access to all 155+ premium skills.