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
545 Views Asked by Nikhil Gaikwad At
1
There are 1 best solutions below
Related Questions in ARANGODB
- ArangoDb get latest document from all collections
- ArangoDB graph operations via REST API
- Opening Foxx API to local network
- How do I access inserted document's _id within a transaction in ArangoDB
- How to approximate execution time of ArangoDB count function
- How to read data from collection in an ArangoDB Foxx app?
- ArangoDB document database and also a graph database? How is it possible?
- Validating array items with joi in a Foxx app
- GRAPH_TRAVERSAL result enclosed in (Array of) Array of Array in Arangodb
- number of 'graphs' in a ArangoDB database
- In Python, how do I create an edge collection and document for an arangodb?
- Arangodb import via http api using node.js
- Is ArangoDB edge document right place to put additional key-value?
- How to call external function in background tasks in arangodb
- ArangoDB create Vertex REST API without knowing the vertex id's
Related Questions in FOXX
- Opening Foxx API to local network
- How to read data from collection in an ArangoDB Foxx app?
- Validating array items with joi in a Foxx app
- arangodb 3.1 foxx docs?
- Can I create javascript function from remote in arangodb
- Foxx apps debugging workflow?
- Recompiling JS in the arangodb codebase? (trying to hack sth into Foxx)
- How to return an zip file from Foxx- arangodb?
- Using foxx microservices vs pyarango
- Does the consistance of collections in a graph in ArangoDB guaranteed?
- When does arangodb's foxx collects garbage?
- aql.literal is not a fucntion in arangoDB Foxx
- ArangoDB: Use an objects as a filter and build AQL with aql builder
- Foxx ArangoDB update data
- What does building an application in Arango Foxx offer beyond a regular node application
Related Questions in ARANGODB-FOXX
- How to write custom graph algorithms in arangodb, this must run internally?
- Using foxx microservices vs pyarango
- Prometheus invalid metric type "status=\"available\"} gauge" + 401
- pyArango vs. Foxx Microservices
- Body parameter in ArangoDB
- running Foxx-cli on linux -- foxx: command not found
- ArangoDB: getting started with Foxx Microservices: 404: errorMessage: unknown path
- ArangoDB Foxx Microservices Getting Started tutorial: what is a working URI for this example?
- How to reliably schedule regularly reoccurring jobs with arangodb?
- ArangoDB comparison of documents in different databases
- Is there a way to get the same output on a foxxservice as on the arangosh?
- How to create a service in web interface without creating a collection named not "xxx_xxx" but "xxx"?
- Using Foxx CLI to Create Service
- ArangoDB microservice dependent on other microservice
- ArangoDB AQL: find null object, which is not part of the query
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 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.