News for hackers. Stuff that matters.
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
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.