I am a newbie and trying to get going on ArangoDB.I want to run a batch of AQL queries which would be interdependent on each other. I want to do the same things we do in PL-SQL. I tried clubbing two or more queries in one post/get request through FOXX but didn't work. Can someone suggest me a better way to do this? or a tutorial for this?
How to run a sequnce of AQL queries in arangodb
546 Views Asked by Nikhil Gaikwad At
1
There are 1 best solutions below
Related Questions in ARANGODB
- ConcurrentModificationException happen for findAllById in arangodb-spring-data with concurrent workers
- How to exclude a weaved property from an entity in Spring Data?
- How to Pass-in a Collection name and Document Key to an AQL query to update the document
- Convert ArangoDB query to MongoDB query
- How can I connect to a local ArangoDB database from an Appsmith Javascript Object from Windows 10
- ArangoDB waits infinitely after issuing start command by arangodb
- ArangoDB AQL Upsert Operation Clears CreateDate on Update Instead of Only on Insert
- ArangoDB prompts to enter the root password despite the authentication is disabled in the command line
- In ArangoDB AQL is there anything like mysqli_real_escape_string?
- AQL query takes 30+ seconds
- ArangoDB and ldap
- Getting error "expecting POST /_api/cursor" from ArangoDB.js
- ArangoDb: Is it possible to determine the direction of the current path?
- Is it possible to insert only if query returns no results
- ArangoDB on K8S: thousands of Open FD filedescriptors
Related Questions in FOXX
- How to return an zip file from Foxx- arangodb?
- Foxx service erroring out
- ArangoDB Foxx Service ReferenceError: URL is not defined
- Body parameter in ArangoDB
- Foxx ArangoDB update data
- Using foxx microservices vs pyarango
- How to validate Oauth access token in foxx framework
- ArangoDB AQL Fragments Issue
- How to provide authentication credentials to foxx integration tests
- AQL: Bind parameter on operator
- Foxx arangodb runs into memory limit
- How to create JWT token in arangodb by using foxx microservices?
- ArangoDB Foxx: require() returned undefined
- What kind of object db._collections() return ArangoDB?
- ArangoDB comparison of documents in different databases
Related Questions in ARANGODB-FOXX
- How to write custom graph algorithms in arangodb, this must run internally?
- Unable to call a Spring boot Rest Endpoint from arangodb Foxx service in a docker network
- Prometheus invalid metric type "status=\"available\"} gauge" + 401
- ArangoDB Foxx Service ReferenceError: URL is not defined
- Body parameter in ArangoDB
- How to reliably schedule regularly reoccurring jobs with arangodb?
- Using foxx microservices vs pyarango
- ArangoDB microservice dependent on other microservice
- How to create JWT token in arangodb by using foxx microservices?
- LIKE operator not supported in arango search view
- Using Foxx CLI to Create Service
- pyArango vs. Foxx Microservices
- ArangoDB AQL: find null object, which is not part of the query
- Is there a way to get the same output on a foxxservice as on the arangosh?
- ArangoDB comparison of documents in different databases
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
It all depends what is the client accessing the database.
E.g. we are using Java and the java driver to access ArangoDB. Then either transaction call or AQL query with subsequent AQL queries can be made.
The question is, if the AQL queries are interdependent on each other, why whould you run them in one request? How would you get the results of each one?
Take a look at Gremlin language (it is a Graph language), you would find that it uses WebSockets and result of one query is returned in a binary way through WS... Thus batching such queries wouldn't have any sense. (just a note, ArangoDB also has a provider for the Gremlin API).
I expect, if you are accessing ArangoDB through HTTP. And now you are trying to save http requests. If that is the case I would recommend writing your own API layer, which would expose interface, where you would be able to batch the requests. However the API layer would make 2 calls to Arango (e.g. in parallel), getting the results and somehow merging them to the final output.