ArangoDB

http://127.0.0.1:8529
User: root
Database: _system

https://arangodb.example.com:8529
User: app_user
Password: secret
Database: production
TLS: true

http://localhost:8529
User: developer
Database: myapp

// Return all documents
FOR doc IN users
  RETURN doc

// Filter documents
FOR doc IN users
  FILTER doc.age > 25
  RETURN doc

// Limit results
FOR doc IN users
  LIMIT 100
  RETURN doc

// Sort results
FOR doc IN users
  SORT doc.name ASC
  RETURN doc

INSERT {
  name: "Alice",
  age: 30,
  email: "alice@example.com"
} INTO users

FOR doc IN users
  FILTER doc.name == "Alice"
  UPDATE doc WITH { age: 31 } IN users

FOR doc IN users
  FILTER doc.age < 18
  REMOVE doc IN users

FOR user IN users
  FOR order IN orders
    FILTER order.userId == user._key
    RETURN {
      user: user.name,
      order: order.total
    }

FOR doc IN users
  COLLECT status = doc.status WITH COUNT INTO total
  RETURN {
    status: status,
    count: total
  }

FOR v, e, p IN 1..3 OUTBOUND "users/alice" friendships
  RETURN {
    friend: v.name,
    distance: LENGTH(p.vertices)
  }

-- Create database
CREATE DATABASE mydb;

-- Drop database
DROP DATABASE mydb;

-- Create collection
CREATE COLLECTION mycollection;

-- Create collection in specific database
CREATE COLLECTION mydb.mycollection;

-- Drop collection
DROP COLLECTION mycollection;

-- Drop collection from specific database
DROP COLLECTION mydb.mycollection;

-- Query collection in different database
FOR doc IN mydb.users
  LIMIT 10
  RETURN doc

FOR loc IN locations
  FILTER DISTANCE(loc.lat, loc.lng, 40.7128, -74.0060) <= 1000
  RETURN loc

FOR doc IN FULLTEXT(articles, "content", "query,string")
  RETURN doc

FOR user IN users
  LET orderCount = (
    FOR order IN orders
      FILTER order.userId == user._key
      RETURN 1
  )
  RETURN {
    user: user.name,
    orders: LENGTH(orderCount)
  }