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.
Featured Community Member: Bruno Peres
This week’s featured community member is Bruno Peres, Programmer at GeoSapiens.
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!
Cypher linter, Cypher on Flink, A Python object oriented interface for Cypher
- Chris Leishman updated libcypher-parser, a parser library and lint tool for Cypher.
- The video of the Cypher-based Graph Pattern Matching in Apache Flink talk that my colleagues Martin Junghanns and Max Kießling presented at Flink Forward is now available.
- Dom Weldon created oopycql, an object-oriented interface for managing Cypher queries in Python.
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…
- Andrew Bowman helps solve some confusion around the Cypher MERGE clause.
- Jonathan March optimises a query that contains a shortest path search combined with predicate checks.
- stdob– explains how to use CASE expressions to calculate passion and disdain scores in a social graph.
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.
What’s happening next week in the world of graph databases?
September 19th 2017
September 19th 2017
Building A Full Stack Graph Application With GraphQL and Neo4j
September 19th 2017
Data science in Life science: Graphs, Machine Learning, and Notebooks
September 20th 2017
Tweet of the Week
My favourite tweet this week was by Urmas Heinaste:
I'm Lovin' the #Neo4j Sandbox. Check it out and learn about Graph DBs with fun datasets and guides. https://t.co/LEnU752mh5— Urmas Heinaste (@urma5h) September 14, 2017
Don’t forget to RT if you liked it too.
That’s all for this week. Have a great weekend!