While working hard on the next release and hacking away new interesting things to include into our favourite database, we decided to take a short break to have some fun just in time for Easter. All teams gathered together to do some Easter eggs coloring, chocolate-eating and fun-having ๐Ÿ™‚

Weโ€™ve colored a lot of eggs in our favourite colors – green and brown, and hid them all around our office and beyond. Now, here is a little challenge for you to help us find them.

Download the dataset -> arangodb-easter-dump.zip and unzip it. Then use arangorestore to load the dataset into your ArangoDB instance. This is normally done by running the following command from a command-prompt:

arangorestore path-to-unzipped-data --create-database --server.database arangodb-easter-dump

Then open the query page in WebUI and letโ€™s start playing!

For our egg hunt we want to search our dataset for specific eggs that were hidden by the members of our marketing team. To make it slightly more challenging we only search for those eggs that are colored in at least one of the primary colors of our logo. Also the eggs we are looking for were hidden after the 3.3 release of ArangoDB, because no one likes old eggs. At the end we want to order them by the distance to ArangoDB office in Cologne, Germany.

All you need is the following query and some knowledge to fill the gaps.

As you can see, the query uses bind parameters, which you have to fill in. You have to find out the following bind parameters: 3.3 release date (format yyyy-mm-hh); logo primary colors (format e.g. purple); cologne office location (latitude and longitude);

On the right side of the screen in the query editor, you have to set the bind parameters view to JSON, copy the following into it, and change the values in between “” to the correct parameters that you found out!

Let us know what you found – tweet a screenshot of your results using #ArangoDB #database and wish us a Happy Easter, too!

We wish you a lovely weekend and have fun!