Speaking
I've been doing public speaking since 2008, and from my initial origins doing talks to local user groups, I now regularly present technical talks and keynotes at a range of international conferences. If you'd like to invite me to speak at your conference, you can email me at andrew@aeracode.org.
I talk on a variety of topics, as you can see below - if you are interested in a talk, please contact me and I'll be happy to discuss what fits best! I particularly enjoy talking about software maintenance, architecture, safety, GIS, and the social side of software engineering.
All of my past and future talks, keynotes, panel appearances and tutorials are collected below, including links to slides and videos if they exist.
Past
89 talks
18th Oct
2023
Who put me in charge? Moving beyond day-to-day coding in Django
DjangoCon US
Durham, NC, United States of America
45 minutes,
Panel
22nd Apr
2023
Reconciling Everything
PyCon US
Salt Lake City, United States of America
Slides
30 minutes
19th Oct
2022
The State Of Django Panel
DjangoCon US
San Diego, United States of America
Video
30 minutes,
Panel
18th Oct
2022
Django Through The Years
DjangoCon US
San Diego, United States of America
Video
Slides
45 minutes
25th Aug
2022
Writing Maintainable Software At Scale
PyCon Estonia
Tallinn, Estonia
Slides
50 minutes,
Keynote
12th Jul
2021
A Newcomer's Guide To Airflow's Architecture
Airflow Summit
Online
Video
Slides
25 minutes
23rd Mar
2021
Async, Python, and the Future
Python Web Conference
Online
Slides
45 minutes,
Keynote
19th Sep
2020
How To Break Django: With Async
DjangoCon Europe
Online
Video
Slides
40 minutes
4th Sep
2020
Taking Django's ORM Async
PyCon AU
Online
Video
Slides
25 minutes
22nd Feb
2020
The Long Road To Asynchrony
PyCon Belarus
Minsk, Belarus
Slides
40 minutes,
Keynote
7th Feb
2020
The Scientist And The Engineer
PyCon Colombia
Medellín, Colombia
Video
Slides
60 minutes,
Keynote
3rd Oct
2019
Pioneering Real-Time
PyCon Balkan
Belgrade, Serbia
Slides
Keynote
23rd Sep
2019
Just Add Await: Retrofitting Async Into Django
DjangoCon US
San Diego, CA, United States of America
Video
Slides
2nd Aug
2019
Just Add Await: Retrofitting Async Into Django
DjangoCon Australia
Sydney, Australia
Video
Slides
70 minutes
3rd May
2019
Terrain, Art, Python and LiDAR
PyCon US
Cleveland, OH, United States of America
Video
Slides
30 minutes
6th Oct
2018
Taking Django Async
PyCon ES
Málaga, Spain
30 minutes
31st Aug
2018
Taming Terrain: Sculping geoscapes from LiDAR
Electromagnetic Field
Ledbury, United Kingdom
Video
Slides
30 minutes
26th Aug
2018
You Have Control: Learning From Aviation
PyCon AU
Sydney, Australia
Video
30 minutes
24th Aug
2018
Taking Django Async
DjangoCon AU
Sydney, Australia
Video
Slides
30 minutes
4th Jun
2018
You Have Control: Learning From Aviation
PyCon Israel
Tel Aviv, Israel
Video
Slides
60 minutes,
Keynote
23rd May
2018
Taking Channels Async
DjangoCon Europe
Heidelberg, Germany
Video
Slides
30 minutes
11th May
2018
Taking Django Async
PyCon US
Cleveland, OH, United States of America
Video
Slides
45 minutes
25th Apr
2018
Distributed Failure: Learning From Aviation
Code Europe
Wrocław, Poland
Slides
50 minutes
23rd Apr
2018
Distributed Failure: Learning From Aviation
Code Europe
Warsaw, Poland
Slides
50 minutes
8th Oct
2017
Concurrency to Channels
PyCon Brazil
Belo Horizonte, Brazil
Slides
50 minutes,
Keynote
16th Aug
2017
Taking Django Distributed
DjangoCon US
Spokane, WA, United States of America
Talking about strategies and downsides of splitting up Django-based sites into separate services, including the pros and cons of services versus monoliths.
Video
Slides
45 minutes
5th Aug
2017
Scaling Down (Running Large Sites Locally)
PyCon AU
Melbourne, Australia
Walking through Eventbrite's development environment tool Bay, and how it's designed to run complex systems on a single machine.
Video
Slides
25 minutes
4th Aug
2017
Horrors of Distributed Systems
DjangoCon AU
Melbourne, Australia
Stepping through some of the myriad ways in which systems can fail that programmers don't expect, and how this hostile environment affects the design of distributed systems.
Video
Slides
25 minutes
10th Jun
2017
Building for Failure: Learning lessons from aviation
PyCon Taiwan
Taipei, Taiwan
Comparing and contrasting the approaches of aviation and software engineering to failure, and how we can learn from their approaches.
Slides
45 minutes,
Keynote
7th Apr
2017
Scaling Django with Distributed Systems
PyCon Ukraine
Lviv, Ukraine
Looking at the basic tradeoffs and design principles involved in building distributed systems and specifically in storing data in them.
Video
Slides
3rd Apr
2017
Services, Architecture & Channels
DjangoCon Europe
Florence, Italy
Looking at service-oriented architecture principles, designs, and how the underlying components of the Django Channels framework can be used to build them.
Video
Slides
30 minutes
3rd Nov
2016
Channels (Under The Hood)
Django Under The Hood
Amsterdam, Netherlands
Taking a deep dive into the Channels codebase and software design, and looking at how it's built (and why!)
Video
Slides
60 minutes
20th Aug
2016
Django, Channels, and Distributed Systems
PyBay
San Francisco, CA, United States of America
Discussing the basic design of Channels, including the decisions made in its development, and some basic examples of implementation. (Partial rework of "Reinventing Django for the Real-Time Web")
Video
Slides
12th Aug
2016
Reinventing Django for the Real-Time Web
DjangoCon AU
Portland, OR, United States of America
Discussing the basic design of Channels, including the decisions made in its development, and some basic examples of implementation.
Video
Slides
45 minutes
19th Jul
2016
Architecting with Channels
DjangoCon US
Philadelphia, PA, United States of America
Video
Slides
60 minutes,
Keynote
30th May
2016
Reinventing Django for the Real-Time Web
PyCon US
Portland, OR, United States of America
Discussing the basic design of Channels, including the decisions made in its development, and some basic examples of implementation.
Video
Slides
45 minutes
31st Mar
2016
A Brief History of Channels
DjangoCon Europe
Budapest, Hungary
Video
Slides
30 minutes
9th Mar
2016
Django And This Thing Called Channels
Python SF Meetup
San Francisco, CA, United States of America
Slides
28th Jan
2016
Developing Eventbrite with Docker
Django SF Meetup
San Francisco, CA, United States of America
Slides
7th Sep
2015
Dubious Database Design
DjangoCon US
Austin, TX, United States of America
Video
Slides
45 minutes
11th Jul
2015
Django: The Conspiracy
Django Birthday
Lawrence, KS, United States of America
Video
19th Jun
2015
The Perils of Software Engineering
PyCon Singapore
Singapore, Singapore
Video
Slides
Keynote
17th Jun
2015
Datastores, Python And You
PyCon Singapore
Singapore, Singapore
240 minutes,
Tutorial
26th May
2015
Small Data: Storage for the Rest Of Us
PyWaw Summit
Warsaw, Poland
Video
Slides
30 minutes
15th May
2015
Migrating The Future
DjangoCon Europe
Warsaw, Poland
Video
Slides
10th Apr
2015
What can programmers learn from pilots?
PyCon US
Montreal, Canada
My first talk comparing and contrasting the approaches of the aviation community to safety with that of most software engineers, and examining where the two might meet.
Video
Slides
8th Mar
2015
Inside Lanyrd's Architecture
QCON London
London, United Kingdom
Slides
14th Nov
2014
Migrations Under The Hood
Django Under The Hood
Amsterdam, Netherlands
Video
Slides
50 minutes
5th Oct
2014
A Brief History of Django 1.7
BarCamp Django SF
San Francisco, CA, United States of America
45 minutes
5th Oct
2014
Learning To Fly
BarCamp Django SF
San Francisco, CA, United States of America
45 minutes
3rd Sep
2014
Digging Into Django's Migrations
DjangoCon US
Portland, OR, United States of America
Video
Slides
40 minutes
4th Aug
2014
Small Data: Databases in the Real World
PyCon AU
Brisbane, Australia
Video
Slides
25 minutes
1st Aug
2014
Django Migrations: A Retrospective
DjangoCon AU
Brisbane, Australia
Slides
15th May
2014
Good Schema Design and Why It Matters
DjangoCon Europe
Ile des Embiez, France
Video
Slides
30th Apr
2014
Django 1.7 and You
Django SF Meetup
San Francisco, CA, United States of America
Slides
24th Apr
2014
Databases & Schemas in an Agile World
CRAFT Conference
Budapest, Hungary
Slides
12th Apr
2014
Designing Django's Migrations
PyCon US
Montreal, Canada
Video
Slides
10th Apr
2014
API Design at Eventbrite
PyCon US
Montreal, Canada
Part of a larger Eventbrite "Advanced Django" workshop.
Slides
45 minutes,
Tutorial
10th Apr
2014
Moving Lanyrd: Changing Database and Datacentre
PyCon US
Montreal, Canada
Part of a larger Eventbrite "Advanced Django" workshop.
Slides
45 minutes,
Tutorial
8th Feb
2014
Django 1.6 & 1.7
Django Weekend Cardiff
Cardiff, United Kingdom
18th Oct
2013
Rapid Schema Development with PostgreSQL
All Your Base Conference
Oxford, United Kingdom
Slides
4th Sep
2013
Everybody Loves Migrations
DjangoCon US
Portland, OR, United States of America
Video
Slides
18th Nov
2012
The Wonderful World Of Databases
RuPy
Brno, Czechia
Slides
30 minutes
20th Oct
2012
Optimising Queries for Fun and Profit
PyCon Ukraine
Kiev, Ukraine
Video
Slides
6th Sep
2012
Models and Migrations and Schemas - oh my!
DjangoCon US
Washington, DC, United States of America
Video
Slides
4th Jun
2012
I Hate Your Database
DjangoCon Europe
Zurich, Switzerland
Slides
40 minutes
22nd Oct
2011
Eventlet, ZeroMQ and You
PyCon Ukraine
Kiev, Ukraine
Slides
11th Oct
2011
Eventlet, ZeroMQ and You
BrightonPy
Brighton, United Kingdom
Slides
8th Sep
2011
Deployment, Daemons and Datacenters
DjangoCon US
Portland, OR, United States of America
Video
Slides
40 minutes
20th Jul
2011
Building a hosting platform with Python
EuroPython
Florence, Italy
Discussing the design and implementation of my PaaS ep.io
Video
Slides
8th Jul
2011
Deploying, at an Unusual Scale
DjangoCon Europe
Amsterdam, Netherlands
Video
Slides
7th Jul
2011
Core Developers Panel
DjangoCon Europe
Amsterdam, Netherlands
25th May
2011
What's new in Django 1.3
DJUGL
London, United Kingdom
Slides
10th May
2011
The Perils of Writing a PaaS
London Devops
London, United Kingdom
Slides
9th Feb
2011
Spacelog (part one)
Oxford Geek Night
Oxford, United Kingdom
A combined talk about Spacelog.org with James Aylett
Slides
6th Feb
2011
Django's Architectire: The Good, The Bad, & The Ugly
FOSDEM
Brussels, Belgium
Slides
13th Nov
2010
A Brief History of Stats Porn
BarCamp London 8
London, United Kingdom
Slides
22nd Oct
2010
Python and Relational/Non-relational Databases
PyCon Ukraine
Kiev, Ukraine
Slides
8th Sep
2010
Step Away From That Database
DjangoCon US
Portland, OR, United States of America
Video
40 minutes
19th Jul
2010
Fun with Django and Databases
EuroPython
Birmingham, United Kingdom
Slides
25th May
2010
South New and Old
DjangoCon Europe
Berlin, Germany
Video
Slides
17th Feb
2010
Snowtime at Torchbox
Oxford Geek Night 16
Oxford, United Kingdom
Lightning talk about our internet-powered snow machine
5 minutes
8th Sep
2009
Database Migrations, South, And You
DjangoCon US
Portland, OR, United States of America
Video
Slides
40 minutes
4th May
2009
Migrations: Whatwhyhowwho?
EuroDjangoCon
Prague, Czechia
Slides
28th Mar
2009
GPS! Geolocation! Mornington Crescent!
BarCamp London 6
London, United Kingdom
Slides
25th Mar
2009
GIS us a Django
Oxford Geek Night 11
Oxford, United Kingdom
A lightning talk about WhoseTurf
Slides
5 minutes
19th Jan
2009
Migrating with South
DJUGL 2
London, United Kingdom
Slides
8th Sep
2008
Schema Evolution Panel
DjangoCon US
Mountain View, CA, United States of America
Combination panel and short talks about schema evolution/migrations.
Video
Slides
25th Jun
2008
Killing Servers With Music Graphing
Oxford Geek Night 7
Oxford, United Kingdom
Lightning talk about LastGraph
Slides
5 minutes