OrientR - A simple REST API wrapper for R

[retrography]

Hi Everyone,

For those of you who use OrientDB and R together: I have written a tiny REST API wrapper that helps you run queries against OrientDB. It uses the jsonlite package to convert the JSON response into a R DataFrame, strips metadata fields returned along with the data, and converts RIDs and Dates into numbers and DateTime variables. This is the minimum I needed to get my project off the ground, but don't hesitate to fork/pull request if you need additional functionalities. 

Here is the github address: https://github.com/retrography/OrientR

Cheers,

Mahmood

[Luca Olivari]

Hi Mahmood,

Thanks for taking the time to contribute to OrientDB! That's really appreciated... I've just tweeted a link to your github project. If you need help with your project send me a note.

Regards,

Luca

[retrography]

Hi Luca,

I have one question:

OrientDB returns a @fieldTypes field along with the response JSONs that contains information on the data types of different fields. I use that field for automatic format conversions when possible. 

I just want to know where I can find the list of data type codes that OrientDB uses.

I have found these by now:

"g": Lists/Sets/Collections

"x": RIDs

"t": Date/Time/DateTime

"z": Anything resulted from a traversal

Are these correct, and are there any others?

Btw, I am updating the package as it seems to work pretty well, and so it looks like it is worthy of the time I spend on it.

Cheers,

Mahmood

[Luca Garulli]

Hi Mahmood,

Thanks for your project, I'd like to include it in OrientDB drivers. 

About your question take a look at:

http://orientdb.com/docs/last/orientdb.wiki/OrientDB-REST.html#json-data-type-handling-and-schema-less-mode

Best Regards,

Founder & CEO

OrientDB

--

---
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.

[retrography]

Thank you Luca(s)!

For now the driver only has a query interface (runQuery function), and I am testing it in my own project. It looks robust, no obvious bug. 

I will write a couple of pages of help for runQuery and will add an interface to execute commands (exeCommand function) soon. 

Please let me know if you include it in your driver list. If you do so, I may have to include some test units in the package so we make sure people don't get bad surprises.

Best,

Mahmood

[Luca Garulli]

Hi Mahmood,

I already included it ;-)

The best would be having:

• A README.md file with the documentation about installing, usage and current limitations
  
• Test cases, in your case would be only connect/disconnect/query, right?
• A few cool examples

Best Regards,

Luca Garulli

Founder & CEO

OrientDB

[Mahmood Shafeie Zargar]

Hi Again,

Actually, there is no connect and disconnect. "getDB" simply helps the user create a connection string and then the user has to pass the connection string to each runQuery (that's how other drivers like RNeo4j have handled it as well).

On the other hand the getQuery function takes many arguments, that have to be tested to make sure they work smoothly with each other. That would be the main test.

The README.md file is already there. Will add a couple of examples for the sake of clarity. Also, R has this internal documentation/help system that everyone consults at dev time, and I will try to complete that today as well.

Cheers,

Mah

[Luca Garulli]

Hi Mah,

Sounds good. Keep us posted on your updates.

Best Regards,

Luca Garulli

Founder & CEO

OrientDB