groovy-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Korbee Reinout <Reinout.Kor...@snb.ch>
Subject RE: High Level DSL for Database Querying
Date Tue, 11 Dec 2018 10:52:59 GMT
Hi, I’m late to reply, but when facing this issue, I decided to build a DSL with a fluent
API, similar to jOOQ, on QueryDSL, with Java, but it could easily be used with Groovy. Have
a look: https://github.com/reinoutkorbee/NativeQueryDSL. I use it in production, but it is
not complete. It is a simple SQL generator, based on Query DSL. Otherwise, have a look at
Query DSL. It is fully open source: http://www.querydsl.com/ I developed the SQL generator
because I wanted to use a DSL where Hibernate or JPA would produce sub-optimal SQL.

From: mgbiz@arscreat.com <mgbiz@arscreat.com>
Sent: Monday, October 22, 2018 5:46 PM
To: paulk@asert.com.au
Cc: dev@groovy.apache.org
Subject: Re: High Level DSL for Database Querying


When I evaluated what to base my framework on, I did not find much that was available and
looked interesting, except jOOQ - which at the time started steering away from being pure
OS (so was a no go for us).



The jOOQ webpage licensing FAQ has the following to say on the topic:

Can I use "jOOQ Open Source Edition" also in commercial software?
A: Yes, as any Apache-licensed software, jOOQ can be used in commercial software.

Q: Can I use "jOOQ Open Source Edition" also with commercial databases?
A: It is unlikely that you will get the "jOOQ Open Source Edition" to work properly with a
commercial database that is not supported by the "jOOQ Open Source Edition". We strongly suggest
purchasing commercial licenses.



Cheers,

mg



This e-mail message contains confidential information and is intended only for the named recipient(s).
If you are not an intended recipient, any disclosure, copying or distribution is prohibited.
Please notify the sender immediately by e-mail if you have received this message in error
and delete this message from your system. As internet communications are not secure, the Swiss
National Bank accepts no liability for any errors or omissions in the contents of this message.
Any views expressed in this message are those of the individual sender, except where the sender
specifically states them to be the views of the Swiss National Bank.
Mime
View raw message