Why BoutiqueDB?

Discover why BoutiqueDB is built specifically for Apple platforms, combining local-first persistence with Turso engine capabilities.

Building modern iOS and macOS applications requires a persistence layer that is fast, reliable, thread-safe, and offline-ready. Standard solutions often force developer tradeoffs between complex ORM abstractions and low-level SQL C APIs.

BoutiqueDB combines the local-first ergonomics of SQLite with modern Swift concurrency, Change Data Capture (CDC) observation, and Apple CloudKit sync.

---

Key Advantages

Offline & Local-First

Your database lives locally on the user’s device. Apps launch instantly and operate seamlessly without network connectivity.

Swift Concurrency Safe

Built from the ground up with @MainActor UI safety and isolated background DatabaseActor execution.

CDC Reactive Updates

UI views update automatically (< 250ms latency) via native Change Data Capture without heavy polling or manual notifications.

Zero Server Overhead

Sync data seamlessly across user Apple devices using private CloudKit containers without managing servers or API endpoints.

---

Comparison Matrix

Feature	BoutiqueDB	SwiftData / CoreData	GRDB	Raw SQLite3
Local SQLite File
Swift Concurrency (async/await)				Manual
Type-Safe Queries (@Table)				Strings
CDC Live Observation		KVO / NSFRC		Manual
CloudKit Private Sync			Extra setup	Custom
Full-Text Search (Tantivy BM25)	Native	Basic FTS	FTS5	FTS5
Vector Search (AI Embeddings)	Native	No	Extension	Extension
Hardware Encryption (AEGIS)	Built-in	Data Protection	SQLCipher	Custom

---

Architectural Philosophy

1. Local-First Authority: The database file inside your app sandbox is the single source of truth. Network synchronization is asynchronous and non-blocking.
2. Type Safety Without Magic: Models use compile-time macros (@Table) so queries remain standard Swift code.
3. Explicit Over Implicit: Schema migrations and experimental engine flags (TursoOpenOptions) are explicit and version-controlled.