[orientdb] Re: OrientDB in Google Cloud Container Engine

['scott molinari' via OrientDB]

I personally don't think there are any official docs with that kind of 
information. There is a container build of ODB, but that is about it.

https://hub.docker.com/_/orientdb/

Docs: http://orientdb.com/docs/last/Docker-Home.html

This discussion might be of interest too.

https://groups.google.com/forum/#!topic/vertx/MvKcz_aTaWM

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: How do I conditionally create edges between a nodes based on property matching in both S and T?

['scott molinari' via OrientDB]

Sorry, I haven't had any time to dig any deeper on this, but I'd be money 
this can be done easier. 

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: NodeJS Gremlin Queries

['scott molinari' via OrientDB]

OrientJS supports ODB's SQL only or rather any language driver using the 
binary or rest APIs will be using ODB's SQL.

If you want to use Gremlin, I'd guess you could install a NodeJS Gremlin 
driver and connect to the Gremlin API. 

http://orientdb.com/docs/2.2.x/Gremlin.html
https://www.npmjs.com/package/gremlin

How good or bad or even if this will work is unknown to me.

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Edge @rid on IN property of Vertex appears as document in stead of #xx:x on OrientJS transaction

['scott molinari' via OrientDB]

The V1, V2 and e1 are 3 distinct classes. So, you have 3 distinct 
documents. I am guessing, the creation of an edge takes two saves to the 
document, thus you have 2 versions. In other words, when you look at V2, it 
is one document. When you look at the edge, it is a different document. 
(using normal and not light weight edges).

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Where can I find the document or tutorial on latest release

['scott molinari' via OrientDB]

What is it you are looking to configure?

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: How do I conditionally create edges between a nodes based on property matching in both S and T?

['scott molinari' via OrientDB]

Can you use a aliases?

CREATE EDGE myEdge 
FROM (SELECT Label1 AS NodeLabel1, Label2 AS NodeLabel2 WHERE @RID = #25:0)
TO (SELECT FROM NodeClass2 WHERE Label1 = NodeLabel1 AND Label2 = NodeLabel2
)

It's just a wild guess and not tested.

Scott


-- 

--- 
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.google.com/d/optout.

[orientdb] Re: How come you gone silent?

['scott molinari' via OrientDB]

This issue?

https://github.com/orientechnologies/orientdb/issues/7187

That issue got a quick reply and a work around. I think the ODB team 
answered well (as they usually do). You have to give them some time to get 
the final correction done. 

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Open db in read-only mode, possible?

['scott molinari' via OrientDB]

Ok. I understand the situation now.

For my own curiosity, what is causing the requirement for using ODB with a 
read only file system?

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Open db in read-only mode, possible?

['scott molinari' via OrientDB]

Yes, that was the initial intended solution, however, the database could be 
locked down over user roles and permissions too. The question is, would 
that also offer a proper solution?

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Open db in read-only mode, possible?

['scott molinari' via OrientDB]

Would setting a user with read only access work?

http://orientdb.com/docs/2.2/Database-Security.html 

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Cross tenant edge creation?

['scott molinari' via OrientDB]

That is an interesting use case. I'd also like to know the proper answer. 

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Graph Calendar Query

['scott molinari' via OrientDB]

Could you use the UNION example, but with an IN on the YEAR? i.e. WHERE 
year IN ["2014", "2015", "2016"]

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Graph Calendar Query

['scott molinari' via OrientDB]

Does this help?

http://orientdb.com/docs/2.2/Time-series-use-case.html#join-multiple-hours

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] What does "M1" in 3.0 M1 mean?

['scott molinari' via OrientDB]

Cool. Thanks Luigi!

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: What is the difference between the types EMBEDDED and EMBEDDED MAP?

['scott molinari' via OrientDB]

>From my understanding, the embedded type basically allows for storing data 
with no structure whatsoever. So, you can basically do what you want with 
the embedded. With embedded map, you must enter key value pairs, where the 
key must be a string.

So, if you JSON item isn't a key value pair, with the keys all strings, use 
embedded.

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] What does "M1" in 3.0 M1 mean?

['scott molinari' via OrientDB]

Morning Luigi!

Thanks for the clarification. 

If I wanted to read up on what has been achieved in milestone 1, where 
would I go?

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] What does "M1" in 3.0 M1 mean?

['scott molinari' via OrientDB]

I noticed it mentioned by Luca and Luigi and was just wondering. 

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Re: Location of the Binary API code

