This Week in Neo4j – 16 September 2017


Welcome to this week in Neo4j where we round up what’s been happening in the world of graph databases in the last 7 days.


This week’s featured community member is Bruno Peres, Programmer at GeoSapiens.

Bruno Peres - This Week's Featured Community Member

Bruno Peres – This Week’s Featured Community Member

If you’ve been following TWIN4j you’ll almost certainly have heard Bruno mentioned in previous editions – he’s one of the most frequent answerer of Neo4j and Cypher questions on StackOverflow.

Every week when I write this blog post I take a look at the StackOverflow active tab on the Neo4j community graph, and Bruno is always in the top 3.

I’ve learnt some cool things from reading Bruno’s answers such as how to add a temporary property to a node using map projections and just this week how to write a query that finds the intersection of multiple starting nodes.

On behalf of the StackOverflow and Neo4j communities, thanks for all your work Bruno!

Online Meetup: Analysing the Kaggle Instacart dataset


In this week’s online meetup Jonathan Freeman showed us how to analyse the data from Kaggle‘s Instacart Market Basket Analysis competition.



Jonathan shows how to import a subset of the dataset using Cypher’s LOAD CSV clause before using the neo4j-import tool to load the full dataset.

He also writes queries to find vegetarians, vegans, and proposes Instafood – an (at the moment) imaginary application that sets people up on dates based on common food preferences!


Graphoetry: Poetry about graphs


For something different this week we’ve got a poem about graph databases written by Dom Gittins.


On StackOverflow: MERGE confusion, Subqueries, Shortest path with predicate checks


This week on Neo4j StackOverflow…​

From The Knowledge Base


This week in the Neo4j Knowledge Base Rohan Kharwar shows how to write a Cypher query to kill transactions that take longer than X seconds and don’t contain certain keywords.

Telegram Recipes bot, Chemistry Recommendation Engine, Feature Toggles Graph


    • Alexey Kalina created RecipesTelegramBot, a Telegram bot that makes recipe recommendations.
    • Richard J. Hall, Christopher W. Murray, and Marcel L. Verdonk published The Fragment Network: A Chemistry Recommendation Engine Built Using a Graph Database. The authors run a series of algorithms over Chemical compounds to generate a graph of 23 million nodes and 107 million relationships explaining the similarity between them.
    • Pedro Moreira created toggling-it, an application that lets you create toggles for your applications based on toggle-groups and tags. You can also run “what if” analysis to see the knock on effects of enabling/disabling your toggles.
    • I came across python-norduniclient, a Neo4j database client for NORDUnet network inventory. NORDUni is a project for documenting and presenting physical network infrastructure as well as the logical connections between customers, services and hardware. It stores inventory data models in Neo4j.

Tweet of the Week


My favourite tweet this week was by Urmas Heinaste:

Don’t forget to RT if you liked it too.

That’s all for this week. Have a great weekend!

Cheers, Mark