Backend & DevOps Engineer | Building reliable systems & products | Co-organizer @cncfminna | Shipping practical tools
Nigeria
Joined April 2024
- Tweets540
- Following390
- Followers206
- Likes2.8K
Pinned Tweet
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/…
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…
2
60
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.
Abraham Algorithm✦ retweeted
In a few weeks, this LinkedIn bio will be a one-liner.
Interesting times ahead 👉🏾👈🏾
Abraham Algorithm✦ retweeted
I just completed "Harness Engineering & Agent Orchestration" by Scott Moss (@scotups) on @MasterDotDev! master.dev/courses/agent-har…
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.
1
9
203
Abraham Algorithm✦ retweeted
Hi @Gilmoorre, I’m a designer and a big fan
I noticed 2 gaps: Uncle Moore Motion has no website, and your comedy and cars live in separate places
So I designed and built one site for both: watch you, pick a car, book in one text
Unofficial, and it's yours
gilmore.mikkyinnovate.site
Abraham Algorithm✦ retweeted
Pharm (Dr.) Ogunyemi Elizabeth Omotomike is here.
Share the livee!
Share the livee!
Abraham Algorithm✦ retweeted
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
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
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
Abraham Algorithm✦ retweeted
A Defensive Defender Defending without defect
.
Allahuma Barik to me, Only up from here 😎🥰
Persoal, Project, Present, Peace
Abraham Algorithm✦ retweeted
Unfortunately death teaches you so much about life than any life experience ever will.
And I've learnt that the craziest thing about loosing someone is not even the fact that you miss them and you'd never get to meet or speak to them again,
It's the fact that death came in the middle of unfinished plans, in the middle of the most random acts under the most usual circumstances, Inconclusive conversations any time, anyday, anywhere.
And then it hits you that it could have been you.
Then you take a broader look at your life and wonder :
If you're ready for death.
If you've lived well.
If you're fulfilled with the life you've lived.
If you want to be remembered by how you've lived your life.
Have you been living for yourself or have you lived for others.
You begin to wonder "what is the meaning of life" "if all these are even worth it"
But it is times like these we remind ourselves that
“IT IS DEATH THAT GIVES LIFE MEANING.”
So I beg you all, LIVE MORE.
LOVE MORE.
GO ALL IN.
REACH OUT TO PEOPLE.
APOLOGIZE WHEN YOU'RE WRONG.
FORGIVE, EVEN WHEN IT'S HARD.
REST WELL. TAKE BREAKS.
PRAY.
TELL PEOPLE HOW MUCH YOU LOVE THEM.
VISIT YOUR FRIENDS AND FAMILY.
MAKE MEMORIES.
TAKE THAT CHANCE.
DO THAT THING YOU'VE BEEN PUTTING OFF.
DO IT TODAY.
Because the truth is, we don't have forever, and sometimes we don't even have tomorrow.
Don't get so caught up in surviving that you forget to live.
Farewell, @web3Bard101.
You will be deeply missed. Thank you for blessing me with the privilege of knowing you in this lifetime.
I'm grateful our paths crossed.
Rest well, man. May God grant you eternal rest. 🕊️
Abraham Algorithm✦ retweeted
Sendly Mail mobile app is Live!!!!!
Sendly mail allows you to create mailboxes for your teams, businesses and company on your own custom domain with additional peaks including calendar and to-do.
To start: mail.sendlyai.com
Applestore: apps.apple.com/us/app/sendly…
Playstore: play.google.com/store/apps/d…
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/…
It's been a while since I wrote anything, I documented the why and the how of snappdf.
From the problem, to what made me question where our documents actually go, to how I built the auto-crop without OpenCV or ML.
Read the full write-up 👇
abrahamalgorithm.hashnode.de…
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/…