News for hackers. Stuff that matters.
Re:Ask HN: How do you test SQL? by dbsmith83 on Tuesday January 31, 2023 @08:00PM (#34604839)
That still doesn't fix the compatibility issues. Postgres has features/syntax that sqlite does not have, so you can't test postgres syntax with sqlite sometimes
Re:Ask HN: How do you test SQL? by waste_monk on Wednesday February 01, 2023 @05:32PM (#34618958)
That's fair enough.

I meant in situations like parent comment where you're using an ORM such as hibernate that supports multiple databases, you can test as much of the non-DB specific stuff with SQLite in-memory and then do a separate batch of tests with DB specific behaviour.