Support for in-memory databases (h2) for tests? about honeyeql HOT 4 CLOSED

The ideal test suite for HoneyEQL has to interact directly with the database (Postgres & MySQL) and running it against an H2 database is not a foolproof solution.

As mentioned in this comment, once we have the integration test suite in place, having H2 database support would be redundant.

To give you some more context, the generated SQL is vendor-specific and generating one for H2 is not going to be a good value addition to this library.

from honeyeql.

Thanks for the great library! I just want to mention that H2 or SQLite support would be really valuable, not just for testing but for small or embedded applications that don't need a full Postgres or MySQL.

Not that I expect you to implement this :D just saying it could be valuable if someone would be interested in doing that.

from honeyeql.

Sorry, @plexus for the delayed response. I got the use case.

From the implementation perspective, all we need is separate adapter implementations. I am open to accepting the MR if someone is willing to do that!

from honeyeql.

Closing this as the library now have an integration test suite.

from honeyeql.