Weekly Newsletter, April 30, 2015

ArangoDB related (Drivers & more)

New drivers & more:

Updated drivers & more:

More »

Posted in Newsletter | Leave a comment

ArangoDB Team in Silicon Valley / San Francisco

ArangoDB’s outpost in the Bay area is getting more and more crowded. CTO Frank @fceller has joined the team of our CEO Claudius @weinberger, and ArangoDB´s lead developers: Max @neunhoef & Michael @mchacki. The latter are in San Francisco for a while already.

You can meet our team by attending several Meetups, the Collision Conf in Vegas (5-7 May) or at the @GeekdomSF office at Folsom Street #100, near Moscone Center. Get in touch, grab’ a coffee and join the discussions about NoSQL and multi-model databases. We are here to stay – at least until the end of May. More »

Posted in General | Leave a comment

Exporting Data for Offline Processing (in PHP)

A few weeks ago I wrote about ArangoDB’s specialized export API.

The export API is useful when the goal is to extract all documents from a given collection and to process them outside of ArangoDB.

The export API can provide quick and memory-efficient snapshots of the data in the underlying collection, making it suitable for extract all documents of the collection. It will be able to provide data much faster than with an AQL query that will extract all documents.

In this post I’ll show how to use the export API to extract data and process it with PHP.

Please read the full blog post Exporting Data for Offline Processing.

Posted in API | Leave a comment

Weekly Newsletter, April 23, 2015

Webinar

Learn more about creating data-centric microservices in our Webinar on April, 29th.

Register today!

More »

Posted in Newsletter | Leave a comment

AQL Functions Improvements

Waiting for a git pull to complete over an 8 KiB/s internet connection is boring. So I thought I’d rather use the idle time and quickly write about some performance improvements for certain AQL functions that were recently completed and that will become available with ArangoDB 2.6.

The improvements affect the following AQL functions:

  • UNSET(): remove specified attributes from an object/document
  • KEEP(): keep only specified attributes of an object/document
  • MERGE(): merge the attributes of multiple objects/documents

This blog post shows a few example queries that will benefit from 50 to more than 60 % reductions in query execution times due to the changes done to these functions.

More »

Posted in General | Leave a comment

COLLECTing With a Hash Table

ArangoDB 2.6 will feature an alternative hash implementation of the AQL COLLECT operation. The new implementation can speed up some AQL queries that can not exploit indexes on the COLLECT group criteria.

This blog post provides a preview of the feature and shows some nice performance improvements. It also explains the COLLECT-related optimizer parts and how the optimizer will decide whether to use the new or the traditional implementation.

More »

Posted in Performance, Query Language | 2 Comments

Creating Multi-Game Highscore Lists

I just came across a question about how to create highscore lists or leaderboards in ArangoDB, and how they would work when compared to Redis sorted sets.

This blog post tries to give an answer on the topic and also detailed instructions and queries for setting up highscore lists with ArangoDB. The additional section “Extensions” explains slightly more advanced highscore list use cases like multi-game highscore lists, joining data and maintaining a “last updated” date.
More »

Posted in API, Documentation, Query Language | 3 Comments

Collision Conf 2015

collision

We are looking forward to joining the tech crowd at the Collision Conf that will take place in just a few weeks. Join us at this amazing event downtown Las Vegas on 5–6 May 2015.

As a sister event of Web Summit – Europe’s largest tech conference attracting over 20,000 attendees from around the world – Collision is a new type of tech conference for America: “A meeting place for people who are both building the companies of tomorrow and managing the companies of today.” – (Collision Conf)

We are proud to get a chance to share our vision on multi-model databases and present ArangoDB to the world during a Startup-Pitch. We will also demonstrate our latest developments on DCOS integration at our booth. The team is currently working on an exciting Demo to show the crowd how excellent multi-model database can be. More »

Posted in Conferences | Leave a comment

AQB Updated: Write More Readable Queries

The latest update to the AQL Query Builder for JavaScript addresses a major pain point: the “prefix notation” or LISP style syntax of AQL operator methods. Instead of calling the operator methods on the query builder object itself, you can now directly call them as methods on value objects.

Let’s say you want to write a query that takes all non-admin users with a power level over 9000 and returns their score rounded to the closest 100. In plain AQL this could be written like this:

More »

Posted in Javascript | Leave a comment

Create an ArangoDB cluster on Google Compute Engine with a single command

Last week we’ve released the first version of our new deployment tool for cloud computing platforms with Digital Ocean support. Today we show how to deploy an ArangoDB cluster on Google Compute Engine with a single command.

Google Compute Engine

To easy-deploy an ArangoDB cluster on Google Compute Engine you just need to install the official gcloud tool, download a single bash script and watch the tool take care of the rest for you.

Google Compute Engine prerequisites

The script needs an available and configured Google Project.

ProjectID
  • Create a project (GCE Projects).
  • Remember your project-id, you’ll need that later for gcloud configuration.
  • Enable Google Compute Engine API More »

Posted in Documentation | Leave a comment