SQLite best practices for Go — WAL mode, foreign_keys, busy_timeout, SetMaxOpenConns, context-aware queries, transactions, migrations
98
99%
Does it follow best practices?
Impact
97%
2.36xAverage score across 5 eval scenarios
Passed
No known issues
A developer is building a personal bookmark manager as a Go HTTP service with SQLite as the storage backend. The service exposes a REST API using the standard net/http package (no frameworks).
The service needs to support:
Each bookmark has: id (integer primary key), url (unique), title, description, created_at.
Each folder has: id (integer primary key), name (unique).
A join table bookmark_folders links bookmarks to folders.
Produce:
main.go -- HTTP server setup and routingdb.go -- Database connection and migrationshandlers.go -- HTTP handler functionsstore.go -- Database query functions (data access layer)go.mod -- Module file with dependenciesThe code should be complete Go with no placeholders or TODO comments.
evals
scenario-1
scenario-2
scenario-3
scenario-4
scenario-5
skills
sqlite-go-best-practices
verifiers