WAL mode enabled

Foreign keys ON

Busy timeout set

Graceful shutdown

Transaction for post+tags creation

Indexes on junction table FKs

Index on posts.author_id FK

JSON for metadata

CHECK constraint on post status

Prepared statements throughout

Migration pattern

Dates as TEXT ISO 8601

STRICT tables

Cached prepared statements

WAL mode enabled

Foreign keys ON

Busy timeout set

synchronous = NORMAL

Graceful shutdown with db.close()

Transaction for order creation

Prepared statements throughout

Indexes on foreign key columns

Migration pattern used

Money stored as INTEGER cents

CHECK constraint on order status

STRICT tables

JSON for customizations

WAL mode enabled

Foreign keys ON

Busy timeout set

Graceful shutdown

Atomic booking with capacity check

Cancel booking in transaction

Indexes on bookings.event_id FK

Prepared statements throughout

Money as INTEGER cents

CHECK constraints on statuses

Dates as TEXT ISO 8601

Migration pattern

STRICT tables

synchronous = NORMAL

WAL mode enabled

Foreign keys ON

Busy timeout set

Graceful shutdown

Receive shipment uses transaction

Record sale uses transaction with validation

Indexes on FK columns

Prepared statements throughout

Money as INTEGER cents

Dates as TEXT for movement timestamps

CHECK constraint on movement type

Migration pattern

STRICT tables

WAL mode enabled

Foreign keys ON

Busy timeout set

Graceful shutdown

Bulk import uses transaction

Prepared statement reuse in bulk

Indexes on all foreign keys

CHECK constraints on priority and status

Dates as TEXT ISO 8601

Migration pattern

Prepared statements throughout

STRICT tables

Money as INTEGER