Leonard Q. MarcqLeonard Q. Marcq
  • March 2, 2024

    Do's and Don'ts of Storing Large Trees in PostgreSQL

    I have been operating a tree of millions of nodes in PostgreSQL. Here are some of the things I wish I knew before I started.

    DatabaseSystemsPostgreSQL
  • October 7, 2023

    Shipping ECS logs to Mezmo (LogDNA) with AWS Firelens and Fluent Bit

    Ship your AWS ECS Fargate logs directly to Mezmo using AWS Firelens and Fluent Bit, without going through CloudWatch Logs. This will save you a lot of money.

    Infrastructure
  • July 14, 2022

    Structuring Golang for AWS Lambda and API Gateway: Modular Monolith

    Structuring a Golang project for deployment on AWS Lambda with API Gateway using AWS SAM to avoid serverless copy-paste everywhere.

    DevOpsBackendServerless
  • May 15, 2022

    Consuming a DynamoDB Stream without AWS Lambda

    Tutorial on writing our own DynamoDB Stream consumer using the low-level DynamoDB Stream APIs without using AWS Lambda triggers or the Kinesis adapter.

    DatabaseBackend
  • March 8, 2022

    My domain was suspended

    AWS Route 53 sends you Nigerian Prince spammy-looking emails and suspends your website if you don't click the links in them. My domain was suspended. Let's reflect on what went wrong.

    Random
  • March 4, 2022

    Modeling Hierarchical Tree Data in PostgreSQL

    An introduction to storing hierarchical tree and graph data structures in a PostgreSQL database, using recursive CTE, ltree materialized paths and other schema design techniques.

    Database
  • February 28, 2022

    Deploying to AWS Elastic Beanstalk with GitHub Actions

    This tutorial walks you through setting up a minimal CI/CD pipeline for an AWS Elastic Beanstalk app using GitHub Actions.

    DevOps
  • February 26, 2022

    Deploying a Next.js app with Docker and AWS Elastic Beanstalk

    An in-depth walkthrough on deploying a Next.js app with Docker and AWS Elastic Beanstalk, from Dockerizing Next.js to going live.

    DevOps
  • February 22, 2022

    How I built my blog with Next.js, TypeScript, MDX, Tailwind

    We walk through how I built this blog, going over the design and organization of the project and how Next.js, TypeScript and MDX come together in this blog that you are reading.

    Frontend