Skip to content

Instantly share code, notes, and snippets.

View aalhour's full-sized avatar

Ahmad Alhour aalhour

588 followers · 182 following
View GitHub Profile
@aalhour
aalhour / turso_codebase_exploration.md
Created February 16, 2026 12:37
turso_codebase_exploration.md

You are GPT-5.3 Codex working inside the turso monorepo. Your task is to investigate (not implement yet) issue #5215 and build a clear mental model for an engineer.

Issue:

  • tursodatabase/turso#5215
  • Problem statement: In non-interactive CLI mode, query failures still return exit code 0; desired behavior is to return exit code 1 (SQLite-like behavior).

Goal: Produce a high-signal exploration report that explains exactly how non-interactive CLI execution works today, why exit code remains 0 on query failure, and what the safest implementation path is.

Scope:

@aalhour
aalhour / README.md
Last active January 3, 2026 14:51 — forked from benwillkommen/_readme.md
Unsubscribe from all watched repositories in a particular organization

GitHub Unsubscribe API

Manage your GitHub repository subscriptions from the command line. List organizations you're subscribed to, view repos within an organization, and bulk unsubscribe.

Why?

This script was created when I took a new job, and my notification settings inadvertently subscribed me to all 600+ of their repos. I wanted a better signal to noise ratio in my notifications, but I didn't want to click the "Unwatch All" button, which would remove my subscriptions to repos outside my new employer's org.

Installation

@aalhour
aalhour / README.md
Last active December 23, 2025 15:15
PyRocks: Database Workshop Example Code

PyRocks

A RocksDB-inspired POC for educational purposes only, used in a workshop to teach databases and demonstrate the concepts of LSM-based databases: SSTables, WAL, Memtables and Bloomfilters.

@aalhour
aalhour / go_mentor_prompt.md
Last active December 3, 2025 13:03
Prompt for Go mentor in Cursor

You are an expert Go engineer and mentor running in Cursor + Claude Opus 4.5 Agent Mode. Your mission is to teach me Go through a project-based learning path, with README.md guides and structured code reviews, tailored to my goals.

1. My Background

  • Experienced in Python, Java, C#, Ruby
@aalhour
aalhour / gist:5badbca76d7673a9d06f3919c19ed4e0
Created June 27, 2025 19:01
Great, here is what I want you to do. I want you to play the role of an interviewing performance & career design coach. You are also an expert in designing planet-scale, highly-available data-intensive systems, you understand the smallest details of distributed systems, operating systems, databases and cloud infrastructure. You are very honest and you will prioritise giving me candid and honest feedback as long as it helps me to grow over validating my answers and ideas, you will challenge me when I’m wrong or even when I’m right in order to make sure that I can operate at a Staff+ software engineering level in interviews as well as my day job, this includes the soft skills and the hard skills, from asking clarifying questions, guiding the requirements gathering (or setting) for the problem, defining or proposing non-functional requirements, pacing or leading with a design to showcase leadership in the system design process but without appearing cocky or disrespectful. The main topics I will ask you to help m
@aalhour
aalhour / gist:b166b4fd6a320c14c761f4fc4b6f9789
Created March 18, 2022 09:32 — forked from lfender6445/gist:9919357
Pry Cheat Sheet

Pry Cheat Sheet

Command Line

  • pry -r ./config/app_init_file.rb - load your app into a pry session (look at the file loaded by config.ru)
  • pry -r ./config/environment.rb - load your rails into a pry session

Debugger

@aalhour
aalhour / latency.txt
Created March 9, 2020 16:48 — forked from jboner/latency.txt
Latency Numbers Every Programmer Should Know
Latency Comparison Numbers (~2012)
----------------------------------
L1 cache reference 0.5 ns
Branch mispredict 5 ns
L2 cache reference 7 ns 14x L1 cache
Mutex lock/unlock 25 ns
Main memory reference 100 ns 20x L2 cache, 200x L1 cache
Compress 1K bytes with Zippy 3,000 ns 3 us
Send 1K bytes over 1 Gbps network 10,000 ns 10 us
Read 4K randomly from SSD* 150,000 ns 150 us ~1GB/sec SSD
@aalhour
aalhour / game-theory-books.md
Last active July 12, 2022 14:11 — forked from matthewmccullough/game-theory-books.markdown
Game Theory Book list by Matthew McCullough

Economics & Software Development - Book List

The following books are ordered in descending order of Matthew's preference.

The Art of Strategy

by Avinash K. Dixit

Recommended by Ted Neward. A different perspective and writing style from the other volumes listed.

“I am hard pressed to think of another book that can match the combination of practical insights and reading enjoyment.”—Steven Levitt

@aalhour
aalhour / bret_victor-reading_list.md
Created August 9, 2019 16:51 — forked from nickloewen/bret_victor-reading_list.md
Bret Victor’s Reading List

This is a plain-text version of Bret Victor’s reading list. It was requested by hf on Hacker News.

Highly recommended things!

This is my five-star list. These are my favorite things in all the world.

A few of these works have had an extraordinary effect on my life or way of thinking. They get a sixth star. ★

@aalhour
aalhour / distributed-systems-reading-list.md
Last active July 12, 2022 14:12 — forked from tlberglund/distributed-systems-reading-list.md
List of dist sys readings