Yesterday, via a blog post Google announced Cloud SQL Insights for PostgreSQL. After a read through the post I was immediately impressed by the detail offered in this functionality and for free!

I used to be a hardcore Oracle Database developer and spent a lot of my time down in the weeds analysing and optimising SQL, firing up the awful SQL Developer and digging though Oracles v$ views for insights. I don’t miss those days and thankfully most of the SQL I deal with now is left to basic CRUD operations.

The databases I work with don’t tend to be…


Firewatch Australia is a free app released over the 2019–2020 Australian Bushfire season to help track bushfires. This is part 1 in a series of 2 posts on building the app. Check out the introduction or take a look at the next post on Scaling on the Cheap to learn more.

When I first started building Firewatch Australia I was very much building the plane whilst flying it. I had a few goals in mind but didn’t know exactly how they would manifest or how I would implement them. One early feature I knew I wanted was a visual history…


Firewatch Australia is a free app released over the 2019–2020 Australian Bushfire season to help track bushfires. This is the introduction of a series of 2 posts on building the app. Take a look at the next post on Data Processing to learn more.

In December 2019 my parents travelled across the world from the UK to Australia paying me a visit for the first time in 8 years. We had an intense few weeks planned travelling the east coast from Cairns to Gold Coast to Sydney to Narooma. During this time the bushfires hit hard taking many lives and…


Update 27/04/20 14:30: Originally this article was formed from analysis of the Singapore Government’s TraceTogether app from which COVIDSafe is based. I’ve since had time to better understand the differences by reading the COVIDSafe Privacy Impact Assessment and have updated the details below as well as adding a section describing the differences.

The Australian Government has just released the COVIDSafe app to help with contact tracing in Australia during the COVID-19 pandemic. Here’s a brief outline of how it works:

  • You download the app from the Play Store or App Store.
  • You then register in the app with a phone…

Firewatch Australia is a free app released over the 2019–2020 Australian Bushfire season to help track bushfires. This is part 2 in a series of 2 posts on building the app. Check out the introduction or take a look at the previous post on Data Processing to learn more.

I wasn’t expecting many users when I launched the app, maybe just a few friends, but nonetheless I wanted to make sure it scaled well and didn’t break the bank in terms of infrastructure costs. …

Mike Leonard

CTO at Reposit Power building and operating Virtual Power Plants to make energy limitless and free for all.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store