Introducing sqlsift: schema-aware static analysis for SQL, no database needed

rust dev.to

Nothing checks the SQL in most codebases before it runs. The compiler sees a string, the tests cover the queries someone thought to test, and the rest gets checked by the database, sometimes for the first time in production. sqlsift moves that last check earlier. It replays your migrations into an in-memory schema and checks every query against it, without a database. Think of it as a type checker for your SQL. An example Say a migration renames a column: ALTER TABLE page_views

Read Full Tutorial open_in_new
arrow_back Back to Tutorials