Deepanshu
1.8K posts

Deepanshu
@DeepanshuChaid
Designing & coding stuff that just works. Judge it yourself.
North korea Katılım Nisan 2025
38 Takip Edilen32 Takipçiler

In the last few backend reviews I’ve done, the issues weren’t complex.
They were things that were never checked.
I put together a Postgres audit checklist I use during backend reviews.
30 questions I run through before I touch anything else.
Here’s what it covers :
• 𝗜𝗻𝗱𝗲𝘅 𝗰𝗼𝘃𝗲𝗿𝗮𝗴𝗲 - the 4 places teams usually miss
• 𝗖𝗼𝗻𝗻𝗲𝗰𝘁𝗶𝗼𝗻 𝗽𝗼𝗼𝗹𝗶𝗻𝗴 - why the default 100 becomes a problem
• 𝗽𝗴_𝘀𝘁𝗮𝘁_𝘀𝘁𝗮𝘁𝗲𝗺𝗲𝗻𝘁𝘀 - setup + 3 queries to check weekly
• 𝗩𝗮𝗰𝘂𝘂𝗺 & 𝗮𝘂𝘁𝗼𝘃𝗮𝗰𝘂𝘂𝗺 - what actually matters
• 𝗥𝗲𝗽𝗹𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗹𝗮𝗴 - what’s normal vs a problem
• 𝗦𝗰𝗵𝗲𝗺𝗮 𝗺𝗶𝘀𝘁𝗮𝗸𝗲𝘀 - the ones that turn into outages
• 𝗕𝗮𝗰𝗸𝘂𝗽𝘀 - how to verify restores actually work
One example.
When a system hits connection limits, the first response is usually increasing max_connections.
That doesn’t fix the issue.
It shifts the failure from “too many connections” to “out of memory”
This is the same checklist I use in code reviews.
It consistently surfaces issues that weren’t obvious at first.
I’ve turned it into a short ebook
Comment 𝗔𝗨𝗗𝗜𝗧.
I’ll DM you this playbook.

English

@DeepanshuChaid Experience. Basically I faked in my resume that I'm good with Ui (which I despised) but got hired with it and good at it eventually
English

@DeepanshuChaid Mostly everyone from there. But recently working on our another website which is entirely ours so I can do customization as much as I want
English

@rushbeef04 Is it just a thing with the current client or is it about every client you been doing lately
English

@DeepanshuChaid They don't like it. They actually have no brain everyone is doing it so they want it.
English

@rushbeef04 You ever showed them just a simple clean ui? cuz ai could make something better than this with just a better prompt
English

@DeepanshuChaid Most of these websites have no design pattern even my sloppy ass see this.
English

@rushbeef04 Like those old looking websites ? or do you mean the glowing ai looking ahh designs
English

@DeepanshuChaid Ah, nothing like I have to do designs and some of the designs the clients don't like. They usually like shitty designs
English

@codersGyan Sir, i made this project using golang as backend. lair2509.vercel.app
NOTE:- backend takes 30 sec or so to start
English


Step-1: Learn Go
Step-2: Learn goroutines, channel & ascheduler
Step-3: Master pointers, interfaces & malloc
Step-4: Build an HTTP server with std lib
Step-5: Read the Go runtime & standard library source. Embrace humility
Step-6: Build a production-grade backend (REST/gRPC, DB, caching, msging)
Step-7: Make it resilient under load
Step-8: Learn profiling and optimization (pprof, trace, benchmarks)
Step-9: deploy with Docker & K8s
Step-10: Ship it
English










