siddoesntmatter

212 posts

siddoesntmatter

siddoesntmatter

@sidghosh29

Software Engineer | Making you go 'wait…I didn’t know that' | ​Tech • Sports • Filmmaking • Opinions

Katılım Eylül 2022
118 Takip Edilen41 Takipçiler
Sabitlenmiş Tweet
siddoesntmatter
siddoesntmatter@sidghosh29·
Hi, I am Siddharth. If you're new to my profile, this thread should be a good place to start.
English
4
0
4
1K
siddoesntmatter retweetledi
siddoesntmatter
siddoesntmatter@sidghosh29·
Most #Python beginners learn try/except and if checks, but do not learn when to use which. This is really a question of #LBYL vs #EAFP, two main styles of writing error handling code in Python, and getting it right makes your Python code cleaner and safer.
English
1
0
1
113
siddoesntmatter
siddoesntmatter@sidghosh29·
@AdityaRajKaul So did you, Aditya. The research you and your team did, I believe, was one of the most important reasons why the film could do as well as it did. That gave the film a realistic feel to it. Thank you and please collaborate with Aditya Dhar more.
English
1
0
20
984
Aditya Raj Kaul
Aditya Raj Kaul@AdityaRajKaul·
Dhurandhar 1 and Dhurandhar 2 together have crossed 3000 crores globally. Aditya Dhar scripts history with Dhurandhar in Indian cinema. 🇮🇳
English
286
3.3K
24.6K
159.1K
siddoesntmatter retweetledi
Arpit Bhayani
Arpit Bhayani@arpit_bhayani·
You would hate PostgreSQL if you have an update-heavy use case because every update writes a brand new tuple, and the old one does not go away. This is MVCC (Multi-Version Concurrency Control) - when you update a row, PostgreSQL does not modify it in place. It creates a new tuple with the updated values, sets the old tuple's `xmax` field to the current transaction ID, and leaves the old row sitting on disk. The old tuple is now "dead" - invisible to new transactions but still consuming physical space. Thus, a single logical update effectively doubles the storage for that row until vacuum reclaims it. For read-heavy or mixed workloads, autovacuum handles this quietly in the background. But for update-heavy workloads - think session stores, order pipelines, leaderboards, or counters - dead tuples can pile up faster than autovacuum can clean them. The default autovacuum triggers after roughly 20% of a table has changed. On a table with 500 million rows, that means you could have 100 million dead tuples accumulating before cleanup even starts. The performance impact is not just storage. Bloated tables also affect sequential scans, which now have to read significantly more pages from disk. Index scans slow down because index entries still point to dead tuples and must be resolved. By the way, there is an escape hatch for this called Heap-Only Tuple updates. When the updated row fits on the same page, and the changed columns are not indexed, PostgreSQL can skip creating new index entries. Cheaper, but the dead tuple on the heap still builds up. If you are running a genuinely update-heavy workload on PostgreSQL, just make sure you tune your autovacuum really well. Hope this helps.
English
12
18
278
12.9K
Abhishek Singh
Abhishek Singh@0xlelouch_·
In the AI era, code and generic answers are abundant, but lived engineering judgment is still scarce; that is exactly why @0xffdevs exists. We’re building a place where builders share practical pathways, real interview outcomes, curated resources, and grounded discussions so people can learn from actual experience, not just generated summaries. AI can accelerate execution, but community context, taste, mistakes, and hard-won lessons are what turn information into direction, and 0xffdevs is designed to preserve and compound that human signal! Here are some more updates on the product of the year 0xffdevs.com > Unified Connect now supports both Discord login and MetaMask login, and shows whichever identity is active. > Discussions are now Discord-first, showing only general with the latest 10 messages. > Discord feed auto-refreshes every 30 minutes, with manual refresh anytime. > Resource requests are routed directly to Discord, so submissions land instantly in the team channel. > Subscriptions can be handled with Discord/webhook workflows as a free lightweight backend layer. > Marketplace supports wallet-connected listing and browsing in a single flow. > Wallet-based interactions (where needed) remain available without blocking public content access. > Core community ops are now consolidated through backend APIs + Discord for faster, low-cost shipping. > A completely transparent roadmap section to show what's coming! More integrations coming soon! Visit: 0xffdevs.com --- Would love to have any feedback, feel free to join telegram, discord and discuss and request resources (can be done from the UI too).
Abhishek Singh tweet media
English
2
2
17
4.2K
siddoesntmatter
siddoesntmatter@sidghosh29·
@sidhant We should have never recognised China's claim to Tibet. Good to know India does not explicitly endorse China's claim over Taiwan.
English
4
8
345
6K
siddoesntmatter
siddoesntmatter@sidghosh29·
@khajurtheorizes @khajurtheorizes this is very true. I occasionally try giving the original kurkure a shot because of nostalgia and every single time I'm so disappointed. And I wondered if they've changed the taste or whether it's my taste buds that have changed.
English
1
0
57
3.4K
ruch
ruch@khajurtheorizes·
As you grow older Kurkure starts tasting radioactive
English
79
366
5.1K
82.6K
siddoesntmatter
siddoesntmatter@sidghosh29·
I read that you got one of the best defamation lawyers in the country to help you with this case. If true, like others have suggested, make sure you sue them into oblivion...each one of them. If they were really into protecting the vulnerable, that's definitely not how you do it. The extremely racist manner in which they behaved with you was very hard to watch. Do not backslide. All the best.
English
0
0
6
1.9K
Akash Singhania
Akash Singhania@Akash_S9·
My world was turned upside down this weekend. As some of you may have seen, I was featured on a recent episode of Vitaly Zdorovetskiy’s live series, where I was wrongfully portrayed as someone attempting to engage in an inappropriate conduct. This accusation is completely false. Since then, Vitaly has publicly acknowledged, through both written and video statements, that this was a mistake. Additionally, the officers from the Santa Ana Police Department, who I called to the scene, conducted their own assessment and confirmed that I am innocent of any wrongdoing.  I am sincerely grateful to Officers Renald Galstian, Lorenzo Sanchez, and Joanna Hatziefstratiou for their professionalism and for taking the time to carefully evaluate the situation and establish the truth. While I appreciate that the mistake has been acknowledged, the impact of the false accusation has been significant. I have experienced harassment, judgment, and damage to my personal and professional relationships based on something that has now been proven false. I wholeheartedly support efforts to expose real wrongdoing and protect the vulnerable. At the same time, this experience has shown me how important due process and verification are because mistakes, when made publicly, can have serious consequences on innocent lives. Thank you to those who have supported me during this time. Thank you, Akash Singhania
VitalyTheGoat🐐@vitalyzdtv

