Step-by-step guide to dumping a remote PostgreSQL database or schema and restoring it to a local database using pg_dump and pg_restore.

How Do I Dump and Restore a Remote PostgreSQL Database to a Local Database?

System Design: Build a database cluster with primary(master) & read replica(slave)

Why showing is better than telling—how demos improve collaboration, bug reports, and feedback in software development.

Demos Not Memos: Better Communication in Software Teams

Allows behavior to be dynamically added to individual objects without modifying their code, promoting flexibility and adherence to the open/closed principle.

Design Patterns: Decorator

Provides an interface for creating objects in a superclass, but allows subclasses to alter the type of objects that will be created, promoting flexibility and reusability in object creation.

Design Patterns: Factory

Defines a one-to-many dependency between objects, so when one object changes state, all its dependents are notified and updated automatically.

Design Patterns: Observer

Encapsulates the logic for accessing and managing data sources, providing a centralized interface for data operations while promoting separation of concerns and improving testability.

Design Patterns: Repository

Ensures a class has only one instance, providing a single point of access for shared resources like logging, configuration, or database connections.

Design Patterns: Singleton

Steps to successfully prepare for the AWS Cloud Practitioner Certification

How do I prepare for a AWS Cloud Practitioner Certification?

System Design: Serverless CRUD app with AWS Lambda and DynamoDB

Learn how Cloud Build Triggers automate CI/CD workflows in Google Cloud, enabling automatic builds and deployments for your applications.

System Design: Automating Deployments with Google Cloud Build Triggers

Explore the pros and cons of three popular approaches for scheduling and running background jobs in Google Cloud: App Schedulers, Cloud Scheduler, and Cloud Run Jobs.

System Design: Comparing Background Job Techniques in GCP: App Schedulers, Cloud Scheduler, and Cloud Run Jobs

Learn what Google Cloud Run is, its benefits, and how to deploy containerized applications with ease.

System Design: Getting Started with Google Cloud Run: Serverless Containers Made Easy

Learn what Google Cloud Scheduler is, its benefits, and how to set up a scheduled job in Google Cloud.

System Design: Getting Started with Google Cloud Scheduler

Learn how to set up and connect to Google Cloud Memory Store (Redis) from Cloud Run using a VPC connector.

System Design: Getting Started with Google Cloud Memory Store (Redis)

Learn what Google Cloud Secret Manager is, its benefits, and how to securely manage secrets for your applications in GCP.

System Design: Google Cloud Secret Manager

AI expands knowledge like a fractal—each layer of clarity reveals new noise, trapping us in a recursive race to find true signal.

Opinion: AI as a Fractal: Signal, Noise, and Recursive Nature of Progress

Agents, state spaces, goal tests, path costs & more

AI Search Agents for 15 Puzzle & Maze Path Finding

AI-driven vibe coding makes simple apps effortless, but when projects demand nuance, it turns into a frustrating cycle of fixing one issue only for another to pop up.

Opinion: Vibe Coding Without Coders... AKA Whack-a-Mole

My thoughts on a book I heard of a few years ago but only recently found some time to dive into

The Things You Can See Only When You Slow Down: Book Review

Data Structures & Algorithms in Python

Even industry leaders like Reddit can have bugs in production. This post highlights a duplicate posts issue in Reddit's mobile app and encourages developers and hiring managers to view such bugs as opportunities for growth, learning, and empathy.

Bug Report on Reddit: Lessons from a Duplicate Posts Glitch

Big O Notation's common complexity cases to familiarize oneself with.

Cheat Sheet: Big O Notation

.NET commands & shortcuts to get you up and running quick & easy.

Cheatsheet: .NET

Expo commands to get you up and running quick & easy.

Cheat Sheet: Expo

Jetbrains commands/shortcuts to get you up and running quick & easy within their family of IDEs including DataGrip, RubyMine, PyCharm, PhpStorm, IntelliJ & more

Cheat Sheet: Jetbrains commands/shortcuts

Kubernetes commands to get you up and running quick & easy.

Cheat Sheet: Kubernetes commands/shortcuts

