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
[ Parent
| on HN ]
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.