English
1.9K
1.5K
26.2K
3.1M
siddoesntmatter
siddoesntmatter@sidghosh29·
@FearedBuck This was extremely hard to watch. The man should definitely sue them ALL.
English
0
0
0
2.5K
FearBuck
FearBuck@FearedBuck·
Vitaly issues an apology after a p—phile sting gone wrong, where they repeatedly accused the wrong man of being a p—phile. “My team and I mistakenly portrayed Akash Singhania as a child pred*tor. This was a mistake that I deeply regret. He never intended to meet a minor and has been cleared of all wrongdoing. I apologize to Mr. Singhania, his family, his friends, and anyone else affected by this mistake. To be clear, the work we do to expose predatory behavior is of the utmost importance, but in doing so, we cannot lose sight of the truth. I have removed the video from all my accounts, and I ask that anyone who has saved it please do the same. Though I never encourage anyone to attempt to contact any person in my videos, I ask that anyone who is attempting to contact Mr. Singhaniacease at once. This was a learning experience for my team and me, and we will ensure that we remain committed to the truth, as we always have.” (via: Vitaly on Kick)
English
1.8K
807
27K
5.6M
Lauren 🍉
Lauren 🍉@Laureasons_·
Why couldn’t Elon buy LinkedIn instead, that app deserves to be ruined the way he’s ruining Twitter.
English
143
6.7K
57.9K
532.2K
siddoesntmatter
siddoesntmatter@sidghosh29·
An excerpt from a 1990 lecture by Edsger W. Dijkstra (famously known for Dijkstra's Algorithm, though that's just a slice of his impact on computer science), where he advocates for programmer responsibility, urging the use of the term "errors" over "bugs" to foster a more mature approach to software development. #Dijkstra #ComputerScience #SoftwareEngineering
English
0
0
0
130
siddoesntmatter
siddoesntmatter@sidghosh29·
In 1975, late Amita Malik, the most celebrated film critic from India, dubbed the "first lady of Indian media", anchored a panel discussion with Elia Kazan, Akira Kurosawa, Satyajit Ray and Michelangelo Antonioni, some of the greatest filmmakers of their time, which was telecasted in Doordarshan, the only tv channel then in India. This would have been a treasure anywhere in the world. Unfortunately, this goldmine tape was either lost or erased from the channel's archive (sheer negligence and apathy?) Talking about the legendary event in one of her interviews, she said, "The BBC had originally asked for it, but being patriotic, I gave preference to DD and paid for it." #satyajitray #filmmaking #BBC #Doordarshan
siddoesntmatter tweet media
English
0
0
1
112
siddoesntmatter
siddoesntmatter@sidghosh29·
Adding an index feels like an obvious improvement. Your read queries get much faster and you couldn't be happier about it…at first...until your writes slow down and storage starts growing. Indexes speed up only the queries that actually use them, while every insert, delete, or update to indexed columns adds extra work. Therefore, before adding one, ask yourself: Do I actually query this column often? Does this match my real access patterns? #BackendEngineering #Databases
English
0
0
2
66
siddoesntmatter
siddoesntmatter@sidghosh29·
@EOEboh I did not know there was a term like 'Cache Stampede'. Thanks for posting this question @EOEboh
English
0
0
0
74
siddoesntmatter
siddoesntmatter@sidghosh29·
@DGukesh What a mature response, @DGukesh. All the best for your preparation. We'd love to see you defend the title.
English
0
0
0
40
Gukesh D
Gukesh D@DGukesh·
I think there is nothing to be surprised about all of them got a chance and made the most of it and that is what sport is you cant say I’m stronger so I deserve to be there you need to show up and perform and all the guys there did that! I am working on improving myself now!
ZONE@Machismo12345

