Using OrientDB

dev google-group-archive
#1

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.

#2

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?On Monday, November 9, 2015 at 4:17:08 PM UTC-6, Renaud wrote:

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.

#3

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.

#4

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/jdbcOn Tue, 10 Nov 2015 at 10:34 Renaud <@Renaud> wrote:

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.

–
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+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/0aeeaf86-2a4f-46d0-a88e-bc7dd034eb42%40googlegroups.com
https://groups.google.com/d/msgid/lucee/0aeeaf86-2a4f-46d0-a88e-bc7dd034eb42%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

#5

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.On Tuesday, November 10, 2015 at 9:42:59 AM UTC-6, Chris Blackwell wrote:

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 using orientdb’s subset of SQL, which
means it presents a familiar interface to cfml dev’s

On Tue, 10 Nov 2015 at 13:08 mark <mgr...@gmail.com <javascript:>> wrote:

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

On Tuesday, November 10, 2015 at 5:50:27 AM UTC-6, Chris Blackwell wrote:

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

On Tue, 10 Nov 2015 at 10:34 Renaud rcollet...@gmail.com wrote:

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.

–
Love Lucee? Become a supporter and be part of the Lucee project today!

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
https://groups.google.com/d/msgid/lucee/0aeeaf86-2a4f-46d0-a88e-bc7dd034eb42%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

–
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 <javascript:>.
To post to this group, send email to lu...@googlegroups.com <javascript:>
.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/456877d9-6d51-419a-bbb9-22424f4dae2c%40googlegroups.com
https://groups.google.com/d/msgid/lucee/456877d9-6d51-419a-bbb9-22424f4dae2c%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

#6

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