Event date:

For our April meeting, we are pleased to announce Ruling the Hierarchy - Storing and querying hierarchical data in a relational database by Philip Brown. With pizzas provided by Sharpe Recruitment, venue provided by Campus North, and additional sponsorship from Opia and Better Brand Agency.

The event will take place at Campus North, Carliol Square, Newcastle Upon Tyne, NE1 6UF (map).

The event is free and open to all, but please sign up online so that we have an idea of numbers for the venue and catering. Feedback, suggestions and ideas for future topics are welcome on Twitter.

Ruling the Hierarchy by Philip Brown

Hierarchical data is a common requirement in web applications. From ecommerce product taxonomies to folder structures, storing and querying that data in an efficient manner is tricker than it might seem.

This talk will walk you through the most common methods for storing and querying hierarchical data in a relational database. We will look at the positives and negatives of each method, when each might be appropriate, and we will take a deeper dive into one of the methods that enables Papertrail to store and quickly query hundreds of thousands of folders for thousands of customers.

Philip is a developer at papertrail.io, a Software-as-a-Service product which helps companies comply with health and safety legislation. You can find his blog at culttt.com.

After the event, many of us will be going to the Ware Rooms next door for some liquid refreshments.