You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@gora.apache.org by "Enis Soztutar (Created) (JIRA)" <ji...@apache.org> on 2012/01/04 18:32:39 UTC
[jira] [Created] (GORA-74) Remove sqlbuilder library
Remove sqlbuilder library
-------------------------
Key: GORA-74
URL: https://issues.apache.org/jira/browse/GORA-74
Project: Gora
Issue Type: Improvement
Reporter: Enis Soztutar
We have to remove the library sqlbuilder, which is used by gora-sql, to construct queries from code. The reasons are
- It is LGPL
- We have very little need for this library.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (GORA-74) Remove sqlbuilder library
Posted by "Enis Soztutar (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/GORA-74?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13189960#comment-13189960 ]
Enis Soztutar commented on GORA-74:
-----------------------------------
Thanks Lukas for the nice info!
> Remove sqlbuilder library
> -------------------------
>
> Key: GORA-74
> URL: https://issues.apache.org/jira/browse/GORA-74
> Project: Gora
> Issue Type: Improvement
> Reporter: Enis Soztutar
>
> We have to remove the library sqlbuilder, which is used by gora-sql, to construct queries from code. The reasons are
> - It is LGPL
> - We have very little need for this library.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (GORA-74) Remove sqlbuilder library
Posted by "Enis Soztutar (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/GORA-74?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13189423#comment-13189423 ]
Enis Soztutar commented on GORA-74:
-----------------------------------
Haven't looked at the alternatives for some time. The constructs in SqlStore was not complex, so we can opt not to use a library, but use and extend the SQL support under gora-sql/src/main/java/org/apache/gora/sql/statement/. But if you think something like JOOQ makes sense, I am totally up for it.
> Remove sqlbuilder library
> -------------------------
>
> Key: GORA-74
> URL: https://issues.apache.org/jira/browse/GORA-74
> Project: Gora
> Issue Type: Improvement
> Reporter: Enis Soztutar
>
> We have to remove the library sqlbuilder, which is used by gora-sql, to construct queries from code. The reasons are
> - It is LGPL
> - We have very little need for this library.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (GORA-74) Remove sqlbuilder library
Posted by "Lewis John McGibbney (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/GORA-74?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lewis John McGibbney updated GORA-74:
-------------------------------------
Affects Version/s: 0.1.1-incubating
Fix Version/s: 0.2
> Remove sqlbuilder library
> -------------------------
>
> Key: GORA-74
> URL: https://issues.apache.org/jira/browse/GORA-74
> Project: Apache Gora
> Issue Type: Improvement
> Affects Versions: 0.1.1-incubating
> Reporter: Enis Soztutar
> Fix For: 0.2
>
>
> We have to remove the library sqlbuilder, which is used by gora-sql, to construct queries from code. The reasons are
> - It is LGPL
> - We have very little need for this library.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (GORA-74) Remove sqlbuilder library
Posted by "Lewis John McGibbney (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/GORA-74?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13212742#comment-13212742 ]
Lewis John McGibbney commented on GORA-74:
------------------------------------------
Some really helpful info from Lukas here.
http://groups.google.com/group/jooq-user/browse_thread/thread/7079c57fddae063a
> Remove sqlbuilder library
> -------------------------
>
> Key: GORA-74
> URL: https://issues.apache.org/jira/browse/GORA-74
> Project: Apache Gora
> Issue Type: Improvement
> Affects Versions: 0.1.1-incubating
> Reporter: Enis Soztutar
> Fix For: 0.2
>
>
> We have to remove the library sqlbuilder, which is used by gora-sql, to construct queries from code. The reasons are
> - It is LGPL
> - We have very little need for this library.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (GORA-74) Remove sqlbuilder library
Posted by "Lewis John McGibbney (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/GORA-74?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13189443#comment-13189443 ]
Lewis John McGibbney commented on GORA-74:
------------------------------------------
Hi Enis, I understand where you are coming from. @ a quick glance, JOOQ says it supports the following RDB's
* DB2 9.7
* Derby 10.8
* H2 1.3.161
* HSQLDB 2.2.5
* Ingres 10.1.0
* MySQL 5.1.41 and 5.5.8
* Oracle XE 10.2.0.1.0 and 11g
* PostgreSQL 9.0
* SQLite with inofficial JDBC driver v056
* SQL Server 2008 R8
* Sybase Adaptive Server Enterprise 15.5
* Sybase SQL Anywhere 12
I know we are not focusing on any of this in particular (TBH I couldn't really care for the RDB model at the moment), however I think the flexibility it offers is quite a strong arguement for implementation. Also it looks like it has a pretty active community so we know that the API is being maintained and developed.
> Remove sqlbuilder library
> -------------------------
>
> Key: GORA-74
> URL: https://issues.apache.org/jira/browse/GORA-74
> Project: Gora
> Issue Type: Improvement
> Reporter: Enis Soztutar
>
> We have to remove the library sqlbuilder, which is used by gora-sql, to construct queries from code. The reasons are
> - It is LGPL
> - We have very little need for this library.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (GORA-74) Remove sqlbuilder library
Posted by "Lewis John McGibbney (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/GORA-74?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13189417#comment-13189417 ]
Lewis John McGibbney commented on GORA-74:
------------------------------------------
Do we have any idea what we are going to replace this with? I've been looking around and have seen querdsl and jooq
JOOQ looks the most promising
http://www.jooq.org/
Released under ASL 2.0
> Remove sqlbuilder library
> -------------------------
>
> Key: GORA-74
> URL: https://issues.apache.org/jira/browse/GORA-74
> Project: Gora
> Issue Type: Improvement
> Reporter: Enis Soztutar
>
> We have to remove the library sqlbuilder, which is used by gora-sql, to construct queries from code. The reasons are
> - It is LGPL
> - We have very little need for this library.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (GORA-74) Remove sqlbuilder library
Posted by "Lukas Eder (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/GORA-74?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13189858#comment-13189858 ]
Lukas Eder commented on GORA-74:
--------------------------------
Hello guys,
I am the developer of jOOQ, and I'm glad that you're considering jOOQ for SQL abstraction in Gora. jOOQ has known a steady increase of popularity in the past year since its first public release in Summer 2010:
https://sourceforge.net/projects/jooq/files/stats/timeline?dates=2010-07-01+to+2012-01-20
I have strong ambitions to make jOOQ the default SQL abstraction framework of choice in Java (and maybe Scala/Groovy), in setups where SQL really matters (i.e. all the use-cases where JPA/Hibernate with JPQL/HQL fails). Maybe this information will help you position yourself while considering jOOQ and/or QueryDSL.
If I can help you with any additional information, feel free to contact me also directly: lukas.eder@gmail.com
> Remove sqlbuilder library
> -------------------------
>
> Key: GORA-74
> URL: https://issues.apache.org/jira/browse/GORA-74
> Project: Gora
> Issue Type: Improvement
> Reporter: Enis Soztutar
>
> We have to remove the library sqlbuilder, which is used by gora-sql, to construct queries from code. The reasons are
> - It is LGPL
> - We have very little need for this library.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira