api-tests-use-real-sqlite

IN premise

All API tests run against a real SQLite database with FTS5; storage is never mocked, ensuring the API contract includes correct SQL and full-text search behavior.

Summary

The test suite validates API behavior against an actual SQLite database with full-text search enabled, rather than using fake or simulated storage. This means the tests catch real SQL errors and FTS5 query issues that mocks would hide, so passing tests give genuine confidence that the API works correctly end to end.

Details

Source

entries/2026/05/05/tests-test_api.md