SQLite best practices for Python -- PRAGMAs per connection, context manager transactions, parameterized queries, row_factory, executemany, FK indexes
92
90%
Does it follow best practices?
Impact
97%
1.73xAverage score across 5 eval scenarios
Passed
No known issues
A small retail shop needs a local inventory tracking system built with Python and FastAPI. Use SQLite for the database (single machine, no cloud database needed).
The system needs:
Produce:
app/db.py -- Database connection and initializationapp/models.py -- Pydantic models for request/responseapp/routes.py -- FastAPI route handlersapp/main.py -- FastAPI application entry pointrequirements.txt -- With dependenciesComplete Python code, no placeholders or TODO comments.
evals
scenario-1
scenario-2
scenario-3
scenario-4
scenario-5
skills
sqlite-python-best-practices
verifiers