Currently working on an LLM-based chatbot system for an educational institute.
The goal is simple: help students get accurate answers to their doubts using the institute’s own study material.
Thread ↓
So,
Ans is Yes...
you have to care about the views as it is going to optimise the sql queries and such views will be helpful for ORM to do the queries.
View schema in DB :
which describes which data to show to a particular user or group
What if i am using a prisma as a ORM, it means the responsibility to write the sql queries has been delegated to prisma..
and in such case DO I need to think about the user views in the db ??
and now in the code,
whenevr you want the student view or info you will avoid complex query and just use the view.
But in the architecture,
when we give the sql query handing responsibility to the ORM like prisma...
do we need to care about the views schema in db ???
i had claude go through every @kirat_tw podcast. 83 episodes, 40 hours
100+ devs explaining exactly how they got hired. most had no big college name
wrote down everything that worked https://t.co/2KEBIOF76D
Recently Did a LLD exercise as to Build a Zomato Like Food delivery app in java.
Link to post : https://t.co/CJmul5vUYI
Code Pr: https://t.co/RjWkDX7iky
🛠️ What I've been working with:
• Backend development with Node.js & TypeScript
• Distributed systems, queues, and event-driven architecture
• AWS, OCI, Docker, Kubernetes & Terraform
• CI/CD, GitOps, Prometheus & Grafana
• PostgreSQL, Redis & system design
3) Singlton design pattern:
When you want to create a only one object of your class.
It is required for tracking or linking all the information to a single instance/object.
e.g. : Logging system,
Database connection , COnfig managers,
Manager classes ect.
,
11-11-2026:
LLD updates:
1) Stategy Design pattern:
Use when you want to get a algo from a family of algo in runtime.
e.g. choosing a payment mentod during checkout..
2) Factory Design Pattern :
Use it when you want to separate the business logic and object creation logic.
e.g. : Notifictaion system, we create a factory for notifictaion and decide which kind( push, email, slack) notification you want to send.