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
Build a personal finance tracking API with Python and Flask. Use SQLite for storage (this is a single-user desktop app).
The system needs:
Produce:
app/database.py -- Database connection and schemaapp/models.py -- Pydantic models for request/responseapp/routes.py -- Flask route handlersapp/app.py -- Flask application setuprequirements.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