[orientdb] Re: Binary protocol and list( (subquery) )

2015-04-01 Thread MrFT
Still hoping for a response and the opinion of the *developers*. Trying to have a discussion about things that I find peculiar... - Why do you think it makes sense to return subqueries as 'virtual' records? What could possibly be the use-case? - Shouldn't a query return what the query

[orientdb] eigenvector in sql query

2015-04-01 Thread Giancarlo De Vito
// calculate the primary eigenvector (eigenvector centrality) of a graph m = [:]; c = 0; g.V.as('x').out.groupCount(m).loop('x'){c++ 1000} m.sort{-it.value} Above there is the gremlin statements in order to calculate eigenvector. I should use it in c# but the c# driver does not support multiple

[orientdb] Like outer join query in orientdb

2015-04-01 Thread Wharrgarbl W
Release 205 I have 2 Vertex: - ClassUser - ClassImage And 2 Edge: - Uploaded from ClassUser to ClassImage - Seen from ClassUser to ClassImage Now i want return all image what not uploaded by this user and dont seen by this user. Mu query work ok, but i think it will not work then many seen

[orientdb] Re: Performance optimizations for Graph API and transactions

2015-04-01 Thread Fábio Costa
I've done the job. What seems to be the solution is the connection pool I configured, with maximum of 50 connections. On Monday, March 30, 2015 at 10:52:23 AM UTC-3, Fábio Costa wrote: == I'm a newbie in OrientDB :D Is there any documentation regarding transactions, performance tuning and

[orientdb] Modeling hierarchies with edges or lists?

2015-04-01 Thread Fábio Costa
My use case is pretty common. I have an XML which contains data about entities and relationships among them. For each node I create a class, except from the ones that represent relationships. In this case I create edges. My question is about the hierarchy. Suppose I a structure as below. Take

[orientdb] schema reflection and extension

2015-04-01 Thread mindplay.dk
MySQL has the information_schema database, which contain the metadata for the actual database. Does OrientDB internally use a database/tables to store the schema metadata? If so, is this exposed somehow? And if so, are you allowed to tinker with this schema? What I'm thinking is, the Orient

Re: [orientdb] Customize graph visualization

2015-04-01 Thread Luigi Dell'Aquila
Hi Cameron Studio at this time does not have an internal structure for plugins and there are no plans for that, but you know, many decisions come from community needs, so if it's a common need we can think about it. At a higher level, OrientDB itself has a plugin architecture and Studio is

Re: [orientdb] Migrating to OrientDB 2.0.X, ODatabaseRecordTx is now what?

2015-04-01 Thread Emanuel
It shoudl be ODatabaseDocumentTx, by the way which listener did you implement, it may be changed something. On 25/03/15 00:57, Craig Trader wrote: We implemented several database listeners on OrientDB 1.7.8 for our application, but when I tried to migrate to OrientDB 2.0.5, I discovered that

Re: [orientdb] Apparent Deadlock when inserting data

2015-04-01 Thread Emanuel
Be aware that we have another thread that read on the same channel for handle the push request, that main thread is parked there waiting that the Async client thread get the data from the network, understand that it's not is data, an give it back to the main thread. so no deadlock there ;)

Re: [orientdb] schema reflection and extension

2015-04-01 Thread Luigi Dell'Aquila
Hi in OrientDB you can obtain schema information with select expand(classes) from metadata:schema or from java API with db.getMetadata().getSchema() and this will give you all the information about classes, properties and indexes You can also add custom metadata to classes and properties using

[orientdb] How a simple Vertex can Extend a Vertex Type in JAVA using Tinkerpop Blueprints

