Michael Hunger jexp

	URL	Title
	/series/ninety-nine-percent-invisible	99% Invisible
	/series/new-books-in-architecture-2421478	New Books in Architecture
	/series/rebuilding-the-renaissance	Rebuilding The Renaissance
	/series/blueprint-for-living-full-program-78888	Blueprint For Living - Full program
	/series/kunstlercast-suburban-sprawl-a-tragic-comedy	KunstlerCast - Suburban Sprawl: A Tragic Comedy
	/series/business-of-architecture-podcast	Business of Architecture Podcast
	/series/failed-architecture	Failed Architecture
	/series/scaffold	Scaffold
	/series/on-the-bench-1522321	On The Bench

Most frequent issues in Cypher Statements

How can you prevent this? Check your statements before you run them, best with EXPLAIN that parses them without execution. Use Integration Tests, e.g. with Docker/Testcontainers to check your cypher queries against your current database/dataset.

Slow MERGE

MERGE fails on Null

Conways Game of Life in Cypher

John Conway (RIP) created the amazing game of life automaton, which is based on a simple rule.

Every cell that has either exactly 3 neighbours or was alive and has 2 neighbours is alive in the next generation.

https://en.wikipedia.org/wiki/Conway%27s_Game_of_Life

Must Watch: https://www.youtube.com/watch?v=FdMzngWchDk

	{
	"laureates": [
	{
	"id": "745",
	"knownName": {
	"en": "A. Michael Spence",
	"se": "A. Michael Spence"
	},
	"givenName": {
	"en": "A. Michael",

	with split($input, "\n\n") as elves
	unwind elves as elf
	return reduce(s=0, c in split(elf,"\n") \| s + toInteger(c)) as total
	order by total desc limit 1;


	with split($input, "\n\n") as elves
	unwind elves as elf
	with reduce(s=0, c in split(elf,"\n") \| s + toInteger(c)) as total
	order by total desc limit 3

	///usr/bin/env jbang "$0" "$@" ; exit $?

	//JAVA 17
	//DEPS org.neo4j:neo4j:5.2.0

	import static java.lang.System.*;
	import org.neo4j.dbms.api.*;
	import org.neo4j.graphdb.*;
	import java.nio.file.Path;
	import java.util.Map;

	{
	"Services": [
	{
	"ServiceCode": "AWSCloudMap",
	"ServiceName": "AWS Cloud Map"
	},
	{
	"ServiceCode": "a4b",
	"ServiceName": "Alexa for Business"
	},

	unwind range(2010,2022) as year unwind range(1,365) as day create (d:Date {year:year, day:day});
	// Added 4745 labels, created 4745 nodes, set 9490 properties, completed after 194 ms.
	create index for (d:Date) on (d.year);


	:auto unwind range(2010,2022) as year unwind range(1,365) as day match (d:Date {year:year, day:day})
	unwind range(1, 1000) as id
	call { with id,d
	create (l:LineItem {revenue:rand()1000, quantity:toInteger(rand()100)})
	create (l)-[:ON_DATE]->(d)


	with [x in range(1,10) \| rand()] as values
	return values as result;

	/*
	+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
	\| result \|
	+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
	\| [0.659425004010523, 0.8694425986764492, 0.9257514428672218, 0.953247608626841, 0.19473427486287131, 0.41928993743169174, 0.9691737560680762, 0.564805684330218, 0.5061905379193724, 0.5653656414569036] \|
	+--------------------------------------------------------------------------------------------------------------------------------------

	Year;(semi-) final;Edition;Jury or Televoting;From country;To country;Points ;Duplicate
	1975;f;1975f;J;Belgium;Belgium;0;x
	1975;f;1975f;J;Belgium;Finland;0;
	1975;f;1975f;J;Belgium;France;2;
	1975;f;1975f;J;Belgium;Germany;0;
	1975;f;1975f;J;Belgium;Ireland;12;
	1975;f;1975f;J;Belgium;Israel;1;
	1975;f;1975f;J;Belgium;Italy;6;
	1975;f;1975f;J;Belgium;Luxembourg;0;
	1975;f;1975f;J;Belgium;Malta;7;