['scott molinari' via OrientDB]

Yes. The client/ server binary protocol is what I meant. The answer to my 
question was actually in the documentation. :-)

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Location of the Binary API code

['scott molinari' via OrientDB]

Nevermind. I've got it!

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Location of the Binary API code

['scott molinari' via OrientDB]

I think I have the right code, I'd just like to be doubly sure.

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Location of the Binary API code

['scott molinari' via OrientDB]

Hi,

This may seem like a strange and nooby question, but where in the expanses 
of the ODB code can I find the actual binary API code?

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Local Cache in OrientDB v2.0

['scott molinari' via OrientDB]

It might be better to start a new thread and to explain what your problem 
is again, than reply to a very old one. 

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Namespacing for classes

['scott molinari' via OrientDB]

There is also this OEP for version 3.0 suggested for namespaces. 

https://github.com/orientechnologies/orientdb-labs/issues/14

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Code review questions

['scott molinari' via OrientDB]

Luca,

Does that mean the links given are in the develop branch? I didn't think 
they are, because I went to the same lines in develop and they looked 
different.

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Code review questions

['scott molinari' via OrientDB]

I am not a developer, but I think you'd need to be doing any code checks on 
the develop branch. That is where I believe the party is at. :-)

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: LiveQuery vs. RethinkDB Changefeeds

['scott molinari' via OrientDB]

Great thread Anthony. Welcome to ODB!

And thanks Luigi for the detailed answer. I learned a lot. 

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Re: What is the "client" in a distributed ODB system?

['scott molinari' via OrientDB]

Thanks Luigi. 

I'll have to dig into the PHP driver again. I don't seem to remember 
finding code that concerns itself with connections to multiple servers. 

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: The semantics with "clusters" in ODB

['scott molinari' via OrientDB]

For those of you interested, you can vote for this OEP (OrientDB 
Enhancement Proposal) for Version 3.0, which I've created for this subject.

https://github.com/orientechnologies/orientdb-labs/issues/12

If you have any other improvements to the proposal I could add, please let 
me know!

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Re: What is the "client" in a distributed ODB system?

['scott molinari' via OrientDB]

A polite bump.

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Order BY @RID DESC stops working in 2.2

['scott molinari' via OrientDB]

Thanks Alessandro!

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Order BY @RID DESC stops working in 2.2

['scott molinari' via OrientDB]

I keep pretty good track of the things happening in the project. To be 
honest, I think this might have fallen through the cracks, as I've not seen 
this issue in the bug reports. 

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Will find the percentage of two values in query itself?

['scott molinari' via OrientDB]

Hey Allesandro,

You seem to be a master at ODB SQL, because when it comes to helping people 
with their queries, you seem to come up with the answers, which aren't 
exactly self-evident. It is great support!!!

Have you ever thought about actually writing up some decent advanced 
documentation on querying with ODB? You know the saying, "Give a man a 
fish, and he can eat for a day. Teach a man how to fish, and he can eat for 
a lifetime."

An advanced SQL section in the ODB docs would be extremely well accepted, 
super helpful and could save the ODB team a lot of support work. ;-)

Scott 

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Re: What is the "client" in a distributed ODB system?

['scott molinari' via OrientDB]

Ok, but does the PHP driver, for instance, also take care of distributed 
querying? How does the PHP driver know, for instance, that there is even a 
set of nodes it could connect to?

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: What is the "client" in a distributed ODB system?

['scott molinari' via OrientDB]

Hoooh!!! :-)

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] What is the "client" in a distributed ODB system?

['scott molinari' via OrientDB]

Hi,

this might be a stupid question, but everywhere the word "client" is used 
in the distribution documentation, yet I haven't seen a "client" software. 
Is there a client daemon? What is exactly the client? Because, it seems the 
client must also be aware of the cluster it is connected to, correct? 

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Sustain the OrientDB Project

['scott molinari' via OrientDB]

UmLuca. You listed only 3 ways to support an open source project. :-)

You probably wanted to mention creating issues for bugs or suggestions, but 
mixed that support a bit in with the first PR point. 

I'd also like to add, helping with support, by answering questions you 
might know the answer to. That would be 5 ways to support. :-)

Oh, and also helping the CEO on the occasional flub. Hihihi ok. That is 
rare. Nevermind. 

*:-)*

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Elastic Data Model

['scott molinari' via OrientDB]

Hi,

For 1. Have a look at the new Teleporter system. 

