Detecting Full Table Scans With SQLite

Lobste.rs recently migrated to SQLite and wished they could automatically detect full table scans during tests to catch performance issues early. SQLite exposes prepared statement statistics via an API, making it possible to detect full table scans after execution without using EXPLAIN. This opens the door to integrating scan detection directly into Rails to warn or raise errors in test and development environments.