[orientdb] Re: how to calculate delta using subquery

2014-08-05 Thread M B
So I got this to work with a different query using eval(). Is this the right way to do this? String query = "select key, received as previous, $temp[0].current as current, $temp[0].delta as delta from Activity, let $temp = (select received as current, eval('received - $parent.current.receive

[orientdb] how to calculate delta using subquery

2014-08-05 Thread M B
I'm trying to calculate the delta value between two rows for one particular column. OrientDB doesn't support joins as far as I can tell so I'm trying to accomplish same with sub queries, but I get results i don't understand. Can someone suggest proper way to accomplish this. package

[orientdb] Groupby is broken on multiple fields

2014-08-05 Thread moksh n
Using orient 1.7.7 Thanks -- --- 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-database+unsubscr...@googlegroups.com. For more options, visit https://groups.

Re: [orientdb] Is there any java utility class which converts a pojo into ODocument reflectively

2014-08-05 Thread moksh n
Thanks Lvc. Will Look into it. Is there a similar class available to convert from ODocument to an object of given type. I'm using ODocument API. That's why I was looking into this. Thanks On Tuesday, August 5, 2014 7:36:28 AM UTC-7, Lvc@ wrote: > > Hi, > Take a look at OObjectSerializerHelperDoc

Re: [orientdb] How do you start a transaction, the wiki is wrong or method in the wiki is wrong

2014-08-05 Thread Luca Garulli
Hi Alexandre, "local" is deprecated and will be removed in 2.0. Use plocal instead. Lvc@ On 5 August 2014 17:07, alexander anguiano wrote: > In 1.7.7 only the plocal database works with the graph.shutdown. If you > use local, the graph.shutdown will hang. > > On Tuesday, August 5, 2014 9:42:

Re: [orientdb] Re: Embedded mode?

2014-08-05 Thread Luca Garulli
Hi, We store all the information in more files under the same directory. Lvc@ On 5 August 2014 21:30, scala solist wrote: > > > On Monday, March 31, 2014 8:44:11 PM UTC+4, Michael Campbell wrote: >> >> Anyone using embedded mode for orientdb? >> > > I'd like to do so. I searched for a good to

[orientdb] Re: Embedded mode?

2014-08-05 Thread scala solist
On Monday, March 31, 2014 8:44:11 PM UTC+4, Michael Campbell wrote: > > Anyone using embedded mode for orientdb? > I'd like to do so. I searched for a good tools to store information in organized way. And I'm more interested in data storing and easy usage for java application and care less ab

Re: [orientdb] Javascript visualization

2014-08-05 Thread Leny Turmel
Thank you for all this information, Dexter. Very very interesting. I will look into details at your project too, by individual curiosity :) Le mardi 5 août 2014 18:04:05 UTC+2, Dexter Pratt a écrit : > > Hi Leny, > > Our project - NDEx - at UCSD is using OrientDB for its backend data store > of

Re: [orientdb] Javascript visualization

2014-08-05 Thread Dexter Pratt
Hi Leny, Our project - NDEx - at UCSD is using OrientDB for its backend data store of biological networks. (see www.ndexbio.org for background on what we are doing) We were initially using OrientDB via tinker pop and SQL but we have eliminated tinker pop to simplify and streamline our access.

Re: [orientdb] Javascript visualization

2014-08-05 Thread Leny Turmel
HI Dexter, Thank you for your answer. I have never heard about this JS library. i am going to take a look to Cytoscape right now. Did you personaly use Cytoscape? Do you have any feedback about integrating OrientDB and Cytoscape? Thank you very much for your help. Leny Le mardi 5 août 2014 17

Re: [orientdb] Javascript visualization

2014-08-05 Thread Dexter Pratt
Another one to consider is cytoscape.js Dexter On Aug 5, 2014, at 6:52 AM, Leny Turmel wrote: > Hi all, > > I am searching for a solution to visualize dynamically an OrientDB graph in a > web application. > Because I want a dynamic visualization solution, I do want to a solution that > impl

Re: [orientdb] New guice integration module released

