HSQLDB support

[binkley]

Perhaps it is a documentation issue of the frontpage README, but I'd like to see HSQLDB explicitly supported.

[Tapac]

No, there is no dialect for HSQLDB in Exposed, but you can implement it and provide us with PR.

[bgmf]

I tried to do that, but struggle to cope with the wildly distributed APIs and whatnot. Currently I try to remove the quotes from the query, that renders SQL like SELECT ROLES."id", ROLES."name" FROM ROLES and results in user lacks privilege or object not found: ROLES.id.

If you use a DB tool of your choice, you can recreate the issue by using a query like stated. If you now remove the quotes, it works.

But I have no idea, how to tell the system, to not us quotes (at least not in the given three default classes VendorDialect, DataTypeProvider and FunctionProvider). Do I need to explicitly implement the parent interface DatabaseDialect?

Oh and yes, I registered my dialect with the Database class...

[dirk0108]

Is there any news on this? Are there any plans to officially support HslqDB?

[bgmf]

I wouldn't bet on it. And to be honest: I don't see the need anymore. With Docker etc. you can just spin up a supported local DB fast...

[dirk0108]

HsqlDB is used in many applications in embedded operation. This is also the case in my production application. A Docker container can't help me with that ;)