Product Engineer reimagining the future of work 💸
Integrating Slonik with Express.js
Integrating Slonik with Express.js

A comprehensive guide on integrating Slonik, a Postgres library for Node.js, with Express.js.

Fullstack Engineer
ExpressJS
Slonik
TypeScript

Attempting Large Code Refactor using LLMs
Attempting Large Code Refactor using LLMs

I'v successfully utilized a LLM to automate and streamline the refactoring process, enhancing its efficiency and reliability.

Prompt Engineer
AI Chatbot Developer
ChatGPT

Detecting unnecessarily mounted React components in a large app
Detecting unnecessarily mounted React components in a large app

My learnings from tracking down dead code in a frontend application.

Frontend Engineer
React

Debugging mysterious traffic from Boardman, OR
Debugging mysterious traffic from Boardman, OR

A journey of debugging mysterious traffic spikes coming from Boardman, OR.

Fullstack Engineer
Google Cloud Platform

Bulk inserting nested data into the database (part II)
Bulk inserting nested data into the database (part II)

Using jsonb to process and insert large and complex datasets into the database in a single query.

Fullstack Engineer
Node.js
PostgreSQL

Routing PostgreSQL queries between read-write & read-only instances
Routing PostgreSQL queries between read-write & read-only instances

Load balancing application between read-write and read-only PostgreSQL instances using query routing.

Fullstack Engineer
Node.js
PostgreSQL

Building advanced SQL search from a user text input
Building advanced SQL search from a user text input

How to create a GitHub/Sentry-like search with Slonik and Liqe.

Fullstack Engineer
Node.js
PostgreSQL
Slonik

Writing composable SQL using JavaScript
Writing composable SQL using JavaScript

A walkthrough of common patterns of writing SQL queries in JavaScript with the help of Slonik.

Node.js
PostgreSQL

Fully qualified names vs a jungle of imports
Fully qualified names vs a jungle of imports

Thoughts about using fully qualified names for everything in the project vs having numerous, domain specific imports.

Node.js

Rewriting tests from Cypress to Playwright using GPT3
Rewriting tests from Cypress to Playwright using GPT3

Using OpenAI's text-davinci-002 model to rewrite tests from one framework to another.

DALL·E 2
GPT-3
Node.js

Validating PostgreSQL results & inferring query static types
Validating PostgreSQL results & inferring query static types

Using zod schema validation with static type inference to provide build time and runtime PostgreSQL safety checks.

Node.js
PostgreSQL

Contra Landing Pages
Contra Landing Pages

Built the website and animations collaborating with Contra's talented design team.

Framer
Lottie
Next.js
Node.js
styled-components

Slack bot Snack
Slack bot Snack

Built a popular Slack bot that allowed people to have impromptu 1:1 video calls with ice-breakers.

Growth Marketer
Product Manager
Next.js
Node.js
PostgreSQL
React

Receipt Aggregator
Receipt Aggregator

Built a receipt aggregator that automatically pulled data from Google, Uber, GitHub, and dozens of other platforms.

Fullstack Engineer
UX Designer
Next.js
Node.js
PostgreSQL
React

MAMA Wi-Fi platform
MAMA Wi-Fi platform

Developed a Mac Authentication Management Application (MAMA), which was adopted by major hotels and airports across the UK to provide Wi-Fi access.

MySQL
PHP

Location based advertising platform
Location based advertising platform

Developed an ad server, Data Management Platform (DMP) and integration with the Demand-Side Platform (DSP).

Engineering Manager
MySQL
PHP

Mocking PostgreSQL queries in Node.js
Mocking PostgreSQL queries in Node.js

A step by step guide to mocking Postgres queries in Node.js using Slonik

Node.js
PostgreSQL