Abraham Algorithm✦

UUIDs are great for modern distributed systems, because any service can generate one without asking the database for the next ID, and they won't even clash. ⠀ But if you are using random UUIDs as primary keys, there is a cost that will only show up once your table gets big. ⠀ Primary key index is a B-tree, and it's sorted by the key. ⠀ With an auto-increment ID, every new row goes to the end of the index. So the database keeps writing to the same last page, and that page is already sitting in memory. ⠀ With a random UUID, every new row lands in a different place in the index. So once the index gets bigger than memory, each insert will have to pull a page from disk first. ⠀ The pages also split and stay half empty, so the index ends up bigger than it needs to be. The UUID spec (RFC 9562) says the difference can be an order of magnitude or more. ⠀ That's why UUIDv7 exists. Its first 48 bits are a timestamp, so new IDs sort after old ones, and inserts go back to the end of the index. Since Postgres 18, it's built in. ⠀ Just keep in mind it shows when the row was created, so keep a random ID for anything public. ⠀ When Buildkite tested time-ordered UUIDs on their main Postgres database, along with a few other changes, their write-ahead log rate dropped by 50%. ⠀ The best time to make this choice is before your first insert, because after a billion rows, you have to rewrite every key and every foreign key that points to it. ⠀ Read Buildkite's write-up here: buildkite.engineering/goodby…

Spoke at Intretra Talk yesterday on “Breaking into Tech: Where should I start?” A lot of people overthink the starting point and get overwhelmed, especially with AI everywhere now. I shared a bit of my own path, how I picked a direction, how you can combine what you already know with tech instead of switching completely, and how community helped me more than any course. Also shared free places to start: AWS Skill Builder, Google Skills, GitHub Student Pack, freeCodeCamp, roadmap.sh, and 3MTT. And programs that can even pay you while you learn: Google Summer of Code, Summer of Bitcoin, Outreachy, and LFX Mentorship. Building in public + showing up in communities still works.

Completed the AWS New Voices programme! ✨ 4 weeks of learning how to structure talks, create better hooks, engage audiences, and read the room. A big thank you to AWS community and the trainers for the experience.

Led a workshop here yesterday✨

Dev Days Minna is happening tomorrow! 🚀 If you’re around FUTMinna, come through for a hands-on GitHub Copilot workshop and some good tech conversations. And, there’s swag too :) See you there! luma.com/aktaz9lz?tk=oGv15L #devdays

Try snappdf today snappdf.abrahamalgorithm.tec…

So I built an open-source PDF toolkit that runs completely in your browser. Scan(edge auto-detect), merge, split and sign PDFs Works offline, and your files never leave your device. Try it: snappdf.abrahamalgorithm.tec… Repo: github.com/AbrahamAlgorithm/…

My new portfolio is live. abrahamalgorithm.tech/

A moving man…

Had a session with the new FUTMinna Notion Community core team, where I spoke about building thriving communities, taking ownership, and making your tenure valuable.

Nexalware lets apps and AI agents control physical devices, then checks the device telemetry to confirm each command actually ran. Python SDK, REST/WebSocket, and MCP for agents. nexalware.com/

One of the funniest GitHub issues I’ve ever come across 😂😭

The more you learn, the more you realize how much you don’t know And honestly, the “stuff you don’t know you don’t know” is the biggest part

Just wrapped up a session on “Beyond ChatGPT: The AI Skills Every Student Needs in 2026” with NGIT FUTMinna Shared some practical ways students can move from simply using AI to understanding, building, and solving real problems with it.

What a ride it’s been leading @gdgoc_futminna from 2024 to 2026. Couldn’t make it to Lagos for the physical graduation, but I still joined virtually. Grateful for the people, the experiences, and everything we built along the way. Thank you @Geektutor #GDGONCAMPUS #GDGOC

Photo from the @KFUPM x @googlecloud Intelligent Planet hackathon in Saudi Arabia. First time I had to defend a cloud infrastructure design in front of judges.

It’s one thing to know the services, it’s another to know when and when not to use them. When to automate and when not to, what to measure, SLI, SLO, SLA, error budgets, reliability, performance, cost. The challenge is knowing the right trade-offs for the system you’re building