http://orientdb.com/orientdb-labs/teleporter/
http://orientdb.com/orientdb-teleporter-making-migrations-easier/
http://orientdb.com/docs/last/Teleporter-Home.html

For 2. First thing, although ODB is a No-SQL database, there are always 
gotchas (as with any No-SQL DB) you should be aware of with changing the 
schema (i.e. adding properties on-the-fly, as you'd like). The good news 
is, you can add and remove properties on the fly very easily. The bad news 
is, if you add too many properties on too many records at one time, you 
might cause havoc with the storage engine. Just be aware that No-SQL 
(again, any No-SQL solution, not just ODB) also has limitations in terms of 
flexible schema. Yes, they can offer flexible schema and no, it isn't 
unlimited flexible schema. The good news is, ODB allows you to set up the 
database with larger record size padding (towards the bottom) 
, should you know 
you will be going crazy with adding properties. This does mean higher disk 
and I believe even memory requirements, but it also means, available, fast 
and uninterrupted schema changes. That is the compromise you'll have to 
decide on from the start, as the padding settings can't be changed 
on-the-fly (at least I don't believe they can). 

Secondly, OrientDB doesn't currently properly support the avoidance of the 
object/ relational impedance mismatch, because it doesn't allow for 
indexing on non-schema properties. That means, you still always have to 
carry the schema baggage around with you, when developing with ODB, if you 
want ODB to also perform well. (Some hardcore developers believe the DB 
must contain schema. They are still living in the RDBMS world, 
unfortunately...) That being said, ODB tries to support avoiding ORIM in 
ways way beyond any other No-Sql solution, like with the class hierarchy 
system, which is ingenious. Still, this last hurdle of not being able to 
index properties not defined in schema needs to be taken, in order for ODB 
to be a pure No-SQL DB solution IMHO. The good news is, I believe it is 
planned to be added in Version 3.0, which is due to be released sometime at 
the end of this year. Once ODB gets this right, it will be probably the 
most versatile and powerful DB on the planet. :-)

Scott 

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Feasible way to create a sandbox with original RIDs

['scott molinari' via OrientDB]

Hmm

I think we'll go with the back-up and restore method. If the RID integrity 
is upheld with this process, that will work for us. 

We might even be able to rework the back-up code for our own special use, 
so that we can do, for instance, partial back-ups with data only older than 
X days(???). 

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Feasible way to create a sandbox with original RIDs

['scott molinari' via OrientDB]

Ok. And the script you were referring to would be doing the back-up and 
restore into a new database server. Correct?

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Feasible way to create a sandbox with original RIDs

['scott molinari' via OrientDB]

Thanks Luigi,

When you say, "provide a script", are you talking about a program written 
in say Java or Node (or even PHP)? If yes, can the RIDs actually be 
forcefully set through the binary interface? If so, how would ODB know 
where to start with the next RID on the next record creation? 

The different RIDs is exactly what we want to avoid. There is a really big 
cloud PaaS player, who has a sandboxing system, but they always change the 
IDs of the records, which makes the programming a lot more difficult, 
because the references are always lost. It means, anyone using the system 
has to basically program without any references to IDs and this is just 
plain difficult.  

Could it also be possible to have a distributed setup and to create a 
sandbox, create a new node in the cluster (slave?), then disconnect it and 
run it standalone? After that point, it is considered a sandbox copy?

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Feasible way to create a sandbox with original RIDs

['scott molinari' via OrientDB]

Hi,

For our system, we'd like to be able to offer sandbox copies of the 
database (full and partial). To make the usage of the sandbox the most 
effective and easy, it would also very beneficial to keep the same RIDs.  

What would be the best method to achieve this with OrientDB?

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Re: OrientDB News: Parallel Transactions

['scott molinari' via OrientDB]

In the world of VMs and IaaS, I don't think putting up exact nodes should 
be an issue. 

However, what happens, if a class created with 8 clusters, is moved to a 
new VM with more cores? Is the class then stuck on 8 clusters? Or can ODB 
create and redistribute the data into any new clusters automatically? 

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: OrientDB News: Parallel Transactions

['scott molinari' via OrientDB]

Does this mean the machines running in a distributed cluster will all need 
to be the same in terms of cores for ODB to work right and fast?

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Re: "Pinning" a table in memory

['scott molinari' via OrientDB]

Hey Eric. Already done!  

https://github.com/orientechnologies/orientdb/issues/6447

Hope you don't mind.

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: "Pinning" a table in memory

['scott molinari' via OrientDB]

I'd also love to see a memory only class in ODB.

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] All those extra clusters in v2.2

