Models and Tables

Define type-safe database schemas and models in Swift using @Table and @BoutiqueTable macros.

BoutiqueDB leverages Point-Free’s StructuredQueries DSL alongside custom @BoutiqueTable macros to map Swift structs directly to database tables.

---

Defining @Table Models

Annotate your model struct with @Table and specify column types. StructuredQueries automatically generates type-safe query builders (Note.all, Note.where, Note.insert).

Note.swift

import Foundation
import BoutiqueDB
import StructuredQueries

@Table
struct Note: Sendable {
    @Column(primaryKey: true) let id: UUID
    var title: String
    var body: String
    var isArchived: Bool
    var createdAt: Date
}

@Column(primaryKey: true) · Macro Modifier

Marks the property as the table’s Primary Key.

Types Supported · Swift Types

Standard Swift types automatically map to SQLite types: String, Int, Double, Bool, Data, UUID, and Date.

---

Turso Enhancements with @BoutiqueTable

When advanced database constraints or indexes are required, use @BoutiqueTable:

UserSetting.swift

import BoutiqueDB
import StructuredQueries

@BoutiqueTable(strict: true, withoutRowID: true)
struct UserSetting: Sendable {
    @Column(primaryKey: true) var key: String
    var value: String
}

STRICT Mode

Enforces strict datatype checking on SQLite columns at insertion time.

WITHOUT ROWID

Optimizes index storage and lookups for tables with explicit primary keys.

---

Type-Safe Queries

Once a model is defined, perform CRUD operations using Swift closures instead of raw SQL strings:

Insert.swift

try await db.write { conn in
    let newNote = Note(
        id: UUID(),
        title: "Grocery List",
        body: "Milk, Eggs, Bread",
        isArchived: false,
        createdAt: Date()
    )
    
    try Note.insert { newNote }.execute(conn.connection)
}

Compile-Time Safety: If a model property name changes or type changes, Xcode catches query mismatches during project compilation!