2015-04-01 Thread Khawar Nawab
I want to extend a VERTEXTYPE by a simple Vertex??? how can i do it? public static void main(String[] args) { final String DB = t1; final String URL = remote:localhost; final String DB_URL = URL + / + DB; final String USERNAME = root; final String PASSWORD = root;

[orientdb] Re: How a simple Vertex can Extend a Vertex Type in JAVA using Tinkerpop Blueprints

2015-04-01 Thread Colin
Hi Khawar, What is it you're trying to accomplish in the end? Thanks, -Colin Orient Technologies The Company behind OrientDB On Wednesday, April 1, 2015 at 8:51:58 AM UTC-5, Khawar Nawab wrote: I want to extend a VERTEXTYPE by a simple Vertex??? how can i do it? public static void

Re: [orientdb] Customize graph visualization

2015-04-01 Thread Luigi Dell'Aquila
You're welcome ;-) 2015-04-01 16:51 GMT+02:00 Cameron Hunt cameron.h...@metanomy.org: Luigi, I should have waited to post until I thought about Studio being a plugin itself! I'll start with a separate copy and experiment, and report back my results. Thanks again for responding to what

[orientdb] Best practices examples for Timeline, Timeseries, Multi-Level trees wanted

2015-04-01 Thread Arne Pfeilsticker
I evaluated Neo4j for weeks, read several books, watched videos, and so on - and I have to say: I like it very much. - But then OrientDB crossed my way, caught me within a day+night, and I think I'll go with OrientDB. I have several Mulit-Level Trees such as timeline, products, agents, places

Re: [orientdb] Customize graph visualization

2015-04-01 Thread Cameron Hunt
Luigi, I should have waited to post until I thought about Studio being a plugin itself! I'll start with a separate copy and experiment, and report back my results. Thanks again for responding to what should have been an RTFM question :) On Wednesday, April 1, 2015 at 7:52:10 AM UTC-4, Luigi

Re: [orientdb] examples of ETL json, any way to create more than one type of vertex from a single source file

2015-04-01 Thread sck2015
hi Lvc, yes, I had looked at this. I think that you can only have one type (or class) of vertex from a single source file from the examples I've seen... is it possible to have more than joinfield name on an edge (so create an edge that joins on postid as well as some other attribute common to

[orientdb] Re: Binary protocol and list( (subquery) )

2015-04-01 Thread Lvc@
Hi, Any result from a select with projection, provides temporary RIDs. This is because the result is always a document (json), but not the record on database, but an interpolation. If you're interesting on rid, use @rid in projection. Lvc@ On Wednesday, 1 April 2015 07:16:41 UTC-3, MrFT

Re: [orientdb] examples of ETL json, any way to create more than one type of vertex from a single source file

2015-04-01 Thread Luca Garulli
Hi Sonu, Have you looked at edge transformer? It does exactly what you need. Take a look at: http://www.orientechnologies.com/docs/last/Import-from-CSV-to-a-Graph.html Lvc@ On 30 March 2015 at 15:58, sck2015 sonukhullar@gmail.com wrote: Hi, I am new to orientDB but have been perusing

[orientdb] Re: Question on querying lucene geospatial index by traversing graph

2015-04-01 Thread Tom
Hi, I have exactly the same problem. Is there solution for that? I'm using OrientDB 2.0.5 In database, nodes are related as Country - Region - City - Location where Location contains columns lat and lon When I try to select select from ( select

Re: [orientdb] Re: Question on querying lucene geospatial index by traversing graph

2015-04-01 Thread Enrico Risa
Hi Tom can you paste here the explain of this query? select from ( select expand(out('IN_REGION').out('IN_CITY')[category=1]) from #32:3) where [lat, lon, $spatial] NEAR [44.9060941, 12.0265446, {maxDistance:15}] 2015-04-01 20:38 GMT+02:00 Tom tomislav.milko...@gmail.com: Hi, I

[orientdb] Custom group-by function

2015-04-01 Thread michael jones
Is there support in orientdb that support group by/ aggregate data function dint see any examples in there http://www.orientechnologies.com/docs/last/Functions.html select user_id, my_agg_function(*) from Class group by user_id; my_agg_function(Object[] parameters) { body } -- ---

[orientdb] OrientDB token expiration

2015-04-01 Thread David Carr
I'm running orientdb server 2.0.5 with Ostico/PhpOrient and am storing the orientdb connection token in the user's php web server session so that we don't have to authenticate against orientdb using username/password with every pageview. It all works well until too much time elapses between