['scott molinari' via OrientDB]

So a database set to use only one cluster per class will always use one 
cluster per class, no matter how the server is set?

That would mean, turning off the multiple cluster feature also means 
removing any performance advantage for the future, like when the database 
gets larger?

Is there no shard(cluster) rebalancing mechanism available in ODB?

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] All those extra clusters in v2.2

['scott molinari' via OrientDB]

Will a database created with "class.minimumClusters=1" work later with a 
server that doesn't have this setting?

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: A week with OrientDB

['scott molinari' via OrientDB]

On the point about clusters, I brought that up here. 

https://groups.google.com/forum/#!topic/orient-database/2_iTzne1eXo

Basically, a "cluster" in ODB should be a shard. 

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: 3.0 and "communicating with the rest of the world"

['scott molinari' via OrientDB]

I'd like to answer my own question. It looks like the ODB development team 
want to open up the discussions (and pursuing developments) for 3.0. 

https://github.com/orientechnologies/orientdb-labs/issues

Here is a description of the new process.

https://github.com/orientechnologies/orientdb-labs/issues/1

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Executing database queries as a plugin

['scott molinari' via OrientDB]

Hmmm...I think I misunderstood your question. Do you mean using ODB within 
another Java application? Yes, you can use it in what is called embedded 
mode. 

http://orientdb.com/docs/2.2/Embedded-Server.html

Is that what you are asking?

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Executing database queries as a plugin

['scott molinari' via OrientDB]

There are two possibilities I know of - Java hooks and custom functions 
(with triggers). Unfortunately, for the power and/ or flexibility these 
features provide, the documentation leaves a bit to be desired.

http://orientdb.com/docs/2.2/Functions-Creation.html (note there are more 
chapters in the menu on the left on functions)
http://orientdb.com/docs/2.2/Dynamic-Hooks.html
http://orientdb.com/docs/2.2/orientdb.wiki/Java-Hooks.html

Scott


 


-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Manipulating data with hooks

['scott molinari' via OrientDB]

I tried just that line and it doesn't work. So I added (on a whim) 
doc.save(); and it then worked. So it seems, it is necessary. 

Is there a log for errors on functions like this? How can one troubleshoot 
errors on functions, which are triggered? 

Also, I feel like a blind (ding)bat because of the missing information on 
how to use functions and triggers. 

And yes, being able to add custom functions at runtime adds a good bit of 
flexibility to the database. If it is at all performant, this is actually a 
USP above (I believe) MongoDB and Neo4J, especially with the ability to 
hook custom functions dynamically to CRUD triggers. This opens up a whole 
bunch of possibilities. I personally just need to learn more about how to 
use it and the missing docs is killing me. LOL!

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Executing database queries as a plugin

['scott molinari' via OrientDB]

Hi,

Can you be a bit more specific? There are a couple of ways to do things on 
the server directly. What is it you'd like to get done?

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Manipulating data with hooks

['scott molinari' via OrientDB]

Yes, I was running the "execute" in Studio, when I got the error and your 
explanation makes perfect sense why it won't work, now that you mention it. 
I should have realized that, while doing it.

But, with your help, I've gotten my trigger working. It's a custom function 
"setLastUpdatedAt" and is triggered on "afterUpdate" and looks like this:

var db = orient.getDatabase();

var og = (db.getTransaction().isActive())
?orient.getGraph()
:orient.getGraphNoTx();

var now = new Date().getTime();

doc.field("lastUpdatedAt", now);

doc.save();
 
return;

And it works like a charm. 

Though, I would imagine Java hooks would perform better, and since this 
activity will be done as a standard part of my app, I'll probably go with a 
Java hook eventually. This get's me further though, so I can continue work. 

Thanks so much for the help. 

@ODB Team - would you consider this a good solution for creating an update 
trigger, which updates a date/time field? If yes, would you like me to add 
it to the docs under custom functions? I wish I understood more about 
digging into custom functions and using ODB's engine to work with it, I'd 
do more of a write-up in the docs. 

I feel this feature could be a wicked webinar 

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Manipulating data with hooks

['scott molinari' via OrientDB]

Hey odbuser,

Hmmm. Trying this out and I get an error. 

Cannot read property "getDatabase" from undefined in  at line number 2


The custom functions part of ODB seems so powerful, yet there is so little 
docs on it. That is really disappointing.

