R: [orientdb] Is there a concept of calculated properties?

2013-12-28 Thread Luigi Dell'Aquila
+1 for this, (Luca, you know why ;-) ) -- Da: Greg mccarv...@gmail.com Inviato: 28/12/2013 18.11 A: orient-database@googlegroups.com Oggetto: [orientdb] Is there a concept of calculated properties? Is there such a concept in OrientDB as calculated properties? For

Re: [orientdb] Is there a concept of calculated properties?

2013-12-30 Thread Luigi Dell'Aquila
Hi all, I thought about it for a long time, it's not a trivial problem. For me calculated properties are just a little fragment of something bigger: considering that we have classes, hierarchies and polymorphism, we could implement methods on classes (not only getters/setters, but also complex

Re: [orientdb] Server Side Function

2014-02-19 Thread Luigi Dell'Aquila
Hi Thomas, test[0] is actually an ODocument (a Java object). Just try this: test[0].field(name) Luigi 2014-02-19 3:23 GMT+01:00 Thomas Kennedy tomais.kenn...@gmail.com: Hi, I am using the 1.7-rc1 version and have attempted to access an element on JSON object that is returned and receive

Re: [orientdb] Server Side Function

2014-02-19 Thread Luigi Dell'Aquila
enough in the documentation. Going by the documentation I would of thought that the return type was a Javascript JSON object. Can you point me to any documentation on this? Much appreciated On Wednesday, 19 February 2014 08:12:56 UTC, Luigi Dell'Aquila wrote: Hi Thomas, test[0] is actually

Re: [orientdb] We've a new committer: Luigi Dell'Aquila!

2014-04-05 Thread Luigi Dell'Aquila
;) On 04/04/14 21:03, Luca Garulli wrote: Hi all, I'm glad to announce Luigi Dell'Aquila as new committer of OrientDB Project. Maybe some of you already know Luigi as a OrientDB Academy Teacher. Luigi's main contribution are about performance tuning and API improvement. Welcome aboard

Re: [orientdb] Re: OrientDB and Grails

2014-08-11 Thread Luigi Dell'Aquila
Hi, Thank you very much for your feedback, I'm in charge of this task and I'm about to start it. I'm not a parser expert, so I'm still studying all these frameworks (I did something with JavaCC in the past, but nothing very complex). My first impression is that JavaCC is very good for low level

Re: [orientdb] Re: OrientDB and Grails

2014-08-12 Thread Luigi Dell'Aquila
working example. Take care! Fidel H Viegas On Mon, Aug 11, 2014 at 10:24 AM, Luigi Dell'Aquila luigi.dellaqu...@gmail.com wrote: Hi, Thank you very much for your feedback, I'm in charge of this task and I'm about to start it. I'm not a parser expert, so I'm still studying all

Re: [orientdb] Data persistence with in-memory OrientDB server

2014-10-08 Thread Luigi Dell'Aquila
receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- Luigi Dell'Aquila Orient Technologies LTD -- --- You received this message because you are subscribed to the Google Groups OrientDB group

Re: [orientdb] Grouping a result set with fields from a traversing class.

2014-10-13 Thread Luigi Dell'Aquila
receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- Luigi Dell'Aquila Orient Technologies LTD -- --- You received this message because you are subscribed to the Google Groups OrientDB group

Re: [orientdb] Reusing a Parameter query? No Result?

2014-10-16 Thread Luigi Dell'Aquila
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.google.com/d/optout. -- Luigi Dell'Aquila Orient Technologies LTD

Re: [orientdb] SQL query performance with OR in the WHERE clause

2014-10-21 Thread Luigi Dell'Aquila
Hi, what version of OrientDB are you using? We had two issues related to OR operators and index usage: https://github.com/orientechnologies/orientdb/issues/2898 https://github.com/orientechnologies/orientdb/issues/2893 and we fixed them some days ago. Could you try again on latest SNAPSHOT?

Re: [orientdb] SQL query performance with OR in the WHERE clause

2014-10-22 Thread Luigi Dell'Aquila
the issue in the OrientDB 2.0-M2 community edition. Is this the latest SNAPSHOT? On Tuesday, October 21, 2014 2:23:04 AM UTC-5, Luigi Dell'Aquila wrote: Hi, what version of OrientDB are you using? We had two issues related to OR operators and index usage: https://github.com/orientechnologies

Re: [orientdb] Migration document management database to OriendDB, does it make sense?

2014-10-22 Thread Luigi Dell'Aquila
Hi Bojan in general IMHO all this makes sense. I guess edge creation speed can be improved with some tuning or code tricks, but I should see your import code.. Anyway, if you decided to go with links and you need 1:n or n:n, you can use LINKLIST or LINKSET properties instead. About procedure

Re: [orientdb] Migration document management database to OriendDB, does it make sense?

