-
1. Re: New SQL cache store based on jOOQ
rvansa Oct 6, 2016 9:49 AM (in response to vdzhuvinov)Interesting, sounds like a light-weight alternative to ORM (JPA uses Hibernate ORM underhood). Btw., rather than defining the configuration through generic properties, you could write configuration parser and provide users with a neat XSD schema.
-
2. Re: New SQL cache store based on jOOQ
rvansa Oct 6, 2016 9:51 AM (in response to rvansa)Btw., I miss the link to source code.
-
3. Re: New SQL cache store based on jOOQ
vdzhuvinov Oct 6, 2016 10:32 AM (in response to rvansa)Pardon, here is a link to the Git repo: connect2id / SQL Cache Store — Bitbucket
-
4. Re: New SQL cache store based on jOOQ
vdzhuvinov Oct 6, 2016 10:43 AM (in response to rvansa)The XSD schema is a neat idea, I hope we'll be able to implement it eventually. I already looked at some config parsers from other "official" cache stores.
I like jOOQ for its lambda support, which allows you to filter / map / reduce SQL records elegantly, with added type safety.
I also wondered whether the CacheStore interface could be extended with methods to support Infinispan Query DSL that runs directly on the underlying store / database.
We actually did something primitive along these lines with the jOOQ based SQL store, so we don't have to rely on Infinispan indexing for certain queries.
-
5. Re: New SQL cache store based on jOOQ
vdzhuvinov Oct 20, 2016 4:14 AM (in response to rvansa)The other day we released a new version with a proper config parser and XSD schema. The config is much prettier now!
http://www.javadoc.io/doc/com.nimbusds/infinispan-cachestore-sql/2.4.1
Properties are still used, but only to set the underlying data source (Hikari CP).
There's also support for metrics (via Dropwizard metrics).