Re: persistence layer

2013-12-05 Thread Lukas Eder
:58 AM To: dev@cloudstack.apache.org Subject: Re: persistence layer Dear CloudStack developers, This thread has caught my attention and I thought I might chime in and give you some background information about jOOQ, JDBC, RDBMS in general (I work for Data

RE: persistence layer

2013-12-05 Thread Frank Zhang
Thanks Lukas. Things are clear now -Original Message- From: Lukas Eder [mailto:lukas.e...@gmail.com] Sent: Thursday, December 05, 2013 7:05 AM To: dev@cloudstack.apache.org Subject: Re: persistence layer Hello, From the follow-up posts on this discussion, I can see that many

RE: persistence layer

2013-12-03 Thread Alex Hitchins
Hello Darren, I'm reading your reply - I shall post comments when I've got through it completely. -Original Message- From: Darren Shepherd [mailto:darren.s.sheph...@gmail.com] Sent: 02 December 2013 17:33 To: dev@cloudstack.apache.org Subject: Re: persistence layer Alright

Re: persistence layer

2013-12-03 Thread Kelven Yang
to underlying DB) would be enough for most of persistence needs in CloudStack. -Original Message- From: Darren Shepherd [mailto:darren.s.sheph...@gmail.com] Sent: Monday, December 02, 2013 9:33 AM To: dev@cloudstack.apache.org Subject: Re: persistence layer Alright, this is long.. I

Re: persistence layer

2013-12-02 Thread Darren Shepherd
To: dev@cloudstack.apache.org Subject: Re: persistence layer Dear CloudStack developers, This thread has caught my attention and I thought I might chime in and give you some background information about jOOQ, JDBC, RDBMS in general (I work for Data Geekery, the company behind

RE: persistence layer

2013-12-02 Thread Frank Zhang
...@gmail.com] Sent: Tuesday, November 26, 2013 3:58 AM To: dev@cloudstack.apache.org Subject: Re: persistence layer Dear CloudStack developers, This thread has caught my attention and I thought I might chime in and give you some background information about jOOQ, JDBC, RDBMS

RE: persistence layer

2013-12-02 Thread Frank Zhang
. -Original Message- From: Darren Shepherd [mailto:darren.s.sheph...@gmail.com] Sent: Monday, December 02, 2013 9:33 AM To: dev@cloudstack.apache.org Subject: Re: persistence layer Alright, this is long.. I have to say after the 10+ years of struggling with JDBC, Hibernate, JbdcTemplate

Re: persistence layer

2013-12-02 Thread Kelven Yang
I generally in agree with what Darren has pointed. Within the context of ACS, declarative transaction support is not as urgent as solving the problem as we are having in writing queries. Solving basic CRUD and query problem alone in a consistent pattern can move CloudStack persistence layer a big

Re: persistence layer

2013-11-28 Thread Lukas Eder
. -Original Message- From: Lukas Eder [mailto:lukas.e...@gmail.com] Sent: Tuesday, November 26, 2013 3:58 AM To: dev@cloudstack.apache.org Subject: Re: persistence layer Dear CloudStack developers, This thread has caught my attention and I thought I might chime in and give you some

RE: persistence layer

2013-11-27 Thread Frank Zhang
@cloudstack.apache.org Subject: Re: persistence layer Dear CloudStack developers, This thread has caught my attention and I thought I might chime in and give you some background information about jOOQ, JDBC, RDBMS in general (I work for Data Geekery, the company behind jOOQ). I've already had

Re: persistence layer

2013-11-26 Thread Lukas Eder
Dear CloudStack developers, This thread has caught my attention and I thought I might chime in and give you some background information about jOOQ, JDBC, RDBMS in general (I work for Data Geekery, the company behind jOOQ). I've already had the pleasure to talk to Darren on the jOOQ User Group and

Re: persistence layer

2013-11-26 Thread Chiradeep Vittal
Hi Lukas, thanks for chiming in. I do agree that abstracting over NoSQL and SQL is not compelling. Both have their specific strengths and developers would be foolhardy to simply assume that swapping one for the other will magically work. On 11/26/13 3:57 AM, Lukas Eder lukas.e...@gmail.com