Cheat Sheet: Postgres

Shell Scripts

VIM commands to get you up and running quick & easy.

Cheat Sheet: VIM commands/shortcuts

VSCode commands to get you up and running quick & easy.

Cheat Sheet: VSCode commands/shortcuts

How to derive the OLS Estimator with matrix notation and a tour of math typesetting using markdown with the help of KaTeX.

Deriving the OLS Estimator

Markdown cheatsheet for all your blogging needs - headers, lists, images, tables and more! An illustrated guide based on GitHub Flavored Markdown.

Markdown Guide

In this article we introduce adding images in the tailwind starter blog and the benefits and limitations of the next/image component.

Images in Next.js

Looking for a performant, out of the box template, with all the best in web technology to support your blogging needs? Checkout the Tailwind Nextjs Starter Blog template.

Introducing Tailwind Nextjs Starter Blog

The scenic lands of Canada featuring maple leaves, snow-capped mountains, turquoise lakes and Toronto. Take in the sights in this photo gallery exhibition and see how easy it is to replicate with some MDX magic and tailwind classes.

O Canada

The Time Traveller (for so it will be convenient to speak of him) was expounding a recondite matter to us. His pale grey eyes shone and twinkled, and his usually pale face was flushed and animated...

The Time Machine

Why we’re creating an exchange in public, the principles guiding our decisions, and how we focus on building real relationships with users, collaborators, and investors, not just code or pitch decks.

Open Exchanges: Lessons in Building, Sharing, and Growing Trust in Public — Part I

A walkthrough of our trading platform architecture, showing how the web client, services, and data layers interact with Protobuf, Redis, and Postgres — and why these choices matter for transparency and reliability.

Open Exchanges: Lessons in Building, Sharing, and Growing Trust in Public — Part II

Exploring how public, verifiable security challenges and read-only system access can replace promises with proof — and why authorization integrity matters more than most people think.

Open Exchanges: Lessons in Building, Sharing, and Growing Trust in Public — Part III

How transparency, high-signal public artifacts, and verifiable challenges create trust, attract the right attention, and generate inbound opportunities for founders.

Open Exchanges: Lessons in Building, Sharing, and Growing Trust in Public — Part IV

How operational transparency, public metrics, and verifiable system performance can be treated as a core feature, building trust with users, investors, and the community.

Open Exchanges: Lessons in Building, Sharing, and Growing Trust in Public — Part V

Why modern systems should be built for people who doubt claims by default — and how designing for skeptics produces better architectures, clearer guarantees, and stronger trust.

Open Exchanges — Part VI: Designing for Skeptics

How users connect wallets, deposit and withdraw funds, and trade tokens — demonstrating end-to-end flows with explicit risk boundaries, verifiable state transitions, and operational transparency.

Open Exchanges — Part VI: Token Mechanics & Wallet Integration

A clear, practical guide to Registered Direct Offerings (RDOs): what they are, why companies use them, how they compare to IPOs, and what investors should consider.

What is an RDO and how does it differ from an IPO?

Tools I use to research

A clear breakdown of the roles, responsibilities, and differences between the U.S. Federal Reserve and the Treasury Department.

Federal Reserve vs. Treasury Department: Key Differences

An approachable introduction to futures contracts: what they are, how they work, common uses (hedging, speculation), key terms, and the risks investors should understand.

Futures Trading — A Practical Introduction

A comprehensive guide to Implied Volatility Rank (IVR), its calculation, significance in options trading, and practical applications.

Understanding Implied Volatility Rank (IVR)

Understand the difference between leading and lagging indicators—how they help predict or confirm economic and market trends, with practical examples for each.

Leading vs. Lagging Indicators in Finance

How quant traders use premium flow and z scores to spot unusual options activity and trading opportunities.

Premium Flow with Z Scores

Explore the Put-Call Ratio, its calculation, interpretation, and role as a sentiment indicator in financial markets.

Understanding the Put-Call Ratio in Options Trading

A guide to understanding and using the Relative Strength Index (RSI) in finance.

