Get the latest tech news

SQL needed structure

Here are two pages from the internet movie database: There are two things to note about these pages. - The data on the page is presented in a hierarchichal structure.

Let's grab the imdb public dataset and try to reproduce the source data for that movie page (or at least a subset of it, because I didn't bother importing all the tables). Through the magic of joins we have retrieved all the data we need and it only required holding a transaction open for 4 network roundtrips. We make tools to serve our purposes, and our purposes have changed a hell of a lot since the 70s, when the main client of a database was a human typing sql character by character into an interactive transaction on a teletype connected to a mainframe with 500kb of RAM, almost 20 years before the invention of the world wide web.

Get the Android app