WAL mode enabled

Foreign keys ON

Busy timeout set

Row factory configured

Checkout uses atomic transaction

Return uses atomic transaction

Bulk add uses transaction

Parameterized queries throughout

Indexes on FK columns

UNIQUE constraints on ISBN and email

Dates as ISO TEXT strings

Connection properly managed

CHECK constraint on status columns

WAL mode enabled

Foreign keys ON

Busy timeout set

Row factory configured

Registration uses atomic transaction

Cancel-and-promote uses transaction

Bulk create uses transaction

Parameterized queries throughout

UNIQUE constraint on member+event

Indexes on FK columns

Connection properly managed

CHECK constraint on status

WAL mode enabled

Foreign keys ON

Busy timeout set

Row factory configured

Receive shipment uses context manager transaction

Record sale uses context manager with validation

Parameterized queries throughout

executemany for bulk inserts

Indexes on FK columns

Money as INTEGER cents

Connection properly closed

Dates as ISO TEXT strings

WAL mode enabled

Foreign keys ON

Busy timeout set

Row factory configured

Money stored as INTEGER cents

Transfer uses context manager transaction

Record transaction uses context manager

CSV import uses transaction

Parameterized queries throughout

Indexes on FK and query columns

Connection properly closed

CHECK constraints on types

WAL mode enabled

Foreign keys ON

Busy timeout set

Row factory configured

Context manager for recipe creation

Context manager for recipe update

Parameterized queries throughout

ON DELETE CASCADE on ingredients FK

Indexes on FK and search columns

Many-to-many via junction table

Connection properly closed

executemany for bulk ingredient inserts