The Blog: technical guides, interesting projects and some fun things I've learned


Get Shit Done with Notion

July 06, 20215 minute read

Using Notion to manage a prioritized task list

Notion

Productivity

Ordering of Aggregate Functions in PostgreSQL

June 23, 20211 minute read

How PostgreSQL works to aggregates arrays

SQL

PostgreSQL

Add a Custom Domain to Cloud Run

May 16, 202115 minute read

Add an HTTPS load balancer to a Cloud Run Instance with a Custom SSL Certified Domain Name

Cloud

Google Cloud Platform

Cloud Run

Load Balancer

Unit Testing Firebase Background Functions

April 20, 202110 minute read

Add unit tests to a Firebase project's background functions

Firebase

Testing

Jest

5 Helpful React Hooks I use Regularly

March 23, 20215 minute read

Useful React Hooks

React

Hooks

Run Visual Studio Code in the Cloud

March 02, 20215 minute read

Access your own Visual Studio Code environment anywhere on any device

Cloud

Google Cloud Platform

Code Server

Strapi on Heroku - Persist Files to Google Cloud Storage

November 30, 202010 minute read

Strapi images disappearing from media library? Learn how to persist files to Google Cloud Storage.

Cloud

Google Cloud Platform

Strapi

Heroku

Svelte, Tailwind CSS with Snowpack - the stack of the future

November 21, 202012 minute read

Build lightweight, blazingly fast UI's by bundling Svelte and Tailwind CSS with Snowpack

Typescript

Svelte

Snowpack

Tailwind CSS

Live Update Github Status with Spotify Currently Listening

November 01, 202015 minute read

Use the Spoitfy API and Google Cloud Functions to dynamically set your Github profile status

Firebase

Cloud

Google Cloud Platform

Node

Send Notification Email When Strapi Blog is Published

October 29, 20207 minute read

Send an email to blog subscribers when new blogs are published using Twilio SendGrid

Firebase

Google Cloud Platform

Strapi

SendGrid

Upload an Image to Firebase Storage from a URL

October 03, 202010 minute read

Given an image url, upload the image to a Firebase storage bucket using Google Cloud Functions

Firebase

Cloud

Google Cloud Platform

Syntax Highlighting in React Markdown

December 02, 20195 minute read

A simple guide to display great looking markdown code blocks in react

React

Node

Displaying Strapi Rich Text in Gatsby

November 10, 20195 minute read

Supplying rich text from the Strapi CMS and displaying it in Gatsby

Gatsby

React

Strapi

Automatically Detect Light/Dark Mode In Gatsby (Part 2)

October 17, 20198 minute read

Using Gatsby to statically bundle our automatic dark mode app

Gatsby

React

Automatically Detect Light/Dark Mode in Gatsby (Part 1)

October 15, 201910 minute read

Detect system color schemes and apply them to a react app

Gatsby

React

Let's have a chat. Come find me on the web.

Fergus Farrell | 2021