Week 11 — Lesson 3: Read-only access and query validation

3 min

The model writes SQL. You did not write it, and you cannot trust it. Model-written SQL must never reach a NorthPeak database that can be changed, so two walls stand between the model and diagnostics.sqlite: a connection opened read-only, and a validator that reads every query before SQLite does. This lesson opens the connection, lists the four rules of the validator, and shows both on the queries of Exercise 2.

Preview — the rest of the lesson is for enrolled readers.

Already enrolled with a code?

Your access is tied to your account, not to this link. Sign in with the same email you used in class: your course is waiting, no need to enter the code again.

Sign inNo account yet? Create one
This lesson is part of the “Week 11 — LLM tools and database querying” module

The first modules of the course are open to everyone. For the rest you have three options: buy this course once and for all, subscribe, or enter the code handed out in class.

Are you a student on this course?

The code is tied to your account: sign in or create an account and it will be applied automatically when you come back.

No account yet? Create one