2014-10-22 Thread Luigi Dell'Aquila
), BookAuthor); edge.setProperty(); } rs.close(); statement.close(); graph.commit(); I used both OrientGraph and OrientGraphNoTx but I didn't see a big difference On Wednesday, 22 October 2014 16:39:33 UTC+2, Luigi Dell'Aquila wrote

Re: [orientdb] Prepared statements and linked maps..

2014-10-22 Thread Luigi Dell'Aquila
/optout. -- Luigi Dell'Aquila Orient Technologies LTD -- --- 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

Re: [orientdb] OrientDB operations questions

2014-10-29 Thread Luigi Dell'Aquila
Hi Santosh I'll answer your questions below: 1. I was reading the documentation for distributed database on multiple servers here http://www.orientechnologies.com/docs/last/orientdb.wiki/Distributed-Configuration.html. I see that we need to configure several files like

Re: [orientdb] Re: classcastexception when mixing object API and graph API

2014-11-02 Thread Luigi Dell'Aquila
Hi Wouter, I think it's an issue of Object database implementation, we can fix it quickly just testing database type in OObjectLazySet.getDatabase() and wrapping it in an OObjectDatabaseTx instance if it's a different type. Could you please open an issue about this? thanks Luigi 2014-11-03

Re: [orientdb] Re: Query over restful API returns invalid JSON ?

2014-11-03 Thread Luigi Dell'Aquila
Hi, this could be related to this https://github.com/orientechnologies/orientdb/issues/2845 I'm working to fix it Luigi 2014-11-03 13:37 GMT+01:00 MrFT frederik.til...@vsko.be: I used the laest SNAPSHOT orientdb-community-2.0-20141031.225603-341-distribution.zip

Re: [orientdb] OrientDB operations questions

2014-11-04 Thread Luigi Dell'Aquila
it though. Am I missing something in the release 2 M2 version ? Also, are you planning to have a backup to file system ( not snapshot) and without blocking writes in a future release ? Regards, Santosh On Wednesday, October 29, 2014 4:02:06 AM UTC-7, Luigi Dell'Aquila wrote: Hi Santosh

Re: [orientdb] LET ... not working

2014-11-04 Thread Luigi Dell'Aquila
Hi Frederik, this kind of issues is related to some legacy code in current query parser implementation. We are completely rewriting it, so it will be fixed in 2.1. If you want you can open an issue about this, I'll take care of it. About third query, I tried it in Studio with a fresh

Re: [orientdb] Re: Java API - get the last out_edge of a certain type

2014-11-05 Thread Luigi Dell'Aquila
Hi Stefan, I think this can help you http://www.orientechnologies.com/docs/last/orientdb.wiki/Graph-Database-Tinkerpop.html#ordered-edges Luigi 2014-11-05 10:35 GMT+01:00 ste...@activitystream.com: bump ... again On Tuesday, 4 November 2014 08:10:37 UTC, ste...@activitystream.com wrote:

Re: [orientdb] Re: Creating server side functions

2014-11-06 Thread Luigi Dell'Aquila
Hi Kristoffer, Invoking server side functions from inside other functions should be straightforward. Could you post some of your code? Maybe we can help you better that way. Luigi 2014-11-06 13:06 GMT+01:00 BojanV bboojja...@gmail.com: Did you try with sql batch?

Re: [orientdb] Re: Creating server side functions

2014-11-06 Thread Luigi Dell'Aquila
:10 UTC+1 torsdag 6. november 2014 skrev Luigi Dell'Aquila følgende: Hi Kristoffer, Of course you can use this approach, this is not bad practice in general, but sometimes you can find easier solutions to do that. Here are a couple of examples, they all work fine for me. I hope you can find

Re: [orientdb] New to Graphs - best schema for data collection?

2014-11-07 Thread Luigi Dell'Aquila
Hi Mark, one or two years ago I tested OrientDB on Raspberry PI and it worked fine (of course the performance was not the same as on my laptop, but it was more than acceptable). At that time I used Java8 alpha for ARM and that gave me very good results. If what you are interested in is a time

Re: [orientdb] Re: CSV Field to collection field

2014-11-12 Thread Luigi Dell'Aquila
Hi, the best thing to do this should be something like this: update myClass set columnB = columnA.split(,) but unfortunately it's NOT supported at this time. As a work around, you can define your own split() function like this - two parameters: inputString and separator - this function body:

Re: [orientdb] Querying OrientDB documents slower than expected - advise needed

2014-11-14 Thread Luigi Dell'Aquila
Hi Jan, in this use case you will not have big advantage from typical NoSQL features like index free adjacency (that means fast traversal) or dynamic schema management. You are actually using OrientDB as a relational db. Anyway performance you are having is definitely too slow! I suggest you to

Re: [orientdb] Querying OrientDB documents slower than expected - advise needed