Re: persistence layer

2013-11-25 Thread Sebastien Goasguen
On Nov 23, 2013, at 4:13 PM, Laszlo Hornyak laszlo.horn...@gmail.com wrote: Wouldn't it be a lot of work to move to JOOQ? All queries will have to be rewritten. An a non-java developer question: Will that help support different databases ? like moving to MariaDB ? On Sat, Nov 23,

Re: persistence layer

2013-11-25 Thread Travis Graham
MariaDB is a drop in replacement for MySQL, so it can be used with or without the JOOQ changes. Travis On Nov 25, 2013, at 5:20 AM, Sebastien Goasguen run...@gmail.com wrote: On Nov 23, 2013, at 4:13 PM, Laszlo Hornyak laszlo.horn...@gmail.com wrote: Wouldn't it be a lot of work to move

RE: persistence layer

2013-11-25 Thread Alex Huang
like derby or sqlserver or oracle or db2. --Alex -Original Message- From: Sebastien Goasguen [mailto:run...@gmail.com] Sent: Monday, November 25, 2013 2:21 AM To: dev@cloudstack.apache.org Subject: Re: persistence layer On Nov 23, 2013, at 4:13 PM, Laszlo Hornyak laszlo.horn

Re: persistence layer

2013-11-23 Thread Darren Shepherd
Jooq does a good job of handling the differences in dialects so as long as you don't use a feature specific to a database your are fine. More info at http://www.jooq.org/doc/3.2/manual/sql-building/dsl-context/sql-dialects/ I've used jooq across databases and it's been fine. The sql we use in

Re: persistence layer

2013-11-23 Thread Darren Shepherd
Going to an ORM is not as simple as you would expect. First, one can make a strong argument that ORM is not the right solution, but that can be ignored right now. You have to look at the context of ACS and figure out what technology is the most practical to adopt. ACS does not have ORM

Re: persistence layer

2013-11-23 Thread Laszlo Hornyak
Wouldn't it be a lot of work to move to JOOQ? All queries will have to be rewritten. On Sat, Nov 23, 2013 at 11:32 AM, Darren Shepherd darren.s.sheph...@gmail.com wrote: Going to an ORM is not as simple as you would expect. First, one can make a strong argument that ORM is not the right

Re: persistence layer

2013-11-22 Thread Daan Hoogland
Had a quick look, It looks alright. One question/doubt: will we thigh ourselves more to mysql if we code sql more directly instead of abstracting away from it so we can leave db choice to the operator in the future!?!? On Thu, Nov 21, 2013 at 7:03 AM, Darren Shepherd darren.s.sheph...@gmail.com

Re: persistence layer

2013-11-22 Thread Alex Ough
All, I'm very interested in converting the current DAO framework to an ORM. I didn't have any experience with java related ORMs, but I've done quite lots of works with Django and LINQ. So can you add me if this project is started? Thanks Alex Ough On Fri, Nov 22, 2013 at 7:06 AM, Daan Hoogland

RE: persistence layer

2013-11-22 Thread Frank Zhang
Message- From: Alex Ough [mailto:alex.o...@sungard.com] Sent: Friday, November 22, 2013 9:50 AM To: dev@cloudstack.apache.org Subject: Re: persistence layer All, I'm very interested in converting the current DAO framework to an ORM. I didn't have any experience with java related ORMs

Re: persistence layer

2013-11-20 Thread Darren Shepherd
I've done a lot of analysis on the data access layer, but just haven't had time to put together a discuss/recommendation. In the end I'd propose we move to jOOQ. It's an excellent framework that will be very natural to the style of data access that CloudStack uses and we can slowly migrate to

persistence layer

2013-11-11 Thread Laszlo Hornyak
Hi, What are the general directions with the persistence system? What I know about it is: - It works with JPA (javax.persistence) annotations - But rather than integrating a general JPA implementation such us hibernate, eclipselink or OpenJPA it uses its own query generator and DAO classes to