Some SQLite tests use in-memory databases, while others use temporary files without consistency. Unless there's a specific reason for that, we should make them consistent by using in-memory databases for most tests to speed up execution, and keep only a small subset using temporary files to verify filesystem persistence works.
Some SQLite tests use in-memory databases, while others use temporary files without consistency. Unless there's a specific reason for that, we should make them consistent by using in-memory databases for most tests to speed up execution, and keep only a small subset using temporary files to verify filesystem persistence works.