It seems to be the right way to get the database instance.

var db = orient.getDatabase();

However, I don't know how to get the current "triggering" document from 
that. 

Scott 

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Manipulating data with hooks

['scott molinari' via OrientDB]

Thanks odbuser. I'll have to give it a try, when I get back home.

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Re: OrientDB Enhancement Process

['scott molinari' via OrientDB]

You can sort according to "most reactions". So if everyone uses the thumbs 
up reaction to vote, you can filter and sort accordingly.

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Manipulating data with hooks

['scott molinari' via OrientDB]

I am traveling, so I can't try it out, so I'll ask. 

All I need then is something like doc.myProperty to access a property? How 
about embedded docs?

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Manipulating data with hooks

['scott molinari' via OrientDB]

I think my question boils down more to how can I get the rid or actually 
the record itself, which is triggering the trigger, to basically manipulate 
that same record?

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Manipulating data with hooks

['scott molinari' via OrientDB]

Hi,

All the examples of custom functions in the docs are either about querying 
for data, giving out responses or adding data during creation. Nothing 
explains updating, unfortunately.

So, the question is: How can I make a function that can be used to 
automatically update a certain field with data, when a record is updated.

For example: let's say I want to concatenate the "first-name" and 
"last-name" fields to make a "full-name" field automatically, with every 
update made to the a "User" class. 

Is that possible?

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: New to OrientDB

['scott molinari' via OrientDB]

Hi Francisco,

Yeah, that text is a bit misleading. It was originally meant for Github, 
where only bugs and suggestions should be written. If you saw it posted 
there, it make more sense.

You can certainly ask questions here. 

The sticky does mention SO is the preferred method to ask questions, but 
indirectly. 

Or you can post it to the Community Group *(Stack Overflow answers usually 
> come earlier)*:


In other words, the ODB team take care of SO first, before they take care 
of this group. Though, most questions are answered here. 

Scott 

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: 2.2.2 Release Notes

['scott molinari' via OrientDB]

There is this.

https://github.com/orientechnologies/orientdb/issues?utf8=%E2%9C%93&q=milestone%3A%222.2.2%22+is%3Aclosed+

Not sure it is what you are looking for though.

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] 3.0 and "communicating with the rest of the world"

['scott molinari' via OrientDB]

Hi,

Will there be any major changes to the binary protocol other than 
improvements and extensions in 3.0? I mean, will it be completely 
rewritten? Like maybe using gRPC 
 or some other 
more standard like protocol? 

If there are plans to do a complete rework like this, I'd like to suggest 
getting the driver devs (as far as you don't program them yourselves) into 
the development loop very early. Because, creating a driver after the 
general release would mean creating a driver would become a big hairy 
monster and it might cause a serious loss of attraction.

I've seen it happen before. A company I know well, in their new version of 
their software, rewrote a lot of the core code in an application that also 
performed as a good extension platform. Although extensions aren't exactly 
the same as drivers, in a way, they are very similar. They are similar, 
because they both promote adoption of the software. The software the 
company created was very popular in the earlier version, because so many 
devs wrote extensions to create new features and even new applications for 
that "platform". Needless to say, with the new version and lack of 
attention to the 3rd party dev community, they lost the majority of 3rd 
party dev support. And now, the software is just a shadow of what it used 
to be. 

Maybe you already have this in mind. I hope you did. At any rate, I hope I 
could help.

Scott  


-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Stream live data with php script

['scott molinari' via OrientDB]

I also asked this question.

https://github.com/Ostico/PhpOrient/issues/76

Not sure it is the same, but if that is what you want to know, you could 
make a comment in that thread.

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] The semantics with "clusters" in ODB

['scott molinari' via OrientDB]

Hi Luigi,

I am glad I am not out to lunch! LOL!

Because it is such a big change, I'd consider it something to tackle in 3.0 
actually. I wouldn't even mind helping with the docs. 

How about the code? Are there a lot of changes to be made, so the code also 
uses the proper semantics? 

This page would make a whole lot more sense after the change. :-)

http://orientdb.com/docs/last/Distributed-Sharding.html

Sentences like this where a "WTF" moment for me intially, coming from 
MongoDB.

OrientDB automatically creates a new cluster 
>  per each class as 
> soon as node joins the distributed cluster.
>

Much better

OrientDB automatically creates a new shard 
>  per class as soon 
> as a node joins the distributed cluster. 
>

:-) 

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] The semantics with "clusters" in ODB

