Re:Ask HN: How do you test SQL?
by gardenhedge on Tuesday January 31, 2023 @07:02PM
(#34604226)
So you test against a different database technology than the one you software uses? I understand why that works but it seems odd
[ Parent
| on HN ]
Re:Ask HN: How do you test SQL?
by quantified on Tuesday January 31, 2023 @09:05PM
(#34605385)
A real nice thing about Postgres and Mysql is that in the JVM world the H2 and HSQLDB engines have large compatibility, you can use them in-JVM for unit test speed in many cases. Doesn't help developing the SQL, does help with testing.
Snowflake, on the other hand, is just special.
Re:Ask HN: How do you test SQL?
by gardenhedge on Wednesday February 01, 2023 @06:14PM
(#34619505)
I assume this can't be done with Oracle DBs
Re:Ask HN: How do you test SQL?
by quantified on Wednesday February 01, 2023 @09:16PM
(#34621186)
I haven't explored myself, but I would bet they have good Oracle compatibility for at least the subset of semantics they support.