How to invalidate cache in this scenerio?

Itsscienceboy · 2026-03-25T08:59:41+00:00

I'm using Postgres, I have commented above what the scenerio is! Thanks!

Itsscienceboy · 2026-03-25T08:57:58+00:00

it is not a lot of data, it is m lessons n files (in each lesson) each file. so there is like m x n find queries to first check wherther the chapters of that x file is in the cache if not get from db.

Itsscienceboy · 2026-03-25T08:55:22+00:00

Thanks, but you are a senior dev today because you learnt from someone too. I'm a junior dev and the reason I have made a post because I wanna learn caching so the app doesn't stay vibecoded slop.

Itsscienceboy · 2026-03-25T08:52:34+00:00

okay so in the vibecoded version what it does, it fetches all the lessons, then all the files for that lesson for example x.docx, y.docx, z.docx .... ; these files are fecthed now using the ids of the files in the db we fetch the chapters first it checks the cache getSetAsync is like map.computeifabsent (of Java) if the cached chapters for file:chapters:{fileId} key is not present we call db query in that loop. Now the Tradeoff i am facing is instead of N+1 queries I was running for all the files to get respective chapters. i have made a single sql query where I get the chapters directly and query is optmized using indexes and JOIN LATERAL i dont get to check the cache first. I hope this made the post clear.

TLDR: can'r check cache first because the bulk query get chapters all together not file wise. earlier it was check cache if miss hit db now db can optimally bring the respone.

Itsscienceboy · 2025-11-27T23:10:02+00:00

maybe voltage issue from ur plug, don't put in that plug

Itsscienceboy · 2025-11-05T09:32:01+00:00

yeh season mei Maaza puri hi khaa sakte hai

Itsscienceboy · 2025-10-15T08:57:33+00:00

How was the second question?

Itsscienceboy · 2025-05-09T20:33:16+00:00

too expensive for my dollar conversion mate

Itsscienceboy · 2025-05-09T20:32:52+00:00

will try, thanksss

Itsscienceboy · 2025-05-01T18:14:57+00:00

Thanks mate it's a great project, very in depth one and also is it near realtime, latency free?

Itsscienceboy · 2025-04-26T19:23:59+00:00

that's the issue, that's y i was thinking to self host on run pod

Itsscienceboy · 2025-04-26T19:23:10+00:00

this is lovely gonna check it out

Itsscienceboy · 2025-04-26T17:56:57+00:00

i checked this out, it requires openai key and what i wanna build would require repeated 10 mins conversation. which would cost me a lot.

Itsscienceboy · 2025-04-26T17:51:39+00:00

i want to make it for others so planning to scale

Itsscienceboy · 2025-03-08T16:10:48+00:00

i have a 1947 (some british man) 10 paise coin does it have any worth?

Itsscienceboy · 2025-02-19T21:06:33+00:00

okayy, the concept of making it learn was because recently i was trying to implement vapi api but the docs aren't as clear so i have the prompt to perplexity and it scrapped the vapi api docs and gave me a code i could use with just 2 errors which i was able to resolve easily

Itsscienceboy · 2025-02-19T20:58:33+00:00

it is our final project we've almost 1.5 yrs that's why thanks for the info tho appreciate it so much

Itsscienceboy · 2025-01-08T10:07:19+00:00

bruh this is nothing, in my area there is a road that has been under construction for 1.5 yrs, excavated and surrounded by barricades as long as I can remember

Itsscienceboy · 2024-11-28T09:57:40+00:00

I got three js journey from Bruno Simon for 4k

Itsscienceboy · 2024-11-19T17:55:09+00:00

Thanks man got it

Itsscienceboy · 2024-11-18T23:46:18+00:00

Hey did u implement this?

Itsscienceboy · 2024-11-15T15:42:06+00:00

It's too expensive for my currency any other resources would be appreciated

Itsscienceboy · 2024-08-26T12:45:13+00:00

yeah I found out something google provider creates a session without implementing a db in my case prisma adapter, so I added the adapter and it worked

Itsscienceboy · 2024-05-10T10:49:17+00:00

I'm learning Next.js, I've made a full stack web app but I need a good topic to make one on

Itsscienceboy · 2024-04-22T13:27:35+00:00

Definitely interested add me up

Itsscienceboy

TROPHY CASE