['scott molinari' via OrientDB]

Hi,

>From a horizontal scaling, distributed database standpoint, I feel the 
semantics used in ODB aren't quite right (although they are pretty cool 
nonetheless). I apologize for being pedantic, but to me, a "cluster" should 
be a group of nodes in the distributed data setup. As I understand 
computing distribution, what ODB calls "clusters" should actually be called 
"shards", as it is the concept of sharding that is being done with the 
clusters, right? 

http://www.webopedia.com/TERM/D/database_shard.html

Or am I totally out to lunch?

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Re: Support for Lucene 6 3D (nD) Spatial Indexes

['scott molinari' via OrientDB]

Hey Roberto.

Off-topic, but when do you all update the master branch? I would have 
assumed the master branch is at the same level as the last release (and why 
my reply was wrong). 

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Support for Lucene 6 3D (nD) Spatial Indexes

['scott molinari' via OrientDB]

If I read the code/ config in the Lucene index section of ODB, it looks 
like it is using 4.7.0, which is disappointing, considering the Lucene team 
is working on version 7.

https://github.com/orientechnologies/orientdb/blob/5d4ff9438db9eacd18c2502615747648602b49ed/lucene/pom.xml#L39

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Re: RETURN @rid doesn't work as documented

['scott molinari' via OrientDB]

Yeah, I see what you mean. I wonder if digging into the ODB code (although 
shouldn't be necessary) might get you some more details?

I believe this is the area of ODB that works the JS functions...(but, it is 
just a big guess on my part).

https://github.com/orientechnologies/orientdb/tree/master/core/src/main/java/com/orientechnologies/orient/core/command/script

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Re: RETURN @rid doesn't work as documented

['scott molinari' via OrientDB]

Did you look through the other links in the menu under "Functions"? Not 
sure that info will help, but it does go into a little more detail about 
functions.

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: RETURN @rid doesn't work as documented

['scott molinari' via OrientDB]

I also found this:

http://orientdb.com/docs/last/Functions-Creation.html

Check the other sections in the menu too.

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] [OrientDB] Datetime milliseconds are ignored

['scott molinari' via OrientDB]

Cool. Glad I could help. 

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Re: OrientDB Storage Overhead

['scott molinari' via OrientDB]

Ahh! Gotcha. I am also very interested in the answer.

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Re: What is the fastest way to insert a group of linked documents?

['scott molinari' via OrientDB]

Yes, most definitely pre-allocate for any data in the records. This is also 
something MongoDB (sort of) recommends, when doing time series data with 
their database (which is a pure document database). 

http://blog.mongodb.org/post/65517193370/schema-design-for-time-series-data-in-mongodb
 
(see next to last paragraph before the conclusion). 

Or here: http://learnmongodbthehardway.com/schema/chapter6/ 

:-)

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] [OrientDB] Datetime milliseconds are ignored

['scott molinari' via OrientDB]

ODB stores the dates as Unix epoch. You can use the .asLong() to see the 
full date (long) value. 

http://orientdb.com/docs/last/Managing-Dates.html

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Re: OrientDB Storage Overhead

['scott molinari' via OrientDB]

Didn't Andrey answer that question with the last answer? 

Do you mean whether we add additional information to record if field is 
> absent in record itself but defined in schema, do not you ? No, we do not 
> add any overhead.


Scott   

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Re: What is the fastest way to insert a group of linked documents?

['scott molinari' via OrientDB]

No. Not aware of any more docs on JS custom functions. 

I am still uncertain about not using edges and vertexes. For instance, how 
would you do aggregations (if you do need them) without being able to 
traverse upward in the hierarchy? You're basically limiting yourself, 
aren't you?

The only thing that comes to mind, which might help is pre-allocating, say, 
a day's worth of records. So, create the time based nodes before the time 
actually hits (the day before?), then it is a matter of only updating the 
nodes according to the timestamp of the data, once the data is created. 
This could be like your current batch job, only done earlier to pre-build 
the time series hierarchy. This seems plausible to me, because the time 
series data is a fixed or rather known data structure. The only 
disadvantage is if your time based data has holes in time, meaning, you 
don't have data for every minute of the day, you'd have nodes with no data. 
But, theoretically, you could clean those up the day after too. I don't 
know. Just throwing out some ideas...:-)

Scott  

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: What is the fastest way to insert a group of linked documents?

['scott molinari' via OrientDB]

