[ANN] orientqb: OSQL query builder

[Riccardo Tasso]

Hi all,

   it's a couple of years I'm working on a project using OrientDB as primary data storage and I find it a good product with great support team and a interesting community of users.

Since our application uses a lot OSQL query language I decided to write a query builder with these goals:

• writing complex queries without dealing with ugly Java String composition
• avoiding syntax errors in OSQL as much as possible

During Winter holidays I decided it would be useful to make it available also to other OrientDB users and I spent some time implementing all the missing construct for OSLQ SELECT statement ( http://www.orientechnologies.com/docs/last/orientdb.wiki/SQL-Query.html ). Now it is public (under ASL 2.0) on github:

https://github.com/raymanrt/orientqb

On the repository you will find: further information about the project and design choices, a little tutorial to start with and all the unit tests for (almost) every function implemented.

I really would like to have some feedback both from the development team and from the users at any kind of level. Of course any contribution is appreciated.

Cheers,

   Riccardo

[ste...@activitystream.com]

Great stuff Riccardo, look forward to trying it out. 

Thank you.

Regards,

 -Stefan

[Luca Garulli]

Hey Riccardo,

You did it! Thanks very much. I hope the community adopts it in their Java projects soon :-)

Lvc@

On 13 January 2015 at 23:35, <ste...@activitystream.com> wrote:

Great stuff Riccardo, look forward to try it out. 

Thank you.

Regards,

 -Stefan

On Monday, 12 January 2015 08:58:17 UTC, Riccardo Tasso wrote:

--

---
You received this message because you are subscribed to the Google Groups "OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orient-databa...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Riccardo Tasso]

Hi, a little step for orientdb a big step for orientqb, I've published my artifacts to oss sonatype repository, and now orientqb can be included in your projects also without building from source.

Have fun,

   Riccardo

[Luca Garulli]

Hi Riccardo.

What's the maven snippet to include?

Lvc@

[Riccardo Tasso]

This one should work:

<dependency>
  <groupId>com.github.raymanrt</groupId>
  <artifactId>orientqb</artifactId>
  <version>0.1.0</version>
</dependency>

[Wouter de Vaal]

This is great stuff. It is really nice, easy and lightweight. Should become part of the official OrientDB project!

Wouter

Op maandag 12 januari 2015 09:58:17 UTC+1 schreef Riccardo Tasso:

[Riccardo Tasso]

Thank you, those were some of the design choices.

If you have some hints please write them here.

Cheers,

   Riccardo

--

[Riccardo Tasso]

Hi,

   just to make you know that orientqb 0.1.3 has just been released on Maven Central, with some minor fixes.

Take a look on https://github.com/raymanrt/orientqb

Cheers,

   Riccardo

[ste...@activitystream.com]

Thank you Riccardo! :)

[Riccardo Tasso]

To Stefan and to others which may be using orientqb: what do you think of it?
For what use case are you using it?

What should be added or changed?

Cheers,

   Riccardo

[Riccardo Tasso]

Hi,

   just to make you know that orientqb 0.2.0 has just been released on Maven Central, with the implementation of DELETE statement.

DELETE convinced me to abstract more on the Query class and this should enable the easier implementation also of UPDATE, INSERT and the other OSQL statements.

I would also cheers the users/contributors which encouraged me to go on with the project.

Take a look on https://github.com/raymanrt/orientqb

Cheers,

   Riccardo