Relative Strength Index (RSI): What It Is, How It Works, and Formula

Sharpe Ratio: Definition, Formula, and Examples

A guide to Initial Public Offerings (IPOs), including key concepts, terms, and processes involved in going public.

IPOs

A practical guide to the Black-Scholes formula, its significance in finance, and how to calculate option prices using Python.

Quant Finance: Understanding the Black-Scholes Formula for Option Pricing

A practical guide to Delta, Gamma, Theta, Vega, and Rho for options traders. Learn how each Greek affects option pricing and risk management.

Finance: The Greeks

Learn how the open frac indicator helps quantify opening vs. closing volume in options markets, and how it can be used as a signal in quantitative finance.

Finance: Understanding Open Frac as an Options Signal

Finance: 

Condors: Balancing Risk and Reward in Options Trading. Learn how condor strategies work and their place in option investing.

Finance: Condors in Options Trading

Options aren’t just speculative bets—they serve as insurance, income generators, leverage tools, and volatility plays. Finance experts use them to reshape risk-reward profiles, hedge portfolios, and engineer custom exposures that traditional assets alone can’t provide.

Finance: Introduction to Options

A comprehensive guide to option spread strategies, including vertical, credit, and debit spreads. Learn how spreads manage risk, reduce cost, and enhance returns.

Finance: Spreads in Options Trading

Straddles: A Versatile Option Investment Strategy. Explore how straddles work and their role in option investment strategies.

Finance: Straddles in Options Trading

Strangles: Flexible Strategies for Options Traders. Discover how strangle strategies work and their role in options trading.

Finance: Strangles in Options Trading

Explore a comprehensive range of options trading strategies—from basic hedging and income generation to advanced volatility and arbitrage plays. Learn how each strategy works, its risk-reward profile, and how finance professionals use options to manage portfolios, enhance returns, and structure custom exposures.

Finance: Options Trading Strategies

Essential calculus concepts and techniques for success in quantitative finance.

Calculus for Quantitative Finance

Learn how premium flow trends help traders identify optimal entry and exit points for assets by analyzing market sentiment and momentum.

Indicators: Premium Flow

Overview of the essential mathematics—linear algebra, statistics, calculus, and more—for success in quantitative finance.

Mathematics for Quantitative Finance

Discover how order books work in financial markets, how they match buyers and sellers, and why understanding price levels, book depth, and the bid-ask spread is essential for traders and investors.

Order Books Explained: How Markets Match Buyers and Sellers

A walkthrough of pair trading, portfolio construction, and mean-variance optimization in quant finance.

Pair Trading: A Quantitative Approach

Learn what slippage is, why it happens, and how traders can minimize its impact when buying or selling in financial markets.

Slippage in Trading: What It Is and How to Avoid It

A guide to the key statistics areas you should master to excel in quantitative finance.

Essential Statistics for Quant Finance

A reference guide to the most important symbols, their original names, and meanings in quantitative finance.

Key Symbols in Quantitative Finance

The US Stock Markets growth over the last 25 years

U.S. stock-market size

Learn how closed-end funds operate, how they differ from open-end funds, and what makes their share structure and trading unique.

How a Closed-End Fund Works and Differs From an Open-End Fund

Explore what exchange-traded funds (ETFs) are, how they work, and why they are a popular investment choice for gaining diversified market exposure.

Exchange-Traded Fund(ETF): What It Is and How to Invest

Understand the concept of extrinsic value in finance, especially in options trading, and learn how it affects pricing and investment decisions.

Extrinsic Value in Finance: What It Means and Why It Matters

Index Fund: What It Is and How to Invest

Explore the differences between institutional and retail investors, including their characteristics, strategies, and impact on financial markets.

Institutional vs. Retail Investors: Key Differences

Learn what intrinsic value means in finance, how it is calculated, and why it is important for investors and option traders.

Intrinsic Value in Finance: What It Means and Why It Matters

Learn what mutual funds are, how they operate, their benefits and drawbacks, and why they are a popular investment choice for individuals and retirement accounts.

All Posts