2014-11-14 Thread Luigi Dell'Aquila
ah, for cases where you know that you don't need range queries I suggest you to use OClass.INDEX_TYPE.NOTUNIQUE_HASH_INDEX, it's much much faster! Luigi 2014-11-14 10:04 GMT+01:00 Luigi Dell'Aquila luigi.dellaqu...@gmail.com: Hi Jan, in this use case you will not have big advantage from

Re: [orientdb] Re: installing OrientDB in a non controlled environment

2014-11-14 Thread Luigi Dell'Aquila
Hi Charles, at this moment there is no built-in procedure to encrypt root password, anyway IMHO this problem can be bypassed with some simple modifications. The real problem is another one: the DB files are not encrypted in any way, so if your customer copies the orient/databases/ directory on

Re: [orientdb] java.lang.IllegalStateException: Missing closed string character: ''' with function

2014-11-24 Thread Luigi Dell'Aquila
Hi Luca, this is clearly a bug, could you please report it in OrientDB issue tracker? https://github.com/orientechnologies/orientdb/issues We will fix it ASAP thanks Luigi 2014-11-24 18:32 GMT+01:00 l...@emaxsrl.com: Hello, I'm using OrientDB version : 2.0-M3. I created a test function

[orientdb] Re: Limit the # of traversed objects returned: fetchPlan VS traverse VS select?

2014-11-25 Thread Luigi Dell'Aquila
Hi Simon, you can do something like this select set($comments[0], $comments[1], $comments[2]) from SOME_POST_ID let $comments = sort(out('PostHasComment')) or but edges are not guaranteed to be sorted, so you have to write your own sort() function. If you are using M3 or earlier, function

Re: [orientdb] java.lang.IllegalStateException: Missing closed string character: ''' with function

2014-11-25 Thread Luigi Dell'Aquila
Thanks a lot Luigi 2014-11-25 8:25 GMT+01:00 l...@emaxsrl.com: Done! https://github.com/orientechnologies/orientdb/issues/3094 Il giorno lunedì 24 novembre 2014 18:52:05 UTC+1, Luigi Dell'Aquila ha scritto: Hi Luca, this is clearly a bug, could you please report it in OrientDB issue

Re: [orientdb] Re: Limit the # of traversed objects returned: fetchPlan VS traverse VS select?

