more NoSQL databases support

[mictadlo]

Hi, Any plans to support CouchDB and OrientDB?

Mic

[yazz]

It can already support any database on the server side. Do you mean client side support for MongoDB or OrientDB? If so then I can look into doing this

[yazz]

If I do include MongoDB or OrientDB, which librairies do you recommend? So far I have seen:

https://github.com/eduardoejp/clj-orient http://clojuremongodb.info/

[mictadlo]

OrientDB is a Document and Graph DBMSs, but MongoDB is only Document database. I have not use OrientDB yet, but I think to do it soon rather than MongoDB. Combining clojure and clojurescript it is possible to write views in clojuresrit rather in javascript ( http://www.ibm.com/developerworks/library/j-couchdb-clojure/ ) for couchdb. Furthermore, couchdb allows accessing data via HTTP easily. i have not use https://github.com/eduardoejp/clj-orient and http://clojuremongodb.info/ .

[yazz]

I can implement an interface to any graph database or document database. Which one would be useful to you for your purposes? The two I have used myself are Postgresql and Neo4j which is why they are currently the only backends supported. Or if you want you could tell me a bit more about your project

[mictadlo]

At the moment I am not allowed to talk about the future project, but OrientDB would be handy to have because of these features http://www.orientechnologies.com/orientdb-vs-mongodb/ .

[yazz]

Ok, Orient DB could be supported. What type of API support are you looking at for Orient DB?

1) Server side only 2) Client and Server side (same as our Secure Neo4j client side support)

[mictadlo]

Thank you, the second option please (same like Secure Neo4j)

[yazz]

Ok, thanks. I have already started on this task. Since Coils has third parties providing commericial support I need to reach out to Orient DB regarding this as well, to make sure we build something that will be stable and supported long term. Can I ask what is the timeframe that you need support for? I ask this as Clojure on Coils is undergoing a major rewrite at the moment (based on Om), with the Beta coming out around July

[yazz]

I have reached out to the guys at OrientDB to ask for their recommendation on which Clojure library to use, so I am just waiting for an answer :)

[mictadlo]

Thank you, I am not in rush and you can rewrite it first.

[yazz]

I spoke to the guys at OrientDB and https://github.com/eduardoejp/clj-orient is not supported as it has not been active for a while. Do you know any other library for Clojure to connect to OrientDB?

[mictadlo]

unfortunately not.

[yazz]

This would be a requitement to support OrientDB. Maybe if we reach out to the author of the OrientDB Clojure library? Do you know him, or should I reach out?

[mictadlo]

No, I do not him and I think it would be better if you could do it.

[yazz]

Ok, will do. It will probably be quite a long process to do this, and probably we will use a consultant to do this task, depending on how large it is. I need to ask some questions from you though so we know how the API should work from a developer's point of view. The main question is what is the equivalent of Cypher or SQL in the OrientDB world, as that is the basis of the whole secure client side support, so that no SQL injections attacks can occur?

[yazz]

I am also looking for a Java API to OrientDB, as that will also be perfectly usable from Clojure

[yazz]

http://stackoverflow.com/questions/24207712/what-is-the-query-language-for-orientdb

[yazz]

Ok, so can I confirm that this is the query language that you have been using for OrientDB?

https://github.com/orientechnologies/orientdb/wiki/SQL

[yazz]

Hi Michał, You did not answer my previous questions. I need to know if you are still interested in this? Thanks Zubair

[mictadlo]

Hi Zubair, Sorry, I am busy with another project and I did not check out github. I have not used OrientDB at all yet and I would be interested to use it in few months time when I finish my current project. The query language looks shorter than RDBMS.

Thank you in advance.

Mic

[yazz]

Hi Mic, I would like to find out a bit more about your use case for OrientDB before we develop an OrientDB connection, which would cost alot of time and resources on our end. What is the reason you want to use OrientDB instead of Neo4j , as we already have Neo4j since it has a much more mature ecosystem around it, which means you could start to use it immediately too. Zubair

[yazz]

I'll have to close this as I haven't heard back from Mic in one month

[mictadlo]

I am soory for my late response. Neo4j looks indeed good and will go with it.