You say your problem is inserting a number of documents at the same time. 
At what point in storing the time series data is that necessary? 

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: What is the fastest way to insert a group of linked documents?

['scott molinari' via OrientDB]

Hey Eric. 

If I may ask, what is the data model you have or can you give an example, 
which requires a unidirectional relationship between classes?

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: OrientDB Storage Overhead

['scott molinari' via OrientDB]

All questions I'd like to know the answer to too.

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: OrientDB Storage Overhead

['scott molinari' via OrientDB]

I can't help much, but I do remember reading that the records are padded 
with space. You can find that info here (towards the bottom). 

http://orientdb.com/docs/2.1/plocal-storage-engine.html 

I know this kind of "pre-allocation" technique is necessary to allow for 
flexible schema i.e. adding properties to records later on or updating 
records with more data than was there before. As I understand the reason 
for record "pre-allocation", it is needed because, if the space taken by 
the record would be exactly the size of the record, then adding data to it 
(making the record size larger) would cause the database to have to move 
the record on disk, instead of updating it directly. You can imagine, if 
you then update a lot of records this way, you'd end up with a huge mess 
fast and the database would slow down considerably. So, in order to avoid 
that, the database pre-allocates space per record. ODB has the setting 
RECORD_GROW_FACTOR. In MongoDB, they recommend and set as default what they 
call "powersOfTwo". In other words, the database doubles the initial size 
of the document on disk. This is what is explained in the example in the 
docs.

As I take it from the docs, the settings for record size can be changed 
through configuration. If you know your record size will never change, you 
could drop the values to "1". However, I could imagine, if you do that and 
then you do update and increase the data even a little in a good number of 
records, that will not jive well with the database. Though, I am no expert 
on that. 

I'd also like to know the overhead values of the data types otherwise. 
Would be great basic knowledge of the database. If one of the nice gents 
from Orient would lay it out here, I'd be even glad to add it to the 
documentation. It would be a great addition to this table: 
http://orientdb.com/docs/latest/Types.html

Scott
 

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Best practice to map OrientDB ORecordId onto RestFull friendly ID representation

['scott molinari' via OrientDB]

Also answered on SE.

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Best practice to map OrientDB ORecordId onto RestFull friendly ID representation

['scott molinari' via OrientDB]

We're looking into using HashID. http://hashids.org/

There are some minor concerns we have still, but theoretically, HashID 
should get you a hashed Rid, which is also convertible, so it won't take up 
more storage space (like with a UUID). It will just take a small bit of CPU 
time.

Please note, this little tool is not in any way a true hash, as in, it 
makes it very hard to crack the hash. It is more about good obfuscation. If 
you are at all worried about the Rids being known, this isn't a proper 
solution.   

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] OrientDb 2.1.15 java.net.SocketException: Too many open files when 9+ Databases are created

['scott molinari' via OrientDB]

Roger. So ODB will go about its business and ignore the useless PARALLEL, 
if the minimum clusters is set to 1. That is good! Thanks!

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] OrientDb 2.1.15 java.net.SocketException: Too many open files when 9+ Databases are created

['scott molinari' via OrientDB]

Ok. Last question. If someone were to use PARALLEL, but had the database 
set to "minimum clusters 1", maybe like in a sandbox situation, would ODB 
go about its business despite the illogical query with PARALLEL in it?

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] OrientDb 2.1.15 java.net.SocketException: Too many open files when 9+ Databases are created

['scott molinari' via OrientDB]

Would that mean pabloa would then need to make a sacrifice on performance? 

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Batch query with Multiple id(or other field)

['scott molinari' via OrientDB]

http://orientdb.com/docs/last/SQL-Query.html

Scroll down to "Unwinding" towards the bottom of that page. That might be 
what you are looking for.

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: How to troubleshoot orientjs driver with 2.2GA server

['scott molinari' via OrientDB]

I answered on SE, but I'll post my answer here too. 

Have you tried an older version of ODB? In the PHP world, we also have 
issues with ODB 2.2, because the PHP driver hasn't been updated to the new 
binary protocol.

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] What happenes to edges if I delete a vertex.

['scott molinari' via OrientDB]

I don't know of any reason to use a document database either. It I wanted 
that, I'd use MongoDB. ;-)

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] What happenes to edges if I delete a vertex.

['scott molinari' via OrientDB]

As I understand ODB, using the "Graph API" means you've created the 
database as a graph database and not as a document database. So, if you are 
using a graph database, then your SQL is automatically using the Graph API.

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] orient 2.2 auto-generated root password

