Skip to content

Instantly share code, notes, and snippets.

View loftwah's full-sized avatar
💭
“Any sufficiently advanced technology is equivalent to magic.”

Dean Lofts loftwah

💭
“Any sufficiently advanced technology is equivalent to magic.”
View GitHub Profile
@loftwah
loftwah / aurora.md
Last active December 20, 2024 05:02
RDS-postgres-to-Aurora

Complete Guide: RDS PostgreSQL to Aurora PostgreSQL Migration

Introduction

This guide provides step-by-step instructions for migrating from Amazon RDS PostgreSQL to Aurora PostgreSQL using AWS Database Migration Service (DMS). We'll cover both console and CLI approaches, including all necessary prerequisites and dependencies.


Cost Overview

@loftwah
loftwah / tech-stack.md
Created December 17, 2024 21:37
my-tech-stack

Tech Stack Overview

This document provides a clear and organised breakdown of the tools, technologies, and frameworks used in the current tech stack. The stack is categorised based on functionality and purpose.

Programming Languages

A diverse selection of programming languages covering backend, frontend, and systems programming.

  • Python: General-purpose programming language for scripting, backend development, and AI.
  • Node: JavaScript runtime for backend applications and server-side development.
@loftwah
loftwah / aws-llms.md
Last active December 13, 2024 13:42
AWS IAM LLMs

Brief: Using LLMs to Simplify AWS Security Policy Management


Contributors:

@loftwah
loftwah / 1password.md
Last active December 13, 2024 03:14
secrets_with_1password

Rails Secrets Management with 1Password

Introduction

This guide covers implementing 1Password for secrets management in Rails applications. 1Password's partnership with the Rails Foundation makes it an ideal choice for managing application secrets securely and efficiently.

Business Value & ROI

@loftwah
loftwah / solution.md
Last active December 8, 2024 09:25
kitchen-quote-coding-test

Loftwah's Solution for The Kitchen Design Quote Wizard - Coding Test


Overview

This solution implements a responsive multi-step wizard for generating kitchen design quotes using Rails 8, PostgreSQL, and Tailwind CSS 4.0. It adheres to metric standards, ensuring clean, professional functionality tailored for accurate and user-friendly input/output.

Features

@loftwah
loftwah / astro.js
Last active November 27, 2024 05:05
astro-mermaid
3:57:57 PM [vite] Error when evaluating SSR module /home/loftwah/gits/blog/astro.config.mjs: failed to import "remark-mermaidjs"
|- Error: Cannot find module 'remark-mermaidjs' imported from '/home/loftwah/gits/blog/astro.config.mjs'
at nodeImport (file:///home/loftwah/gits/blog/node_modules/vite/dist/node/chunks/dep-BWSbWtLw.js:53047:19)
at ssrImport (file:///home/loftwah/gits/blog/node_modules/vite/dist/node/chunks/dep-BWSbWtLw.js:52914:22)
at eval (/home/loftwah/gits/blog/astro.config.mjs:8:37)
at async instantiateModule (file:///home/loftwah/gits/blog/node_modules/vite/dist/node/chunks/dep-BWSbWtLw.js:52972:5)
3:57:57 PM [vite] Pre-transform error: Failed to load url remark-mermaidjs (resolved id: remark-mermaidjs) in /home/loftwah/gits/blog/astro.config.mjs. Does the file exist?
[astro] Unable to load your Astro config
@loftwah
loftwah / astro.md
Last active November 21, 2024 07:29
astro-games-section
title description pubDate heroImage author
Creating a Games Section for My Astro Blog
How I designed and built a games section in my Astro blog, complete with filtering, sorting, and enhanced user experience.
Nov 21, 2024
/images/games-section-astro.jpg
Dean Lofts (Loftwah)

Creating a Games Section for My Astro Blog

@loftwah
loftwah / reduce.md
Last active November 21, 2024 01:52
mapreduce

Immutable Array Operations Guide

This guide explores modern array methods introduced in ECMAScript 2023 that enable safe and predictable transformations while maintaining immutability—essential for building reliable and maintainable code in DevOps environments.


Compatibility Notice

The following methods require JavaScript environments that support ECMAScript 2023:

@loftwah
loftwah / investigation.md
Last active November 19, 2024 07:08
ecs-investigation

Streaming Service Investigation Playbook

Prerequisites

  • AWS CLI configured for the us-east-1 region.
  • SSH access to the EC2 instance (private key located at ~/.ssh/id_rsa).
  • Terraform workspace available for ECS resource information.
  • Required scripts in your working directory:
    • connect.sh - For accessing ECS containers.
    • monitor-health.sh - For monitoring ECS health.
@loftwah
loftwah / guide.md
Last active November 19, 2024 06:03
bsky-analytics

Bluesky Leaderboard System: Comprehensive Technical Guide

Introduction

This comprehensive guide details the design, implementation, and deployment of a Bluesky Leaderboard System. The system tracks user activity on the Bluesky platform, processes engagement metrics (including follower growth), and generates leaderboards based on combined engagement scores. It leverages Bluesky's Firehose API to process real-time data and stores it in a structured database for analytics.

The deployment is tailored for DigitalOcean using Terraform for infrastructure provisioning, Bun as the runtime environment, and incorporates backup strategies using DigitalOcean Spaces (S3-compatible storage).