@DGukesh Hi Gukesh, Are you surprised with the list of Candidates this year or do you think its quite normal.When would you start preparing to defend your title? #AMAwithGukesh

English
15
93
2.5K
367.4K
siddoesntmatter
siddoesntmatter@sidghosh29·
@971AlSaadi With all the casual racism towards Indians on social media, it's good to read such positive tweets about India and us from time to time. Thank you, Majed. Wish you all the best.
English
1
2
50
5.9K
Majed
Majed@971AlSaadi·
Indians have always been part of my world, I grew up on their food, their movies, even picked up some of the language along the way. Theyre not others, theyre part of the fabric of our society. Ignore Indias influence on the world, and youre just choosing to stay ignorant. Jai Hind! 🇮🇳 whether you like it or not!
English
152
407
3.9K
83.6K
siddoesntmatter
siddoesntmatter@sidghosh29·
@Grand_handsomer Nothing wrong with that as long as they don't post nonsense, which so many of them do unfortunately.
English
0
0
0
41
Fred
Fred@Grand_handsomer·
Nothing would improve X more than getting rid of all the people who are only on X for money
English
140
341
3K
59.6K
siddoesntmatter
siddoesntmatter@sidghosh29·
@BarclayCard18 Looking at his responses to some of the comments in his post, I think that's most likely a kid behind the account.
English
0
0
0
282
Scott Barclay
Scott Barclay@BarclayCard18·
I've long ago come to terms with the fact that Sinner and Alcaraz are going to surpass Murray's achievements. But, like... can we just please not do stuff like this?
Jan The Fox 🦊@JanTheMerchant

@andy_murray Sir Andy, remind me, how many ATP clay tournaments have you won?

English
30
11
468
25.9K