Using OrientDB

[Renaud]

Hi,

Is their a way to make Lucee and OrientDB work together.

I am a little bit confused about API & Drivers ; I lack depth technical knowledge.

http://orientdb.com/docs/1.7.8/orientdb.wiki/Programming-Language-Bindings.html

Thanks for any advices.

[mark]

The easiest way to get started with OrientDB in Lucee is through the rest/http api and cfhttp,
someone out there created a driver for Railo but it's a couple years old and for an older version OrientDB.
Silly question but is a graph db really needed in your Lucee app?

[Renaud]

Silly question but is a graph db really needed in your Lucee app?

This is more a technological survey and test for prospective purpose.

This is ColdFusion Summit right now and I was wondering Adobe sight of view about NoSQL (https://cfsummit.adobeevents.com/schedule/sessions/coldfusion_and_nosql.html)

Thanks.  

[Chris Blackwell]

Orient DB supports jdbc so you should be able to add the driver to your lucee install and create a custom datasource to connect to OrientDB

See - https://github.com/orientechnologies/orientdb/tree/develop/jdbc

--
Love Lucee? Become a supporter and be part of the Lucee project today! - http://lucee.org/supporters/become-a-supporter.html
---
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/0aeeaf86-2a4f-46d0-a88e-bc7dd034eb42%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[mark]

The JDBC driver is very limited and really meant for a database gui or reporting tool.

[Chris Blackwell]

Well, i've never used it in production, but i did setup orientdb with lucee, using jdbc and worked through several tutorials.  While i'm not sure what limitations you're referring too, i was able to perform CRUD operations directly via <cfquery> using orientdb's subset of SQL, which means it presents a familiar interface to cfml dev's 

To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/456877d9-6d51-419a-bbb9-22424f4dae2c%40googlegroups.com.

[mark]

Yes, for crud I think it's fine,  I also had tried the jdbc and had issues with parameterized queries which I don't think it supported at the time,
Orientdb's SQL is so much like regular SQL it leaves it open to plain old sql injections, OrientDB has functions (stored procedures) to help prevent
sqli but not sure if the jdbc driver could execute them.

[Renaud]

Hi

In which folder should I put the jdbc driver ?

Also, Lucee administrator offer many other Datasource JDBC. Are they installed, or should I get them before ?

H2 seem to remplace Derby. Is there any specific reason ?

Thanks