2014-08-05 Thread xvik
Hi Luca! Wow! it was fast :) .. Thank you very much! For some time i will use it myself, so my own usage will drive future improvements. And, of course, i will respond to all reported issues (maybe feature requests). вторник, 5 августа 2014 г., 21:30:04 UTC+7 пользователь Lvc@ написал: > > Hi

Re: [orientdb] How do you start a transaction, the wiki is wrong or method in the wiki is wrong

2014-08-05 Thread alexander anguiano
In 1.7.7 only the plocal database works with the graph.shutdown. If you use local, the graph.shutdown will hang. On Tuesday, August 5, 2014 9:42:48 AM UTC-5, Lvc@ wrote: > > Hi Alexander, > Starting from Blueprints 2.5.x, the OrientDB Graph API, the begin() has > been removed because transact

Re: [orientdb] How do you start a transaction, the wiki is wrong or method in the wiki is wrong

2014-08-05 Thread Luca Garulli
Hi Alexander, Starting from Blueprints 2.5.x, the OrientDB Graph API, the begin() has been removed because transactions are always implicit: https://github.com/orientechnologies/orientdb/wiki/Graph-Database-Tinkerpop#transactions Lvc@ On 4 August 2014 18:47, alexander anguiano wrote: > I'm u

Re: [orientdb] Is there any java utility class which converts a pojo into ODocument reflectively

2014-08-05 Thread Luca Garulli
Hi, Take a look at OObjectSerializerHelperDocument class. Lvc@ On 5 August 2014 02:14, moksh n wrote: > Is there any java utility class which converts a pojo into ODocument > reflectively. > Any pointers would be helpful. > > > Thanks > > -- > > --- > You received this message because you ar

Re: [orientdb] Re: min() works surprisingly long

2014-08-05 Thread Luca Garulli
Hi Vladimir, I've created a new issue for this.: https://github.com/orientechnologies/orientdb/issues/2655 The Fabrizio's workaround is correct. Lvc@ On 5 August 2014 10:48, Vladimir Ziankevich wrote: > Its interesting that min and max are not optimized. Thank you Fabrizio. > > понедельник,

Re: [orientdb] New guice integration module released

2014-08-05 Thread Luca Garulli
Hi Vyacheslav, this is very cool! I've added it into Plugins: https://github.com/orientechnologies/orientdb/wiki/Plugins Please keep us updated about the status of the projects and roadmap. Thanks, Lvc@ On 5 August 2014 13:15, xvik wrote: > Hello everyone! > > Just published release of new

[orientdb] Javascript visualization

2014-08-05 Thread Leny Turmel
Hi all, I am searching for a solution to visualize dynamically an OrientDB graph in a web application. Because I want a dynamic visualization solution, I do want to a solution that implies to write and load a file (like GEXF files). I do not need to display huge graphs (so the performance is no

[orientdb] Re: Problem querying by date on DB created using Tinkerpop

2014-08-05 Thread Seamus Minogue
Forget about this. PEBKAC. Works fine, problem with which database was being connected to. On Tuesday, August 5, 2014 9:12:44 AM UTC-4, Seamus Minogue wrote: > > I have a database I created and populated using the tinkerpop blueprints > API. > > id is an Integer > date is a java.Util.Date >

[orientdb] Problem querying by date on DB created using Tinkerpop

2014-08-05 Thread Seamus Minogue
I have a database I created and populated using the tinkerpop blueprints API. id is an Integer date is a java.Util.Date Vertex vip = graph.addVertex("class:UserDay", "ID", id, "DATE", date); When I wish to query the database I am using straight orient SQL becuase I have noticed it is MUCH

[orientdb] New guice integration module released

2014-08-05 Thread xvik
Hello everyone! Just published release of new guice integration module https://github.com/xvik/guice-persist-orient Main idea: single database could be used with any connection type: as document, object or graph (even within the same unit of work). Inside: module maintains 3 (up to, depending

[orientdb] Re: min() works surprisingly long

2014-08-05 Thread Vladimir Ziankevich
Its interesting that min and max are not optimized. Thank you Fabrizio. понедельник, 4 августа 2014 г., 21:56:21 UTC+1 пользователь Fabrizio Fortino написал: > > Hi Vladimir, > > AFAIK min and max functions are not optimised for this kind of cases. > As a workaround you could try this > > select