Re: [orientdb] Orientdb SQL query to check edge properties

Hi, for sensors I would say: SELECT FROM Sensor WHERE isDeleted = true AND 1 in in('DeviceHasSensors').in('UserHasDevices').userId For devides it's simpler: SELECT FROM Device WHERE isDeleted = true AND 1 in in('UserHasDevices').userId Cheers, Riccardo 2015-07-13 23:25 GMT+02:00 Yasith Lok

Re: [orientdb] Disable Cache on OrientDB Server

Hi Luigi, Thanks for the response. Noted your comments on application level caches. I tried to set the disk cache size referring to this post . However, I wanted to do this via the XML configuration and I

[orientdb] Re: Time Series Java API example

But the question still stands - this example is great assuming I have a history of logs I want to insert into the database all at once, but of course log entries are being generated all the time. Can I insert a new one into the structure above at runtime? via sql or java API? Can I insert an em

[orientdb] Re: Time Series Java API example

Oh I am so sorry I didn't read your code sample - I thought that was my original code! Thank you so much! That is amazing and just what I needed to know! You have of course populated the days, weeks, months etc and done it much more elegantly than I would have!! On Monday, July 13, 2015 at 11:2

[orientdb] Re: Time Series Java API example

That query is great to SELECT the log entries once they are there - but how on earth do I populate them in the first place?! Actually writing the simple loops to generate the days, weeks, months etc was wrong as I need to link them together by linkmap -- --- You received this message bec

[orientdb] Re: Wrong user/password to [connect] to the remote OrientDB Server instance

Hi all, That's the piece I was missing. Somehow I didn't find the right information. But I guess I'll have to do a deep dive in to the Waterline paradigm. Thanks a lot for helping me with this. It's working now. Kind regards, Chris On Monday, July 13, 2015 at 11:30:37 PM UTC+2, Dário Marcelin

[orientdb] Re: Wrong user/password to [connect] to the remote OrientDB Server instance

