Ratish Jain (@ratishtwts) header
Ratish Jain (@ratishtwts) profile picture

23. AI Engineer @flowaceapp prev: @devxAIlabs Become AI Engineer: https://teapawt.org/t.co/dX5hVfeubr DM for collabs ✉️

Joined August 2017
Photo by Ratish Jain (@ratishtwts)Photo by Ratish Jain (@ratishtwts)Photo by Ratish Jain (@ratishtwts)Photo by Ratish Jain (@ratishtwts)Photo by Ratish Jain (@ratishtwts)Photo by Ratish Jain (@ratishtwts)Photo by Ratish Jain (@ratishtwts)Photo by Ratish Jain (@ratishtwts)Photo by Ratish Jain (@ratishtwts)Photo by Ratish Jain (@ratishtwts)
Play chess and do DSA and system design daily You are sorted no need to get into all the fear mongering Few good projects in the resume are enough Nobody cares about your portfolio so stop wasting time on it Read, Read a lot!
29
69
7
1,436
40,516
MCP now has - skills - tools - events - tasks What a nice piece of tech we are witnessing getting developed in front of our eyes :)
1
2
150
Ratish Jain retweeted
While I’m interviewing for my next role, I figured I’d try freelancing. A few projects shipped, I have room for more in December I build websites, MVPs, WhatsApp ordering flows, automations, and AI tools. I also help with marketing and DevRel Tell me what you need. We’ll figure out what to build, I’ll get it set up, and I’ll show you how to run it. Everything stays in your name If a local business or solo founder comes to mind, tag them below or give this a repost. Link to book below
17
8
1
35
2,063
These broke ass people will troll RDR 3 as well 😂
3
218
Ratish Jain retweeted
Your UUID primary key might be slowing down every insert. Postgres 18 added uuidv7(). Here's why that matters. The problem with UUIDv4: It's fully random. Every insert lands on a random leaf page of the B-tree. What that causes: 1. Page splits all over the index, not just at the end 2. Half-empty pages, so the index bloats 3. The whole index has to stay in memory, because any page can be the next write 4. More WAL, because many different pages get modified What UUIDv7 does: The first 48 bits are a millisecond timestamp. The rest is random. So new keys are always larger than old ones. Every insert goes to the rightmost leaf page. Result: - One hot page in memory instead of the whole index - Splits only happen at the edge - Pages stay full - Postgres even has a fast path for inserting at the rightmost leaf The part I like: It's the same reason auto-increment IDs were always fast. UUIDv7 gives you that write pattern without a central counter. One catch: the ID reveals when the row was created. Don't use it where that's sensitive.
2
1
8
401
You know the game is peak When you are enjoying optional missions as well thank you @RockstarGames
1
6
337
Your UUID primary key might be slowing down every insert. Postgres 18 added uuidv7(). Here's why that matters. The problem with UUIDv4: It's fully random. Every insert lands on a random leaf page of the B-tree. What that causes: 1. Page splits all over the index, not just at the end 2. Half-empty pages, so the index bloats 3. The whole index has to stay in memory, because any page can be the next write 4. More WAL, because many different pages get modified What UUIDv7 does: The first 48 bits are a millisecond timestamp. The rest is random. So new keys are always larger than old ones. Every insert goes to the rightmost leaf page. Result: - One hot page in memory instead of the whole index - Splits only happen at the edge - Pages stay full - Postgres even has a fast path for inserting at the rightmost leaf The part I like: It's the same reason auto-increment IDs were always fast. UUIDv7 gives you that write pattern without a central counter. One catch: the ID reveals when the row was created. Don't use it where that's sensitive.
2
1
8
401
AWS revenue after this📈📈📈
YOU CAN PUT YOUR LLM IN A LAMBDA FUNCTION! TELL EVERYONE! LAMBDA FUNCTIONS CAN NOW RUN ON GPUS!
5
328
YOU CAN PUT YOUR LLM IN A LAMBDA FUNCTION! TELL EVERYONE! LAMBDA FUNCTIONS CAN NOW RUN ON GPUS!
147
237
105
4,462
363,210
Interesting question Relational databases like PostgreSQL and MySQL now let you store JSON directly in tables, and you can even index and query fields inside it. That covers a lot of what people used to pick NoSQL for. So how do you decide today whether a project needs a SQL database or a NoSQL one?
14
2
1
58
15,335
Ratish Jain retweeted
Don't complicate stuff all you need to know is this to become a software engineer
1
2
210
I have come to realisation that GTA 6 is not for this generation which is hooked to reels and have a popcorn brain They will quit in the first chapter itself.
3
16
714
This game is bigger than humanity
India is playing a whole new game!
1
158
I played GTA 6 all day today this is shit is addictive Thank you remote work :)
10
356
Don't complicate stuff all you need to know is this to become a software engineer
1
2
210
You tweeting this says otherwise, anything for the engagement these days 😂
With all due respect, I couldn't care less about whichever version of GTA has been released!
1
6
270
If you are playing GTA 6 on base ps5 Do this: - game controls classic - motion blur 0 - reduce camera shake and bob - aim controls to precision Enjoy and thank me later
4
7
157
25,033
This shit is tooooo gooodd
1
8
259
I am gonna spam somethings about GTA 6 here while playing the game at 12 am Bare with me !!
1
7
322