Making Subqueries fast Subqueries in AQL are an expressive and useful tool when writing queries. And now with a rewrite of the query execution for release 3.6, they are also pretty fast. After laying the foundation with a major rework of the AQL internals in 3.5, we now improved the way subqueries are executed. This…

GeoJSON tutorial Motivation Starting with the mass-market availability of smartphones and continuing with IoT devices, self-driving cars ever more data is generated with geo information attached to it. Analyzing this data in real-time requires the use of clever indexing data-structures. Up to version 3.3, ArangoDB supported a basic subset of geospatial functions, which were able…

Search in ArangoDB – ArangoSearch ArangoSearch ArangoSearch is a natively integrated text search and ranking engine for information retrieval in ArangoDB. Detailed Tutorial Learn how to find terms in your data and rank them by relevancy, get familiar with the view concept and other features. ArangoSearch Docs Take a deep dive into the capabilities and…

Documents and ArangoDB AQL Tutorial Intro to ArangoDB’s Query Language Data Modelling Basics&Terminology of data models ArangoDB vs MongoDB Quick tutorial on performing queries Satellite Collections JOIN operations in a cluster Data Queries Documents model in ArangoDB ArangoDB ArangoGraph: Cloud Service for ArangoDB Start Your Free ArangoDB ArangoGraph Trial Other useful resources: Language Tutorials Additional…

Using arangodump and arangorestore with a multi-database installation When you want to manage full backups, migrate your data between different instances, or make breaking changes to how your cluster data is structured, you will likely find yourself using our arangodump and arangorestore tools. Typically these tools dump or restore a single database at a time, and default to the _system database.…

❯ SmartGraphs ❯ Pregel ❯ Smartifier ❯ Cytoscape ❯ Fault Tolerant Foxx ❯ Permissions with Foxx ❯ Satellite Collections ❯ User Management ❯ Geo Index Cursor Using The New ArangoDB Geo Index Cursor via AQL This tutorial will show you how to import OpenStreetMap data into an ArangoDB instance and execute efficient geo queries on your database.…

An introduction to TTL indexes ArangoDB 3.5 comes with an additional type of index, named “TTL index”. “TTL” means “time-to-live”, as this type of index can be used to automatically expire documents in a collection. Example use cases for TTL indexes include expiring sessions after a configurable time of inactivity, and the automatic purging of…

Schema Validation in 3.7 Check it out on github Last updated: 23/08/2023 15:05:13

Performance Course for Freshers If you made your first steps with AQL, played around with a few queries and now want to speed things up a bit, this course is for you. Within this course, we will discuss the most important strategies to speed up your queries. You will learn e.g. how and when to…

Insert with Overwrite Option With ArangoDB 3.7 there are a number of improvements to insert operations as well as the addition of some new functionality such as UPSERT and REPSERT. This post will detail some of these changes along with example in an interactive notebook. Check it out on github Last updated: 22/09/2020 00:27:26