Abraham Algorithm✦

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/…

HI @JayeshPadhiar Let's connect 🤝

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…

Thanks chief

Always believing

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.

Congratulations 🎉

Congratulations man 🎉

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

Congratulations chief🎉