For reference, the way to connect to a DB without server credentials is by using options.databaseUser and options.databasePassword, for example: myLocalOrient: { adapter: 'sails-orientdb', host: 'localhost', port: 2424, database: 'testdb', options: { databaseUser: 'testdb', da

[orientdb] Orientdb SQL query to check edge properties

I have a Graph database with three simple Vertex types, User, Device and Sensor. The relationship goes as, > Edges: UserHasDevices, DeviceHasSensors Each edge has a property name "isDeleted". When deleting a Vertex, I don't make it deleted permanently but make the "isDeleted" property of t

Re: [orientdb] OrientJS JSDoc output

Hi Mitch, If you have a cool setting to generate the documentation, please let me know and I publish it online. Best Regards, Founder & CEO OrientDB On 13 July 2015 at 22:03, Ryan Mitchell wrote: > Hi all - > > Starting to play around with OrientDB and working inside a

Re: [orientdb] Wrong user/password to [connect] to the remote OrientDB Server instance

Hi Dário, Thanks for your feedback. I have 0.10.55. Doesn't work. I tested on two Macs. I've opened an issue with the sails-orientdb guys. Do I need to configure something else in orientdb-server-config.xml so that DB credentials only work? https://github.com/appscot/sails-orientdb/issues/122

Re: [orientdb] Wrong user/password to [connect] to the remote OrientDB Server instance

I was just talking to the developer of the plugin and he told me that it is necessary that the user is added to the user section of orientdb-server-config.xml. Is this true? It would mean that despite users can be added over the web interface manual configuration is required, which doesn't se

[orientdb] OrientJS JSDoc output

Hi all - Starting to play around with OrientDB and working inside an existing NodeJS project I have. I'm using the OrientJS javascript driver (https://github.com/orientechnologies/orientjs) and the main README on GitHub is helpful, but not really "API Documentation". The JS source actually app

Re: [orientdb] Wrong user/password to [connect] to the remote OrientDB Server instance

Hi Christopher, Since v0.10.53 (PR #86 ) sails-orientdb allows to authenticate against OrientDB using DB credentials only. This requires the DB to already be created, though. Cheers, Dário On Sunday, 12 July 2015 23:10:45 UTC+1, l.garulli wro

[orientdb] Implementing a queue in OrientDB

Hi all-- I'm looking for some advice on pros/cons/designs for implementing a queue in ODB. The queue stores messages in a more-or-less FIFO manner based on the individual message priority (an integer), with the possibility that some messages may need to be retried over a period of time, but ulti

[orientdb] Re: Requested command 'create edge type *** as subclass of 'E'' must be executed outside active trans...

Forgot to mention that I am running .12 on OSX 10.9 1.7 jvm. And creating the instance as follows: OrientGraph("plocal:") On Monday, July 13, 2015 at 9:54:18 AM UTC-6, José Cornado wrote: > > First, great job! I am embedding the graph DB inside an eclipse plug-in > and the startup and shutd

Re: [orientdb] Wrong user/password to [connect] to the remote OrientDB Server instance

Hi, I'm using the sails-orientdb plugin. I got actually a little confused because I read that the best plugin is the waterline-orientdb plugin, but it seems that it was renamed to sales-orientdb. The sails configuration looks the following: someOrientDbServer: { adapter: 'sails-orientd

[orientdb] QUERY LIMITS

Hi, Question: is there a size limit to a query string? I'm sending gremlin queries through the binary protocol (via node driver). At some point I may need to build a query with a large array of ids to fetch them from orientdb, I imagine there is some kind of limit to the size of the query I'm

[orientdb] Re: record level security: can't browse, grant and revoke won't work

Well that's embarrassing. Thanks! segunda-feira, 13 de Julho de 2015 às 16:54:13 UTC+1, user.w...@gmail.com escreveu: > > Hi David, > > probably the problem is that the permision settings > "database.class.Concept": *5 *means Update&Create. > For a read&update combination you need to set "databa

Re: [orientdb] Re: Out of memory error on delete edge with 600k records

Short form -- you're building a transaction of changes, and you're changing a lot of records. To delete one link, you end up modifying the source and target nodes (plus the edge itself if you're using heavyweight edges). If you build a transaction with 2.9M changes, it *is* going to take a lot of

Re: [orientdb] Lightweight Edge & Inheritance

I knew my wording was not going to be understood. I meant to say, the "weight" property is nothing the database itself will work off of. There is no internal logic in the database, which takes the property into account and thus changes results. The fact a user can use the property in a query f

[orientdb] Requested command 'create edge type *** as subclass of 'E'' must be executed outside active trans...

First, great job! I am embedding the graph DB inside an eclipse plug-in and the startup and shutdown are really fast. It is hard to notice that in addition to the plugin a DB is being used. Even when I do something wrong it fails quickly and gracefully. I have a question: As a rule of thumb I

[orientdb] Re: record level security: can't browse, grant and revoke won't work

Hi David, probaby the problem is that the permision settings "database.class.Concept": *5 *means Update&Create. For a read&update combination you need to set "database.class.Concept": *6*bye, Ivan -- --- You received this message because you are subscribed to the Google Groups "OrientDB" g

[orientdb] Anyone using OrientDB API with Foundation for Apps?

http://foundation.zurb.com/apps/ It seems like a great platform for building frontend webapps however it lacks any DB functionality. I thought that by building my classes, etc in OrientDB then using it's HTTP API as the "interface" - it could be a pretty slick solution. Here is an API example

[orientdb] At what point to divide records into clusters for performance?

Greetings! I'm building a database for Game Mods. I have a superclass mods with subclasses arma2, arma3, skyrim, etc. My question is, at what point would it be beneficial to split records between clusters? I originally was going to create a cluster per game mod category mods(class)->skyrim(cl

Re: [orientdb] Cannot access a database instance running in distrubted mode

Hello, Yes, if I run the server.sh I am able to open and work with the old database (1.7.8) in 2.0. When I attempt to work with it with the dserver.sh running is when I have trouble. Any help is greatly appreciated! On Sunday, July 12, 2015 at 6:12:02 PM UTC-4, l.garulli wrote: > > Hi, > Befo

Re: [orientdb] Lightweight Edge & Inheritance

2015-07-13 15:22 GMT+02:00 Eric24 : > I assume the weight property could also be used in an ORDER BY clause? > Yes -- --- 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 emai

Re: [orientdb] Lightweight Edge & Inheritance

Yep, that makes sense to my way of thinking. I assume the weight property could also be used in an ORDER BY clause? --Eric On Monday, July 13, 2015 at 8:06:06 AM UTC-5, Riccardo Tasso wrote: > > > 2015-07-13 14:58 GMT+02:00 Eric24 >: > >> Surely it's possible to include a property in a query, and

[orientdb] record level security: can't browse, grant and revoke won't work

I'm using version 2.0.3 Can't browse a class with a specific user despite the fact that I granted authorization to their role. I'm working with record level security, so both V and E inherit from ORestricted. I've created a class Concept which (not directly) inherits from V. The OUser "Angela_

Re: [orientdb] Lightweight Edge & Inheritance

2015-07-13 14:58 GMT+02:00 Eric24 : > Surely it's possible to include a property in a query, and if that > property is a "weight" (regardless of what it's called), that could be use > to influence the results? Does anyone have an example of such a query? Consider, for example you want to extract

Re: [orientdb] Lightweight Edge & Inheritance

Hmmm. That's part of the challenge I've had in learning ODB and graph databases in general--there are lots of examples that mention various constructs without really explaining them. Surely it's possible to include a property in a query, and if that property is a "weight" (regardless of what it

[orientdb] Re: PATHS of ANY LENGTH between Two Vertices

Hi Subhasis, right now don't exists a function that find all possible path. However, i'm attaching the class that i had created in Java to solve this problem. Bye, Giulia -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from t

[orientdb] PATHS of ANY LENGTH between Two Vertices

@Orient DB 2.0.12 - I want to find ALL possible PATHS of ANY LENGTH between two vertices A (#8:01) and B (#8:02) considering navigation by OUT edges only. I did check that shortestPath() but it returns only ONE path between two given vertices. Can I use SQL TRAVERSE or can anybody help me write

Re: [orientdb] Re: Am I legally allowed add the orient db jars to my meteorjs project repo?

Hi Micheal, Scott is absolutely right, Apace2 license is very permissive in this sense. As the author of OrientDB LiveQuery implementation, I'm very interested in Meteor.js integration, so please keep me updated as soon as you have news. I guess you are already aware of the discussions on the mail

Re: [orientdb] Re: "where in.@rid = someRID" does not work but "where someRID in in.@rid" works, why?

Hello Luigi, thank you so much for clarifying the difference between vertex and edge in their in.* out.* behavior. this may be off topic but what if we want to check for some comparison between members of in.* or out.* collections and some criteria, for example something like this: select *

[orientdb] Re: Memory leaks on Tomcat 7 shutdown

I have the same issue (2.0.8 orient + tomcat 7). I have attached a debugger and on shutdown I notice that tomcat logs these complaints before Orient.instance().shutdown() is ever invoked by the context destroyed event - it is invoked however. So perhaps the cleanup is just occurring after tom

Re: [orientdb] Disable Cache on OrientDB Server

Hi Omega, two important things: 1) I strongly suggest you to avoid switching off all application level caches, because it can lead to inconsistencies 2) there is another cache level at the storage, that is the disk cache. Disk cache is just a memory replica of disk structures (cluster pages). In y