Vishnu Pedireddi

955 posts

Vishnu Pedireddi

Vishnu Pedireddi

@Vishnu14

Katılım Temmuz 2009
2.1K Takip Edilen39 Takipçiler
Vishnu Pedireddi
Vishnu Pedireddi@Vishnu14·
@garrytan Swarm from four square - not sure if it’s an agent , but it does work good
English
0
0
0
52
Garry Tan
Garry Tan@garrytan·
Is there a good map-based AI agent app that tells me everything relevant to me and what I’m doing nearby to where I am at the moment? Especially interesting for travel
English
357
78
2.7K
593.2K
Anita 🇺🇲
Anita 🇺🇲@AnitaArtx·
My granddaughter graduated today. Her parents are no longer here... If you don't mind, wish her happiness, you will make her truly happy
Anita 🇺🇲 tweet media
English
1.5K
410
11.6K
354.7K
Woke Eminent
Woke Eminent@WokePandemic·
Today a male calf was born to our Gau Mata. I am looking for name suggestions.
English
1.5K
498
9.3K
516.5K
Ashutosh Maheshwari
Ashutosh Maheshwari@asmah2107·
I’m starting a podcast for people who love tech, engineering, and building cool stuff. For Episode 1, I want someone who: – Built something insane – Has a 🔥 story – Speaks raw truth about tech Who should I invite? Tag them 👇
English
26
6
207
13.7K
Ashutosh Maheshwari
Ashutosh Maheshwari@asmah2107·
Quick question : try {   call_order_service();   call_inventory_service(); // decrement stock } catch (Exception e) {   // lol, now what ? The order was already created. } Congratulations. You have an order for an item you don't have in stock. How will you fix this ?
English
362
41
1.2K
155.4K
Vishnu Pedireddi
Vishnu Pedireddi@Vishnu14·
@asmah2107 The order created needs to be deleted in the catch block. Basically emulate what a transaction does on a rollback
English
1
0
41
6.8K
Ashutosh Maheshwari
Ashutosh Maheshwari@asmah2107·
Things that feel like they should work in distributed systems but don’t ? 🔽
English
9
0
34
5.5K
Antonio Viggiano
Antonio Viggiano@aviggiano·
This is a classic problem in production database migrations at scale. When you run ALTER TABLE ADD COLUMN phone_number VARCHAR(20) NOT NULL, the DB engine typically rewrites the entire table to add that column (especially in MySQL, Postgres pre-11, etc.). That’s what locks it. The way to do a Painless Migration — avoid “stop-the-world”: ⸻ 1️⃣ Add column as NULLABLE first (fast, no rewrite) ALTER TABLE users ADD COLUMN phone_number VARCHAR(20) NULL; This is instant in most engines — only updates the metadata (no locking the whole table). ⸻ 2️⃣ Backfill data in small batches You have 500M rows — do not update all at once! Use a script that backfills phone_number with defaults or derived data, using small batches: UPDATE users SET phone_number = 'UNKNOWN' WHERE phone_number IS NULL LIMIT 10000; Run this repeatedly in a loop (cron job, job queue) — low load on DB, no locking. ⸻ 3️⃣ Once backfill is 100% done — Add NOT NULL constraint Now that no row has NULL anymore, you can do: ALTER TABLE users ALTER COLUMN phone_number SET NOT NULL; Again, in modern DBs this is usually instant, since no rewrite needed — just verifies constraint. ⸻ 4️⃣ (Optional) Add indexes If you need an index, add it concurrently: CREATE INDEX CONCURRENTLY idx_users_phone_number ON users(phone_number); ⸻ Recap: zero downtime strategy ✅ Add column as NULL ✅ Backfill in small batches ✅ Set NOT NULL after backfill ✅ Add index concurrently ⸻ Why does this work? ✅ No full table lock ✅ No downtime for reads/writes ✅ Works on huge tables (500M+) ✅ App keeps working — can already use phone_number gradually ⸻ If you tell me what DB you’re using (MySQL? Postgres? Aurora?), I can tailor this more — each engine has its own quirks. Would you like me to?
English
19
19
422
33.7K
Ashutosh Maheshwari
Ashutosh Maheshwari@asmah2107·
Quick question : You need to add a new, required phone_number column to your users table, which has 500 million rows. You write a simple ALTER TABLE script. You run it during a "maintenance window." It locks the entire users table for 8 hours while it adds the new column to every row. For 8 hours, no one can sign up or log in. Pain right ? You cannot perform "stop the world" operations on a live, large scale database How will you do a “Painless Database Migration” ?
English
310
97
2K
363.5K
Vishnu Pedireddi
Vishnu Pedireddi@Vishnu14·
@DavidKPiano It’s not the rewrite that hard, it’s the expectations to not regress on deliverable that’s tech leads fear
English
0
0
0
52
David K 🎹
David K 🎹@DavidKPiano·
Most devs (+ managers, CTOs, etc.) don't realize that the cost of rewriting their messy legacy codebase from the ground up w/ modern tools is probably much lower than they think. Maintaining & adding features to existing tech debt will likely cost more in the long run.
English
147
100
1.4K
125.9K
Mark Gadala-Maria
Mark Gadala-Maria@markgadala·
Forget about AI taking your job. The real nightmare is AI taking over humanity—and it might kill most of us in the process. This isn't a distant possibility; it's a ticking time bomb. Here's why you should be terrified—and what you need to know before it's too late.
English
189
90
771
1.1M
Erik Meijer
Erik Meijer@headinthebox·
I am convinced we are doing AI coding wrong. Completely wrong in fact. Humans need abstraction and code reuse to reduce costs and manage complexity. That is not true for AIs however. They can just brute force things. No reuse and abstractions needed. So instead of trying to coerce AIs to "structure" their code for our own benefit, we should just let them do the thing they do best, generate whatever code they want. As long as it works, we should be happy. It is a bit like organizing your email in folders vs using search. Embrace the chaos!
Erik Meijer tweet media
English
231
53
764
141.8K
Harsh Goenka
Harsh Goenka@hvgoenka·
Indians move abroad to… Eat overpriced butter chicken from a Punjabi with a fake Italian accent. Buy haldi and hing that costs more than a bottle of wine. Miss golgappas while chewing on sad quinoa. Celebrate Diwali like it’s the Met Gala—minus celebs, plus aunties in Swarovski sarees. Make only Indian friends and discuss how “things are better back home.” Form a WhatsApp group called Desi Squad. And then save up in dollars… just to fly back and tell their parents how amazing life is over there.
English
357
226
2.1K
205.3K
vitrupo
vitrupo@vitrupo·
Amjad Masad says the nature of software, companies, and the economy changes when anyone can create and run AI agents. You describe a product. The agent "grabs" a database, pays with its wallet, and deploys it. Income flows through "ambient services" run by "people making money on the internet."
English
17
21
159
28.2K
Adam D'Angelo
Adam D'Angelo@adamdangelo·
vibe coding on my phone in a waymo 🎈
English
24
14
350
62.5K
Vishnu Pedireddi retweetledi
spacebull
spacebull@spacebull·
spacebull tweet media
ZXX
17
57
428
23.4K
Vishnu Pedireddi
Vishnu Pedireddi@Vishnu14·
@dhh @dhh As much as it’s fun to rails on Ubuntu, Could you speak a bit about hardening the server it’s deployed to ? Rameerez brings the receipts, would love to hear your side of things at 37 signals
English
0
0
0
168
Vishnu Pedireddi
Vishnu Pedireddi@Vishnu14·
Watching ruby on rails console do DB migrations and letting me play with records feels like advanced magic. Falling for RoR ! @dhh #RubyOnRails
English
0
0
0
51
NO CONTEXT HUMANS
NO CONTEXT HUMANS@HumansNoContext·
One of the dumbest things I’ve ever seen
English
1.8K
861
22.4K
9.8M