Questions tagged [arangodb]

ArangoDB is a multi-model NoSQL database with a flexible data model for documents, graphs, and key-values collections.

ArangoDB is a multi-model NoSQL database with a flexible data model for documents, graphs, and key-values collections. It targets high-performance applications using a convenient declarative query language AQL and JavaScript extensions.

Useful links

Articles


Related tags :

1967 questions
7
votes
1 answer

ArangoDb - How to count number of filtered results before limiting them

db.query(aql ` FOR doc IN ${collection} FILTER REGEX_TEST(CONCAT(VALUES(doc, true)), ${queryStr}, true) SORT doc[${sortBy}] ${dir} LIMIT ${start, count} RETURN doc._key `) .then(cursor => { …
Yuvaraj V
  • 1,020
  • 2
  • 16
  • 28
7
votes
2 answers

How to count number of elements with AQL?

I need to count elements that was in result of SQL query: db._query('FOR v in visitors FILTER v.ip == "127.0.0.1" return COUNT(v.guid) ') This request is return my a length of every GUID, but I need to get total number of GUIDs for example: 2.
Dmitry Bubnenkov
  • 9,415
  • 19
  • 85
  • 145
7
votes
1 answer

Getting "ArangoError: bind parameter 'value1' was not declared in the query (while parsing)"

I have such code in my Foxx app: db._query(aqlQuery` FOR d IN FULLTEXT('api_texts', '${args.attribute}', '${args.search}') SORT d.${args.sort_by} ${args.sort} LIMIT ${args.skip}, ${args.limit} RETURN d `).toArray() It seems to be…
artnikpro
  • 5,487
  • 4
  • 38
  • 40
7
votes
3 answers

Storing tags in a graph database

I've found some advice for setting up tagging systems in relational and document databases, but nothing for graph/multi-model databases. I am trying to set up a tagging system for documents (let's call them "articles") in ArangoDB. I can think of…
ropeladder
  • 1,103
  • 11
  • 24
7
votes
1 answer

ArangoDB - how to implement a custom recommendation engine using graph?

Lets say we have a database of food items such as: item1 = {name: 'item1', tags: ['mexican', 'spicy']}; item2 = {name: 'item2', tags: ['sweet', 'chocolate', 'nuts']}; item3 = {name: 'item3', tags: ['sweet', 'vanilla', 'cold']}; And we have a user…
Stan Lee
  • 117
  • 5
7
votes
1 answer

Passing parameters to db.query with arangojs

I'm having problems sending parameters with the ArangoJS library and was wondering if anyone could help. With the example below, it is possible to execute db.query if parameter values are in the query, but as soon as I try to use bindVars I get…
David Thomas
  • 2,264
  • 2
  • 18
  • 20
7
votes
1 answer

In ArangoDB, will querying, with filters, from the neighbor(s) be done in O(n)?

I've been reading Aql Graph Operation and Graphs, and have found no concrete example and performance explanation for the use case of SQL-Traverse. E.g.: If I have a collection Users, which has a company relation to collection Company Collection…
TruongSinh
  • 4,662
  • 32
  • 52
7
votes
2 answers

data model for tree structure (file system): document model vs graph model

I'm evaluating a nosql solution for implement a file system like structure, with millions of items, where key features have to be: speed finding "parents" or "direct childs" or "subtree childs" of an item filtered by n item properties, with page…
Claudio
  • 133
  • 2
  • 11
7
votes
1 answer

Why is org/arangodb/request synchronous?

Why is the new JavaScript module request synchronous? Is it supposed to be only used in a job queue? Is there any way to make asynchronous http(s) requests in ArangoDB?
7
votes
2 answers

Randomly select a document in ArangoDB

Is there a way to randomly return a document from a collection using AQL? I would like to create a random graph for testing purposes. I have not yet figured out how to select documents at random from the collection. I was hoping I might be able to…
mikewilliamson
  • 24,303
  • 17
  • 59
  • 90
7
votes
1 answer

How receive over 1000 documents from ArangoDB collection?

I have a collection. My collection has 30 000 000 documents. I want to receive all its by means AQL query. I do so: FOR c FROM MyCollection SORT c.value ASC LIMIT 30000000 RETURN c.id But I receives no more 1001 documents. Why?
jonua
  • 1,915
  • 3
  • 17
  • 27
7
votes
2 answers

What are the user defined key's value restrictions?

In ArangoDB, when a collection is defined to allow user defined keys, what are the restrictions on the value of the key? For example, it appears that a key of "Name-2" works but a key of "Name,2" gives ArangoError 1221: invalid document key error.
WiredPrairie
  • 58,954
  • 17
  • 116
  • 143
7
votes
1 answer

ArangoDB: (1 Graph with several Edge Definition) Vs (1 Edge Definition per Graph)

I was wondering if there is any advantage to having several edges definition in one single graph Vs having several graphs each one with a single edge definition. Thanks for you help,
tariqdaouda
  • 2,506
  • 2
  • 13
  • 14
7
votes
1 answer

Does Foxx/ArangoDB Server support Socket.IO?

I was wondering if Foxx/ArangoDB supports Socket.io ? Or would I have to fire a separate Express.js server if I want to use sockets.io ?
Quang Van
  • 11,475
  • 12
  • 57
  • 61
6
votes
2 answers

ArangoDB - Backup and restore all data

My aim is to create the arango database dump (with all the users and passwords, permissions, databases, collections, roles and so on) and then make a full restore of this data on the other arango server (that was installed from scratch and empty). I…
dice2011
  • 937
  • 2
  • 15
  • 30