March 2013 Summaries

Neo4j.org has launched with a new look, aiming to make it easier for users to get started with the database and learn about graph databases. The site provides a range of resources, including step-by-step instructions, screencasts, and learning paths, to help users navigate Neo4j. A consistent layout and usability features are also being implemented, such as interactive graphs, quick links, and a site search, to facilitate finding relevant content. The site is hosted on GitHub, inviting contributions from the community, including new pages, content, and layout fixes. Additionally, related content can be submitted for addition to topic pages, expanding the learning paths and content offerings.

The author, who lacks programming skills, was looking for a simple way to import data into Neo4j. They created a spreadsheet with two parts: the first containing data for nodes and relationships, and the second providing instructions on how to create Cypher statements from these columns using string concatenation and Neo4j syntax. The Cypher statements allow users to create nodes with specific properties and relationships between them, referencing node IDs in other columns. A separate instruction sheet provides step-by-step guidance on how to use the data import sheet, including downloading Neo4j, wrapping Cypher statements in transactions, enabling auto-indexing, and starting the server. The spreadsheet is available for download, along with a free copy of O'Reilly's Graph Databases ebook.

The Neo4j team has announced the latest milestone in their 1.9 release cycle, focusing on improving the production environment rather than introducing significant changes. Java7 is now officially supported as the default runtime, and improvements have been made to High Availability and clustering protocols for more efficient cluster communication. The IndexProvider interfaces are now aligned with normal kernel extensions, enhancing system design consistency. Additionally, Cypher profiling has been introduced, allowing users to analyze query performance and optimize their queries. A new PROFILE neo4j-shell command provides detailed execution plan metrics and result output, making it easier to diagnose and tune Neo4j databases.