['scott molinari' via OrientDB]

Luca, what is the hashing algorithm used to make/ check the root password? 
SHA256? SHA512? It seems SHA256. Just want to make sure

Arul, when you know the hashing algorithm, it is best to create your own 
hash (with your own password) . The 
autogeneration is only there to show you what you need to do within the 
orient-server-config.xml config file for your own password and so ODB will 
also even work (it breaks, without the user property in the file). 

I also think this could be better explained in the docs. :-) Let me know 
where this is best discussed in the docs Luca and I'll add it. Or, is there 
a section explaining this already (I couldn't find it)? :-)

Scott 

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: [Announcement] OrientDB v2.2 GA is here! Improved Security, Performance, Operations & APIs

['scott molinari' via OrientDB]

Congrats to the whole ODB team! A lot of hard work put into 2.2. I am 
looking forward to better reliability and higher quality standards being 
met with this new version. Great work!

And, although this is a great milestone in the life of ODB, my personal 
dreams are set on 3.0, as I feel that is the version, which will entail all 
the learnings of the past (including mistakes made), and 3.0 is where those 
learnings will really come to fruition. Getting 2.2 out means to me, you'll 
have a lot more time to work on 3.0 now. That is what is really exciting. 
;-) 

Scott 

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Re: Get Edge between two vertices

['scott molinari' via OrientDB]

@luca 

I would guess K Major doesn't actually know the rid of the proper edge. So, 
between the two edge rids he has as "outs" in that vertex, he'd have to 
find the right one and then get the weight. Your query is assuming the 
right edge rid is #11:12916. This rid should be unknown to him. If he did 
know the edge rid, theoretically, couldn't he just do...

SELECT weight FROM #11:12916

??? :-)

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Get Edge between two vertices

['scott molinari' via OrientDB]

The "out" in vertex #11:1820 is the rid to the edge. not the other vertex. 
You need the id of the other vertex as your "out" value in your query.

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Get Edge between two vertices

['scott molinari' via OrientDB]

If you have "normal" edges and you know the vertex you are coming from, I 
don't believe you should be looking for the out property on the edge, but 
rather the "in" property from your vertex to that edge. What is the 
vertex's id? Filter on that as the "in" property of your edge and you'll 
have the edge.

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: Is it possible to rename a remote database?

['scott molinari' via OrientDB]

Interesting. I would have thought ALTER DATABASE would allow the renaming 
of the database. But, it looks like that isn't possible.

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Re: OrientDB very slow performance on basic unique key lookups, website painfully slow

['scott molinari' via OrientDB]

Ok. Sounds like you are right about the profiles. I hope the ODB guys can 
help. I think I pulled enough of the right information out of you, so they 
can help. Sorry, I am not more help.

Scott

-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Re: OrientDB very slow performance on basic unique key lookups, website painfully slow

['scott molinari' via OrientDB]

Great explanation. 

I am not at all a Java programmer and I am also learning ODB and graph 
databases, so I can only suggest what might be a problem or rather point to 
what I think might be a problem. So, take what I say with a grain of salt.

Is there a particular reason to split the accounts from the two profile 
types? If the relationships are always direct, I'd not waste edges on 
connecting them. I'd have the profiles as subdocuments of the account. That 
will speed the retrieval of the profile data a lot. 

For retrieving data, do you really need a transaction? Transactions are 
definitely more costly from a performance perspective. I mean, would it 
matter if a person sees partially old data in your system? I would imagine 
it isn't too critical. 

Also, from a data querying perspective, constantly hitting the database in 
a loop is going to be slower than finding a proper query, which gets you 
the data you need in one shot (in most cases). To be honest, I am not sure 
that is actually happening, but from the code, that seems like what is 
happening. Unfortunately, I can't help you on a better query. I am not that 
good at the Java API. 

Hopefully Luca or Luigi can offer some better tips and sorry I can't offer 
more of help.

Scott




-- 

--- 
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.google.com/d/optout.

Re: [orientdb] Re: OrientDB very slow performance on basic unique key lookups, website painfully slow

['scott molinari' via OrientDB]

Can you give us some code examples of queries that are slow?

Scott

-- 

--- 
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.google.com/d/optout.

[orientdb] Re: OrientDB very slow performance on basic unique key lookups, website painfully slow

['scott molinari' via OrientDB]

What language driver are you using?

Scott

-- 

--- 
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.google.com/d/optout.