2014-11-25 Thread Luigi Dell'Aquila
,percentile,median,variance,difference,first]` On Tuesday, November 25, 2014 3:26:46 AM UTC-5, Luigi Dell'Aquila wrote: Hi Simon, you can do something like this select set($comments[0], $comments[1], $comments[2]) from SOME_POST_ID let $comments = sort(out('PostHasComment')) or but edges

Re: [orientdb] Re: Limit the # of traversed objects returned: fetchPlan VS traverse VS select?

2014-11-25 Thread Luigi Dell'Aquila
, Luigi Dell'Aquila wrote: Hi Simon, my mistake, I was not clear at all, the sort() function is not a built-in function, my proposal was to implement your own function called sort() in javascript and use it in the query Luigi 2014-11-25 16:55 GMT+01:00 Simon L si...@pumpup.co: Thanks

Re: [orientdb] Copy a Document

2014-11-25 Thread Luigi Dell'Aquila
Hi Stefan, try to remove parentheses from your query, like this: insert into GermanyClient from select from Client where country = 'Germany' current SQL parser implementation sometimes is not so friendly, we are completely rewriting it and the new one will be released in 2.1 About the fromMap,

Re: [orientdb] Assign label to Lightweight Edge from command line

2014-11-25 Thread Luigi Dell'Aquila
Hi Riccardo, what TinkerPop calls labels is represented by OrientDB classes. You can create a lightweight edge of a particular class with this syntax: CREATE EDGE MyLabel FROM #14:1 TO #14:0 Of course the class MyLabel has to exist and has to extend E If you use the SET labelName = value, the

Re: [orientdb] Re: Problem with local clusters in distributed mode

2014-12-15 Thread Luigi Dell'Aquila
Hi Stéphane, I suggest you to wait a few hours, as OrientDB RC1 will be released shortly Luigi 2014-12-15 17:01 GMT+01:00 Stéphane Schild stephane.sch...@gmail.com: Hello, You're right, I should not have supposed that this version was stable. However, I need to evaluate OrientDB for my

Re: [orientdb] i can't find how to list all databases in java..

2014-12-16 Thread Luigi Dell'Aquila
+01:00 Ankit Jain foran...@gmail.com: we can find out that from jar file..can u tell in which jar it is?? On Monday, 15 December 2014 19:58:44 UTC+5:30, Luigi Dell'Aquila wrote: Hi, OServetAdmin is in package com.orientechnologies.orient.client.remote Apparently all the client package

Re: [orientdb] i can't find how to list all databases in java..

2014-12-17 Thread Luigi Dell'Aquila
...? On Wed, Dec 17, 2014 at 12:25 PM, Ankit Jain foranki...@gmail.com wrote: ok.. On Wed, Dec 17, 2014 at 12:22 PM, Ankit Jain foranki...@gmail.com wrote: ok. On Wed, Dec 17, 2014 at 12:21 PM, Luigi Dell'Aquila luigi.dellaqu...@gmail.com wrote: Hi, sorry, I saw this email only now

Re: [orientdb] [2.0-RC1] Problem with class named Content

2014-12-18 Thread Luigi Dell'Aquila
Hi Stéphane, content is a reserved word in OrientDB SQL syntax, current parser implementation does not complain about it (while it should), but final result is unpredictable, like this. The new parser implementation is more strict and will report an error at parse time. Strict query syntax

Re: [orientdb] Re: Lightweight Edges vs Other Edges

2014-12-18 Thread Luigi Dell'Aquila
Hi Sajal, lightweight edges are still available and the alter database command is the right way to enable them, so if you are not able to create one maybe there is an error in your code or an issue in the release. Could you provide a snippet of code (or better, a test case) to replicate the

Re: [orientdb] case clause?

2014-12-19 Thread Luigi Dell'Aquila
Hi Andrei, In OrientDB you can use the if() function to do what you need. I just added it to the documentation, please check this wiki page. https://github.com/orientechnologies/orientdb/wiki/SQL-Functions Soon it will also be in the official Docs page Luigi 2014-12-19 8:51 GMT+01:00 Andrei

Re: [orientdb] Studio graph behavior changed by not showing direct relations straight away

2015-01-26 Thread Luigi Dell'Aquila
to that ? Because from what I can see, I've done nothing different from Rc1 and RC2 to final1. On Monday, January 26, 2015 at 12:05:27 PM UTC, Luigi Dell'Aquila wrote: Hi, this must be because of disabled lightweight vertices. In Graph Studio tab only fetched records and their neighbors

Re: [orientdb] Insertion into Graphs using txt file

2015-02-04 Thread Luigi Dell'Aquila
Hi Arinath, if it's just a one-shot batch insert, you can write a simple Java program and use OGraphBatchInsertBasic class, that is specifically designed for this simple use case. Otherwise you could think about using OrientDB ETL and define a simple importer from CSV, see

Re: [orientdb] Strict Schema Mode : Adding and removing properties

2015-02-04 Thread Luigi Dell'Aquila
Hi, current implementation of schema manipulation is not so strict, and especially is not related to already existing data, but only to new operations. We know this is an issue and we are addressing it, you will find important changes about this in next releases Luigi 2015-02-03 18:28

Re: [orientdb] find_or_create in OrientDB?

2015-02-04 Thread Luigi Dell'Aquila
Hi Artem, have you tried with UPSERT? Here you can find all the references: http://www.orientechnologies.com/docs/last/orientdb.wiki/SQL-Update.html Regards Luigi 2015-02-04 13:25 GMT+01:00 Artem Shoobovych shybovy...@gmail.com: Hi there! Lately, I've been playing with OrientDB of 1.7.10

Re: [orientdb] UnsupportedOperationException When Creating in Memory Distributed Database

2015-02-06 Thread Luigi Dell'Aquila
Hi Andy, This is a known issue, you can find all the details here: https://github.com/orientechnologies/orientdb/issues/3203 Luigi 2015-02-05 16:58 GMT+01:00 dakota.pric...@gmail.com: Hello, I am unable to create an in MEMORY distributed database due to the following exception:

Re: [orientdb] Bulk data load Performance Benchmark and Tuning

2015-02-18 Thread Luigi Dell'Aquila
Hi Shivanandan, the easy way to go faster is using plocal instead of remote, but I don't know if in your case it's possible (other instances OrientDB have to be shut down for the time ETL works...) Luigi 2015-02-19 7:19 GMT+01:00 Shivanandan Gupta shivnandangu...@gmail.com: Hi All, I tried

Re: [orientdb] Bulk data load Performance Benchmark and Tuning

2015-02-19 Thread Luigi Dell'Aquila
, I tried doing a plocal (create a DB as plocal ? ) can you please help me how to go with it? I am a newbei to orientdb. We are trying to have a data model as DWH like facts and dimensions in orientdb. Thanks, Shivanandan Gupta On Thursday, 19 February 2015 13:26:58 UTC+5:30, Luigi

Re: [orientdb] Bulk data load Performance Benchmark and Tuning

2015-02-19 Thread Luigi Dell'Aquila
2015 14:40:04 UTC+5:30, Luigi Dell'Aquila wrote: Hi Shivanandan, you can just replace this loader: { orientdb: { dbURL: remote:localhost/databases/indb, dbUser: root, dbPassword: root, dbAutoCreate: true, tx: false, batchCommit: 1, dbType: graph

Re: [orientdb] Re: Get available edge types for a vertex - Java API

2015-02-20 Thread Luigi Dell'Aquila
Hi Stefan, there is no explicit support to this (you can open a feature request on the issue tracker if you want), but there is a work-around to obtain this information: OrientVertex v = ... ODocument doc = v.getRecord(); String fieldNames = doc.fieldNames(); ListString edgeClassNames = new

Re: [orientdb] Business key vs RID

2015-01-06 Thread Luigi Dell'Aquila
Hi George, link traversal is O(1) operation because the RID is like a physical pointer to data. Using UUID would mean relying on an index to find the RID corresponding to the UUID. SBTree index you will give you O(logN) performance. HashIndex will give you a near O(1) performance in the average

Re: [orientdb] Restrict ShortestPath and Dijkstra to a specific Edge class

2015-02-09 Thread Luigi Dell'Aquila
Hi Georg, in current implementation it's not possible. Anyway Dijkstra and ShortestPath functions are quite simple (links to the source code below), you could just implement your own version starting from them and (why not?) send a pull request and become OrientDB contributor.

Re: [orientdb] Clustering

2015-02-11 Thread Luigi Dell'Aquila
by Luca, http://stackoverflow.com/questions/22606111/orientdb-problems-with-clusters-concept. I thought I might be missing out something. On Wednesday, February 11, 2015 at 5:42:27 PM UTC+8, Luigi Dell'Aquila wrote: Hi Goh, That post is really misleading... In OrientDB you can define multiple

Re: [orientdb] help query edge

2015-02-11 Thread Luigi Dell'Aquila
Hi Renzo, the first query should be something like select expand(inE('owner')[color ='red'].outV()) from car where name = 'Ferrari' The second one is just select out.name as ownerName, color, in.name as carName from owner Luigi 2015-02-10 22:08 GMT+01:00 Renzo Ludeña

Re: [orientdb] Clustering

2015-02-11 Thread Luigi Dell'Aquila
Hi Goh, That post is really misleading... In OrientDB you can define multiple clusters per class, and all the sharding architecture is based on that. To have a better idea of this I suggest you to check the following links

Re: [orientdb] Restrict ShortestPath and Dijkstra to a specific Edge class

2015-02-10 Thread Luigi Dell'Aquila
the first path ? It seems like a bit of a hack, don't you think ? :( I'm using OrientDB 2.0.1 BTW. Thanks ! On Tuesday, February 10, 2015 at 8:53:58 AM UTC+1, Luigi Dell'Aquila wrote: Hi Georg, in current implementation it's not possible. Anyway Dijkstra and ShortestPath functions

[orientdb] A taste of OrientDB 2.1

2015-02-16 Thread Luigi Dell'Aquila
TO MAKE IT PERFECT!!! Thanks Luigi -- Luigi Dell'Aquila Orient Technologies LTD -- --- 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

Re: [orientdb] Re: Schema advantage ?

2015-01-08 Thread Luigi Dell'Aquila
Hi, with current version (as Keith said) schema-defined fields are more compact in terms of disk space. In next releases you will also have additional advantages in terms of query speed. But the most significant difference is that defining properties you can - enforce constraints on fields (min,

Re: [orientdb] Determine record owner?

2015-03-18 Thread Luigi Dell'Aquila
V and E? Are there special powers associated with V and E that I would lose in such a case? Thanks very much! Patrick On Tuesday, March 17, 2015 at 9:50:35 AM UTC-6, Luigi Dell'Aquila wrote: Hi Rob, if your class extends ORestricted, the owner is tracked in one of the following fields

Re: [orientdb] Determine record owner?

2015-03-19 Thread Luigi Dell'Aquila
to implement hierarchical access to data so that field has more than just the owner. It has the owner and all of the owner's parents so not an easy way to determine which in fact is the owner of the data. Any other way I can get the owner? On Tuesday, March 17, 2015 at 8:50:35 AM UTC-7, Luigi

Re: [orientdb] Time series query

2015-03-16 Thread Luigi Dell'Aquila
Hi Vadim, I don't know how many items you expect in your db, but I think your data representation could take you to very expensive queries... I suggest you to take a look at this, maybe you can pick some ideas http://www.slideshare.net/LuigiDellAquila/orientdb-time-representation Luigi

Re: [orientdb] Determine record owner?

2015-03-17 Thread Luigi Dell'Aquila
Hi Rob, if your class extends ORestricted, the owner is tracked in one of the following fields: _allow _allowRead _allowUpdate _allowDelete 2015-03-17 16:39 GMT+01:00 Rob Gratz gratz@gmail.com: Is there a way to obtain which user created or owns a record? -- --- You received this

Re: [orientdb] Create distribution from maven repository

2015-03-09 Thread Luigi Dell'Aquila
Hi Alexander, AFAIK you cannot create a full distribution from maven repositories. If you want a particular Git branch or tag, I suggest you to clone it locally (see https://github.com/orientechnologies/orientdb ) and then launch ant clean install you will have a full distribution in

Re: [orientdb] Lightweight vs Standard/Regular Edges

2015-03-12 Thread Luigi Dell'Aquila
Hi Jeffrey, I think you looked at this: http://www.orientechnologies.com/docs/last/orientdb.wiki/Lightweight-Edges.html In terms of performance lightweight edges are better, but they are harder to manage because: - you cannot refer a lightweight edge by its RID (a lightweight edge is not a

Re: [orientdb] Re: What is the fastest way to save 10M edges in OrientDB?

2015-03-13 Thread Luigi Dell'Aquila
Hi Joao, it depends on how your source data are represented. If you have sequential integer/long keys for vertexes, you can use OGraphBatchInsert class Luigi 2015-03-13 10:30 GMT+01:00 Vitor Enes Duarte vitorenesdua...@gmail.com: graph.declareIntent(new OIntentMassiveInsert()); // inserts

Re: [orientdb] Re: Lightweight vs Standard/Regular Edges

2015-03-12 Thread Luigi Dell'Aquila
Exactly 2015-03-12 18:03 GMT+01:00 Jeffrey Auguste mrjaugu...@gmail.com: Ah, so I can create an edge class extended from E and it will still be lightweight, Its when/if I add link properties to it, that it will then become an edge document. On Thu, Mar 12, 2015 at 12:57 PM, Luigi

Re: [orientdb] Re: Lightweight vs Standard/Regular Edges

2015-03-12 Thread Luigi Dell'Aquila
Yes, it's right, you can turn lightweight edges on in any moment. Actually to create a regular edge (instead of lightweight), defining a class for it is not enough, you just have to explicitly add a property to that. Luigi 2015-03-12 17:55 GMT+01:00 Jeffrey Auguste mrjaugu...@gmail.com: So it

Re: [orientdb] Re: how to handle property 'id' in a class

2015-03-12 Thread Luigi Dell'Aquila
Hi Aaron, TinkerPop Blueprints considers id as a reserved property name, so you cannot use it, unless you disable standard constraints (exactly what you did!) Luigi 2015-03-12 21:45 GMT+01:00 Aaron Gooch eodgo...@gmail.com: I was able to get around this issue by setting

Re: [orientdb] Re: Rename a Edge class causes the retention of connected Vertexes in/out ridbag names ?

2015-03-12 Thread Luigi Dell'Aquila
Hi guys, we have an open issue about this https://github.com/orientechnologies/orientdb/issues/2081 A work-around is to do a massive update on V class immediately after edge rename, eg. update V set out_NewEdgeClassName = out_OldEdgeClassName update V remove out_OldEdgeClassName update V set

Re: [orientdb] find_or_create in OrientDB?

2015-03-25 Thread Luigi Dell'Aquila
is a class exists (using SQL)? Thanks, Patrick On Monday, March 23, 2015 at 1:31:49 AM UTC-6, Luigi Dell'Aquila wrote: Hi Upsert is just a keyword in the UPDATE statement, eg. update V set id = '12', name = 'foo' upsert where id = '12' you can find all the docs here http

Re: [orientdb] Customize graph visualization

2015-03-25 Thread Luigi Dell'Aquila
Hi Fabio, OrientDB Studio is open source, you can find source code here: https://github.com/orientechnologies/orientdb-studio It would be great if you could improve the standard behavior and become an OrientDB contributor! Regards Luigi 2015-03-25 14:34 GMT+01:00 Fábio Costa

Re: [orientdb] Customize graph visualization

2015-04-01 Thread Luigi Dell'Aquila
at 11:52:32 AM UTC-4, Luigi Dell'Aquila wrote: Hi Fabio, OrientDB Studio is open source, you can find source code here: https://github.com/orientechnologies/orientdb-studio It would be great if you could improve the standard behavior and become an OrientDB contributor! Regards Luigi 2015

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

Re: [orientdb] Extreamly slow startup when creating a database (2.0.5 embedded)

2015-03-23 Thread Luigi Dell'Aquila
Hi Stefan, could you give us additional information about this machine? eg operating system, JVM version Thanks Luigi 2015-03-20 22:36 GMT+01:00 ste...@activitystream.com: Hi, We are seeing the strangest thing here. We have an embedded orentdb (2.0.5 / plocal) that create a new database

Re: [orientdb] Customize graph visualization

2015-04-01 Thread Luigi Dell'Aquila
should have been an RTFM question :) On Wednesday, April 1, 2015 at 7:52:10 AM UTC-4, Luigi Dell'Aquila wrote: 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

Re: [orientdb] security profiling

2015-03-03 Thread Luigi Dell'Aquila
Hi Raffaela, at this time the only section about security is chapter 5. We are enriching the documentation every day, with a continuous and iterative work, so if you have any suggestions about what you want to see covered, we will be happy to take them into consideration Thanks Luigi

Re: [orientdb] No index use when using sub query

2015-03-02 Thread Luigi Dell'Aquila
in github for this? Thanks, Jamie On Monday, March 2, 2015 at 4:55:51 PM UTC, Luigi Dell'Aquila wrote: Hi Jamie, this is a known issue, we are working hard on the new query parser and executor and one of the main goals of all this is query optimization. Thanks Luigi 2015-03-02 17:11

Re: [orientdb] No index use when using sub query

2015-03-02 Thread Luigi Dell'Aquila
Hi Jamie, this is a known issue, we are working hard on the new query parser and executor and one of the main goals of all this is query optimization. Thanks Luigi 2015-03-02 17:11 GMT+01:00 Jamie Blair jamie.bl...@gmail.com: The following query returns a set of `@rid` and completes in

Re: [orientdb] compound index seems to be ignored

2015-03-05 Thread Luigi Dell'Aquila
Hi Mate, there are no limitations in the number of properties that can be indexed, so there must be a bug somewhere. Could you provide a test case to reproduce it? Thanks Luigi 2015-03-04 22:25 GMT+01:00 Máté Gábri gabrim...@gmail.com: Hi, I'm trying to get familiar with OrientDB's

Re: [orientdb] Re: Need Data Modeling Help

2015-03-03 Thread Luigi Dell'Aquila
Hi Kiheung, answers below: 2015-03-02 23:39 GMT+01:00 Kiheung Park kihpar...@gmail.com: Hi Colin, Question 1: You'll just embed another document (or vertex) in the contact property. Are you trying to do this from the Java API? -- Yes or no. I was trying to modeling through studio. If Java

Re: [orientdb] in and out

2015-02-25 Thread Luigi Dell'Aquila
Hi, you can use CONTAINS instead of = (because in_* and out_* are collections) I also suggest you to use in() and out() functions, eg. select in(Owns).userID from items Luigi 2015-02-25 8:18 GMT+01:00 Dlpnet dlp...@gmail.com: Hello I have a simple DB: users -- Owns -- items when I

Re: [orientdb] Can not get sub-query with variable to work. Some help would be great!

2015-02-24 Thread Luigi Dell'Aquila
15:55 GMT+01:00 Luigi Dell'Aquila luigi.dellaqu...@gmail.com: Hi Julian, first of all let's make your query work, this is the right one: select from FOrder where user IN (select @rid from FUser where userId = 642255) Please note that I used IN operator instead of = because a query returns

Re: [orientdb] compound index seems to be ignored

2015-03-06 Thread Luigi Dell'Aquila
for testing, or some test data with the query and index I'm using? Best regards, Mate On Thursday, March 5, 2015 at 10:51:26 AM UTC+1, Luigi Dell'Aquila wrote: Hi Mate, there are no limitations in the number of properties that can be indexed, so there must be a bug somewhere. Could you

Re: [orientdb] Cluster and class in OrientDB

2015-03-26 Thread Luigi Dell'Aquila
Hi Kun, the answer to your question is no, in a single cluster you will find only instances of a single class (that are also instances of its superclasses of course). Luigi 2015-03-25 22:35 GMT+01:00 Kun Liu liukunofc...@gmail.com: Hi All, I am new to OrientDB and learning it now. I wonder

Re: [orientdb] Hooks on vertices and edges

2015-03-26 Thread Luigi Dell'Aquila
Hi David, you can just let V and E extend OTriggered, or define your hooks in Java if you want to avoid it. Regards Luigi 2015-03-26 0:40 GMT+01:00 David Carr dcarr...@gmail.com: After a bit of trial and error, I have been able to get hooks working on custom classes extended from the

Re: [orientdb] interesting question (unanswered) on stackoverflow: does OrientDB support hypergraphs

2015-03-28 Thread Luigi Dell'Aquila
IMHO it's merely a bug, edge creation should check that both ends are vertices Luigi 2015-03-26 13:12 GMT+01:00 MrFT frederik.til...@vsko.be: http://stackoverflow.com/questions/28781749/am-i-supposed-to-be-able-to-create-edges-between-two-edges-and-or-an-edge-and-a Am I supposed to be

Re: [orientdb] OrientDB slow query performance

2015-01-30 Thread Luigi Dell'Aquila
; } public double Height { get; set; } public DateTime DateOfBirth { get; set; } public decimal Salary { get; set; } } On Friday, January 30, 2015 at 5:31:29 PM UTC+8, Luigi Dell'Aquila wrote: Hi Siang, all hash indexes do not support range queries (they are based on hash

Re: [orientdb] Best time to create vertex properties

2015-01-30 Thread Luigi Dell'Aquila
Hi Oleg, do you mean that you are adding properties to the schema or that you are adding property values to existing vertexes? What I suggest you is: - create schema with properties before the insert operations (this will save space on the disk because property names are not stored in the record

Re: [orientdb] OrientDB slow query performance

2015-01-30 Thread Luigi Dell'Aquila
have any suggestion? Thanks. On Friday, January 30, 2015 at 4:43:25 PM UTC+8, Luigi Dell'Aquila wrote: Hi Siang, which kind of index did you define? Not all types of index support range queries Luigi 2015-01-30 9:05 GMT+01:00 Siang Hwee Goh gohsia...@gmail.com: I am evaluating

Re: [orientdb] Best time to create vertex properties

2015-01-30 Thread Luigi Dell'Aquila
Of course I meant use plocal instead of remoTe Just a typo ;-) Luigi 2015-01-30 11:29 GMT+01:00 Luigi Dell'Aquila luigi.dellaqu...@gmail.com: Hi Oleg, do you mean that you are adding properties to the schema or that you are adding property values to existing vertexes? What I suggest you

Re: [orientdb] How to delete a property of a schema-less document?

2015-01-29 Thread Luigi Dell'Aquila
Hi Florin, null is a valid value for a property, so setting it to null just leaves it there, in the document. If you want to completely remove a property you have to use this statement: update MyClass remote myPropertyName where... regards Luigi 2015-01-30 1:09 GMT+01:00 florin

Re: [orientdb] OrientDB slow query performance

2015-01-30 Thread Luigi Dell'Aquila
Hi Siang, which kind of index did you define? Not all types of index support range queries Luigi 2015-01-30 9:05 GMT+01:00 Siang Hwee Goh gohsiangh...@gmail.com: I am evaluating OrientDB right now and I tried to inserts 1.2 million simple records inside one of the database. It is an

Re: [orientdb] How to delete a property of a schema-less document?

2015-01-30 Thread Luigi Dell'Aquila
oh, sorry, I saw only now that I wrote remote instead of remove ;-) anyway you got the point :) Luigi 2015-01-30 12:49 GMT+01:00 florin flo...@wisemart.com: Thanks! On Friday, January 30, 2015 at 2:29:21 AM UTC-5, Luigi Dell'Aquila wrote: Hi Florin, null is a valid value for a property

Re: [orientdb] Re: Best time to create vertex properties

2015-01-30 Thread Luigi Dell'Aquila
Hi Oleg, it seems to be ok, the throughput depends a lot on the size of single documents, on the number and type of indexes you use (I can say that Lucene indexes demonstrated to have the best performance in insert) and on the type of connection you are using (plocal or remote). 1M per minute

Re: [orientdb] Re: insert or select?

2015-03-23 Thread Luigi Dell'Aquila
Hi, I already answered in your previous email ;-) 2015-03-22 0:44 GMT+01:00 pumplerod pumple...@gmail.com: I'm sorry, I thought I was in the pyorient group. Though perhaps someone here can answer the question. On Saturday, March 21, 2015 at 6:43:21 PM UTC-5, pumplerod wrote: is there

Re: [orientdb] find_or_create in OrientDB?

2015-03-23 Thread Luigi Dell'Aquila
for command request: sql.upsert On Wednesday, February 4, 2015 at 9:08:04 AM UTC-6, Luigi Dell'Aquila wrote: Hi Artem, have you tried with UPSERT? Here you can find all the references: http://www.orientechnologies.com/docs/last/orientdb.wiki/SQL-Update.html Regards Luigi 2015-02-04 13

Re: [orientdb] Strip Javascript and/or HTML code when inserting/updating

2015-03-23 Thread Luigi Dell'Aquila
Hi Stas, you could implement a hook for this. You can do this in Java or Javascript (see http://www.orientechnologies.com/docs/last/Hook.html ), just ensure to * bind your application logic on the following events: onBeforeCreate, onBeforeUpdate * let your hook functions return RECORD_CHANGED

Re: [orientdb] Indexing strategy for documents with big number of fields

2015-04-20 Thread Luigi Dell'Aquila
Hi Valeri, composed indexes in some cases can be used also in basic queries, eg. if you have an index defined on properties A, B and C, the following will use the index too: select from Foo where A = 1 It is only true if the fields in the query are a prefix of the index itself (eg. properties

Re: [orientdb] Returning a tree structure

2015-04-20 Thread Luigi Dell'Aquila
Hi Caleb, which API are you using? You can get this result just with a SELECT FROM a FETCHPLAN *:-1 2015-04-19 12:07 GMT+02:00 cloveret...@gmail.com: Hi all, Suppose that I have a tree like this: - d | - b || a--- - e | - c - f

Re: [orientdb] Want understand the concept.

2015-04-20 Thread Luigi Dell'Aquila
Hi Mahesh, I will give you two examples, one with documents and links and the other with vertices and edges. Ex1: You have a class Person with a link property father that points to another person you can do traverse father from (select from Person where name = 'Bill') while $depth 3 you will

  1   2   3   4   5   6   7   >