[arangodb-google] Re: Ability to make online store

Hi Andy, ArangoDB is definitely suitable as backend for online stores, see the AboutYou.de case study: https://www.arangodb.com/case-studies/aboutyou-data-driven-personalization-with-arangodb/ If I'm not mistaken, relations between nodes in Neo4j are closely following the concept of a labelled

[arangodb-google] Re: How to perform complex operations on an AQL query

You're welcome. I assume you changed it like this? RETURN { total: LENGTH(kinds), users: MERGE( FOR k IN kinds COLLECT kind = k.userKind WITH COUNT INTO kc RETURN { [ CONCAT("kind", kind) ]: kc } ), stats: MERGE( FOR k IN kinds

Re: [arangodb-google] collection is a nullptr ... please report this error to arangodb.com

@ThomasWeiss: Can you confirm that the problem is fixed in latest stable releases? -- You received this message because you are subscribed to the Google Groups "ArangoDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to

[arangodb-google] Re: TRAVERSAL_TREE in 3.0

Hi Marko, there is no direct substitute for this function, but you can use native AQL traversal to return something similar: FOR v, e, p IN 1..5 ANY "company/9" careerEdges LET other = ( FOR vv, ee IN ANY v careerEdges FILTER ee != e LIMIT 1

[arangodb-google] Re: TRAVERSAL_TREE in 3.0

Hi Marko, there is no direct substitute for this function, but you can use native AQL traversal to return something similar: FOR v, e, p IN 1..5 ANY "company/9" careerEdges LET other = ( FOR vv, ee IN ANY v careerEdges

[arangodb-google] Re: few questions before the switch

I just posted a simple implementation for binary operations over here: https://github.com/arangodb/arangodb/issues/1869#issuecomment-234041878 -- You received this message because you are subscribed to the Google Groups "ArangoDB" group. To unsubscribe from this group and stop receiving emails

Re: [arangodb-google] Re: Lock Timeout when creating index in ArangoDB

Multiple FILTER operations like that are AND combined, so really just code style: https://docs.arangodb.com/3.0/AQL/Operations/Filter.html -- You received this message because you are subscribed to the Google Groups "ArangoDB" group. To unsubscribe from this group and stop receiving emails

[arangodb-google] Re: Conditional projections and behavior of the ternary operator

Maybe an equivalent to SELECT ... UNION SELECT ... would help in your case? You could try to use multiple subqueries to prepare the data and merge the data together at the end. Another way would be to move the projection code to Foxx and run multiple queries transactionally, then combine the

[arangodb-google] Re: Switching nodejs app from MongoDB to ArangoDB

Hi Daniel, we do not have a migration guide for that, but it is on our todo list. Maybe you can help us to write such a guide by providing some of your MongoDB insight and queries? If you say that you use NodeJS, do you use arangojs as driver? In that case, firstExample() should be what

[arangodb-google] Re: AQL Ternary Operator Performance & Optimization

Another possible "hack" is to convert the credit score to a boolean (null converts to false) and multiply it with the original UPB, which will implicitly cast the boolean to a number (false = 0, true = 1). If there's no credit score, the original UPB will be multiplied by 0, which will zero it

Re: [arangodb-google] Documentation for Setting up ArangoDB cluster for 3.0

Hi Praveen, did you use Google to find that outdated page? We know that Google brings up a lot of old information and lacks a lot important matches. We try to improve that, but it is not trivial to convince them to favor the newer links. Have a look here:

[arangodb-google] Re: About "conflicting directions specified for collection"

Shouldn't there be two traversals? One to get from the start node to the parent node (outbound), and then another from that parent node down to all children (inbound)? -- You received this message because you are subscribed to the Google Groups "ArangoDB" group. To unsubscribe from this group

[arangodb-google] Re: AQL: Logical or technical Update Issue

You are right, it does not work that way. There's actually some rework to be done if you want to do more than group and count. I can show you how to multiply count and rating, but first I need another piece of information from you: We have multiple movies per user, each connection between them

[arangodb-google] Re: Graph based recommendation engine

Hi Michael, while I don't have ready-made instructions how to model your use case with a graph and what implication the design may bring with it, I think that you should take a look at our learning material about ArangoDB (not necessarily limited to the graph aspects). Once you know what

[arangodb-google] Re: REGEX_TEST()

To clarify: Both statements true. The Javascript implementation uses the RegExp object, which is implemented in V8 using the ICU regex matcher. Our C++ implementation uses the ICU RegexMatcher directly. The C++ implementation is the one that is commonly used. The JS implementation is merely a

[arangodb-google] Re: How to propose an enhancement request? - automatic unloading of collections

Hi Dave, the best place to submit feature requests is on GitHub: https://github.com/arangodb/arangodb/issues/new We can keep track of things there best. If you don't have a GitHub account, I can create an issue on your behalf. Best, Simran -- You received this message because you are

[arangodb-google] Re: AQL: Logical or technical Update Issue

COLLECT clears all variables in the current scope. Click on Explain the web interface and inspect the execution plan: Follow the CollectNode

[arangodb-google] Re: CRUD web app TUTORIAL for node and VUE.js

Hi Ludwig, be sure to check out our learning material if you want to get started with ArangoDB: https://arangodb.com/arangodb-training-center/ If you're mostly interested in ArangoDB's query language, have a look here: https://docs.arangodb.com/3.3/AQL/Tutorial/ Best, Simran -- You

[arangodb-google] Re: grayed-out but not in-active: An ArangoDB UI Question

Hi Jeff, this seems to be the default design of the 3rd party widget we use in the Web UI: https://github.com/josdejong/jsoneditor We could overwrite the style, but maybe you want to report this issue to the maintainers of the jsoneditor repository instead? I created a ticket on your behalf:

[arangodb-google] Re: ArangoDB bechmark with YCSB error

If I read that correctly, the Python script is unable to find ./bin/ycsb So maybe you're in the wrong working directory? Or is has to be ./bin/ycsb.exe or something like that? -- You received this message because you are subscribed to the Google Groups "ArangoDB" group. To unsubscribe from

[arangodb-google] Re: Arangodb cluster is not running after system reboot

Hi Rohan, please create an issue on Github and fill out the information of the template (in particular how you start the cluster, with what configuration and which software version and OS you use): https://github.com/arangodb/arangodb/issues/new Thanks, Simran -- You received this message

[arangodb-google] Re: Middleware Software to process ArangoDB Data directly

For data-centric services, there is Foxx. But if I understand correctly, what you ask for is basically something like Node.js running inside of the database. That is not a good idea however. Node.js is asynchronous and single-threaded, whereas the database system is synchronous and

[arangodb-google] Re: ArangoDB Graph Traversal for bank account number (money transfer)

Do I understand this correctly: All you have is a single CSV as shown, which is essentially one edge document per line? And no source file with vertices? If so, first correct your input data: date,amount,name,_from,_to 25-02-2018,900.00,Ibrahim,5196030001,5196030002

[arangodb-google] Re: Merge Vertices in graph traversal

What is the current result and what the expected result of the query? -- You received this message because you are subscribed to the Google Groups "ArangoDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to arangodb+unsubscr...@googlegroups.com. For

[arangodb-google] Re: Query optimization

Please post the explain output with the execution plan as well, thanks! -- You received this message because you are subscribed to the Google Groups "ArangoDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to arangodb+unsubscr...@googlegroups.com. For

[arangodb-google] Re: Arango DB graph and a large number of results

Hi James, can you please provide more information about your setup? See the issue template on GitHub what information we need. Actually, it would be great if you could create an issue over there, as we can track is better on GitHub: https://github.com/arangodb/arangodb/issues/new Thanks,

[arangodb-google] Re: Request database optimisation

Hi Killian, it would be helpful to see your exact index definitions, some example documents and to know a bit about the data distribution. How many documents end up in one group here on average? COLLECT code=b.code, category_id=b.category_id INTO code_group What do you actually want to

[arangodb-google] Re: Create child (new vertices) and link (new edge) to parent (existing vertices) in AQL INSERT

Hey Kieran, great that you figured it out already! Query results are always arrays, even if there is only a single return value. This also applies to sub-queries. FIRST(...) is the recommended way to pick the value, because for sub-queries you already have the parentheses in place and it's

[arangodb-google] Re: Loop through whole collection

> > ... but in one single continuous timelapse. With the appropriate > pagination (the infamous RIDs) we could pause our process and resume it > later on (for whatever reason, crash of the system, connectivity problem > and such). > Cursors have a TTL, but in the event of a server crash they

[arangodb-google] Re: Loop through whole collection

Hey Cyprien, there is nothing that directly compares to RIDs or what I would call physical pointers in ArangoDB as far as I can tell. There are some alternatives however. For example, you could add an attribute with a numeric value or an ISO date an create a sorted index over it. If you want

[arangodb-google] Re: Where can I find docs about internal data structures used by arangodb for graphs?

Hi Amos, you might be interested in this blog article: Index Free Adjacency or Hybrid Indexes for Graph Databases Read about the internal storage format in general: VelocyPack

[arangodb-google] Re: Loop through whole collection

Hey Cyprien, it's going well, thanks! In general, yes, using LIMIT with a high offset can take more time than to return the first few documents if there's a huge dataset to process to answer the query. But it depends on the exact query. Reading all content of the documents can be avoided in

[arangodb-google] Re: Help with filters in AQL

Hi Ismael, > > if I understand correctly, you want to find all documents which have a top-level attribute "carga" and either a sub-attribute "anual" or "diario", regardless of their value. A simple query to achieve this would be as follows: FOR doc IN ons FILTER doc.carga.diario != null OR

[arangodb-google] Re: Why ArangoDB don't has a native live query yet?

You can find a lengthy discussion on Github regarding this: https://github.com/arangodb/arangodb/issues/602 If I understand correctly, for your use case it would be sufficient to have document-level triggers for a collection "orders" to do something when a new order document is created (or

[arangodb-google] Re: Multi-master support?

What do you understand under or expect from a "true" multi-master support? In an ArangoDB cluster, you can talk to any coordinator to e.g. issue an AQL query. Only one or a few DB-Servers may store the data you ask for, but because every request goes through a Coordinator, you do not need to

[arangodb-google] Re: Simple "filtering", "joining" views

Hi James, filtering as you described it is not supported so far, but there is already a feature request: https://github.com/arangodb/arangodb/issues/5650 Not sure about your second request. Why do you store the role name in a normal document and also on the edge in the first place? I think

[arangodb-google] Re: Don't want all the intermittent parts of traversal

You can do a second traversal with depth = 1 to check if you reached a leaf node (no more incoming edges). Based on this information, the “short” paths can be filtered out. Note that a second condition is required: it is possible that the last node in a traversal is not a leaf node if the

[arangodb-google] Re: arangojs: keepNull not an option for collection.save?

Duplicate of https://stackoverflow.com/questions/58941526/arangojs-keepnull-not-an-option-for-collection-save -- You received this message because you are subscribed to the Google Groups "ArangoDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to