modernc.org/sqlite driver

WAL mode enabled

foreign_keys enabled

busy_timeout configured

SetMaxOpenConns(1)

HTTP request context propagated to DB

defer rows.Close()

rows.Err() checked

Parameterized queries

Transaction for bookmark with folders

defer tx.Rollback()

ON DELETE CASCADE in schema

modernc.org/sqlite driver

WAL mode enabled

foreign_keys enabled via DSN

busy_timeout set

SetMaxOpenConns(1)

Money stored as integer cents

Context-aware queries

defer rows.Close()

rows.Err() checked

Parameterized queries

CHECK constraint on category

Migration pattern

Dates stored as TEXT

modernc.org/sqlite driver

WAL mode enabled

foreign_keys enabled via DSN

busy_timeout set

SetMaxOpenConns(1)

Context-aware queries used

defer rows.Close() on all queries

rows.Err() checked after iteration

Parameterized queries throughout

Transaction for note+tag creation

defer tx.Rollback() pattern

Migration with version tracking

modernc.org/sqlite driver

WAL mode enabled

foreign_keys enabled via DSN

busy_timeout set

SetMaxOpenConns(1)

Atomic claim with transaction

HTTP context propagated to DB

defer tx.Rollback() pattern

defer rows.Close()

Parameterized queries

CHECK constraint on status

Index on status and priority

modernc.org/sqlite driver

WAL mode enabled

foreign_keys enabled via DSN

busy_timeout set

SetMaxOpenConns(1)

HTTP context propagated to DB

Parameterized queries

defer rows.Close()

sql.ErrNoRows handled

Unique constraint on short_code

Index on short_code

Efficient click counter update

Migration pattern