Transcript for transcript_1RpMbf1SqOejT7-LTpUX1YnWdFCV_3ZpI_1_3260_f5760df7593d_6.txt

transcript_1RpMbf1SqOejT7-LTpUX1YnWdFCV_3ZpI_1_3260_f5760df7593d_6.txt

[00:07:11]  Hello, Adarsh.
[00:07:14]  Hello, sir.
[00:07:31]  Why is your camera so blurry?
[00:07:36]  So I can connect my phone if you want.
[00:07:39]  No, no.
[00:07:40]  Do one thing.
[00:07:40]  Put a flashlight on your phone.
[00:07:47]  Put it in front of your screen.
[00:08:22]  You're strong in back end or front end?
[00:08:25]  Back end.
[00:08:34]  Okay, Adarsh, tell me about yourself a little, give your some introduction, where are you from, what are you doing, everything.
[00:08:41]  Sir, my name is Adarsh Gupta, currently I'm in fourth year, pursuing B.Tech in Computer Science and Engineering at W.
[00:08:47]  F.
[00:08:47]  W.
[00:08:48]  University, Punjab.
[00:08:50]  Which university?
[00:08:51]  LPU, Punjab.
[00:08:53]  Okay.
[00:08:54]  I am from Kanpur, Uttar Pradesh.
[00:08:57]  I know React, Node.js, Express, MongoDB.
[00:09:01]  I have worked with Postgres School and MongoDB as a database.
[00:09:05]  I have also worked as a data analyst at Gokumet where I worked with DBT or data cleaning.
[00:09:12]  My database was used for making dashboards and I worked on
[00:09:17]  this aggregation pipeline where the data that is taken from click house it is loaded and using dbt i use to clean the data and finally make dashboard using my database and i have keen interest in devops
[00:09:33]  keen interest in devops do you have experience some experience in devops already
[00:09:38]  No, not not industry level experience.
[00:09:41]  I know Docker.
[00:09:41]  I know Jenkins.
[00:09:42]  Currently, I'm learning Kubernetes.
[00:09:44]  I also know Terraform.
[00:09:46]  And in last semester, I made a college project which uses Docker, GitHub, XN and Ansible.
[00:09:57]  Nagios for monitoring and Terraform for provisioning
[00:10:00]  And question.
[00:10:11]  Okay.
[00:10:14]  Give me a second.
[00:11:17]  Okay, Adarsh, let's get into, I want to discuss first right out of the bat one API actually, API details.
[00:11:23]  Can you present your screen?
[00:11:42]  Yes.
[00:11:53]  Can you open Notepad?
[00:12:01]  Just open Notepad on your laptop only, no?
[00:12:10]  So then document where you can open.
[00:12:16]  Okay.
[00:12:17]  Can you write down an API to actually find the nearby residents to you?
[00:12:21]  So my expectation is you write the API from starting like from endpoint to the end of like how the database call gets made.
[00:12:29]  Nearby restaurants.
[00:12:31]  Yeah.
[00:12:36]  Which language are you comfortable in the backend?
[00:12:38]  JavaScript.
[00:12:41]  Server-side language is JavaScript for you?
[00:12:44]  No, sir.
[00:12:45]  It's JavaScript as a server-side language and framework is Express.js.
[00:12:50]  Okay, let's do it.
[00:12:51]  In Express, you can do it.
[00:13:24]  What are you doing?
[00:13:26]  Firstly, I'm initializing the server.
[00:13:28]  This is a code which is used to initialize the server.
[00:13:31]  Okay.
[00:13:31]  This server will be listening on port 4000.
[00:13:39]  That is okay.
[00:13:40]  I don't need to see that.
[00:13:41]  I just need to see the signature part of the API.
[00:13:44]  How the API will look.
[00:13:47]  So app will be creating get request.
[00:14:00]  So distance parameter we have to pass like up to 5 kilometers or?
[00:14:05]  You have to take a call.
[00:14:22]  So for this route, we will call in the controller function and then we can define the controller function.
[00:14:29]  We can also.
[00:14:31]  What is the request here in the API?
[00:14:33]  So we are making a get request.
[00:14:35]  So API, API, then restaurant, then we are taking distance as a parameter.
[00:14:39]  For example, if we are selecting that we want to see the restaurant, which are in area of five kilometers circle, then we can pass number number value from here.
[00:14:49]  5 km circle of what?
[00:14:51]  5 km circle basically.
[00:14:55]  Of what?
[00:14:55]  5 km circle of what?
[00:14:57]  For example, if I am at a place
[00:15:00]  then five kilometer in all the directions if we are having any restaurants so where are you right now how does your system knows where are you right now
[00:15:08]  So that I don't know I have worked with.
[00:15:11]  So in JavaScript, we are having a method using which we can find latitude and longitude, then we can use any external API to find the current location of mine.
[00:15:28]  So after that, we can write a controller function.
[00:15:31]  So if in the database, we are having latitude and longitude.
[00:15:36]  What's that?
[00:15:37]  How would you find latitude and longitude?
[00:15:40]  So I don't know the exact method.
[00:15:42]  So in JavaScript, we are having inbuilt method that allows me to get longitude and latitude of my current location.
[00:15:47]  That's not right.
[00:15:48]  That's incorrect.
[00:15:54]  I don't know.
[00:16:00]  Dino Sunil.
[00:16:02]  Sunil?
[00:16:03]  Yes.
[00:16:03]  No, sir.
[00:16:08]  Okay.
[00:16:09]  Moving on.
[00:16:10]  Let's not discuss the question then.
[00:16:17]  You implemented role level security in Metabase?
[00:16:20]  Yes, role level security was implemented through Metabase.
[00:16:24]  Okay, so how did you handle this at the database level?
[00:16:28]  So, Gokumet was working with many clients.
[00:16:32]  So, for a client, we are having client groups.
[00:16:34]  So, they wanted that a client group should see information which is related to their client group IDs.
[00:16:42]  So, client group ID was the parameter using which we have to implement role level security.
[00:16:47]  So, Metabase provides two kinds of embedding.
[00:16:50]  First is static embedding and one is dynamic embedding.
[00:16:53]  For the static embedding, it was free of cost.
[00:16:56]  So, company decided that we will be using static embedding.
[00:16:59]  So, using Metabase, we can define filters and drop downs where we can select client group ID as a filter.
[00:17:06]  To filter to basically to secure the data so and when that dashboard finally integrated into the websites so when a user logins so we are getting client group id of that user and it automatically updates the dashboard accordingly
[00:17:19]  into client propriety for the filter that we have selected for the dashboard.
[00:17:23]  Hold on.
[00:17:24]  Like my question was not entirely this at all.
[00:17:27]  My question is, how did you handle a database level, row level security?
[00:17:31]  Let's say someone bypasses your application layer where you have written the code and someone tries to directly query the database.
[00:17:38]  So your role level security should protect the data at the database level also, right?
[00:17:43]  So my part when I was working there, my part was for the data analysis part.
[00:17:49]  So I used to manage the data cleaning.
[00:17:52]  You were just a data analyst in this?
[00:17:54]  Yes, sir.
[00:17:54]  So I was working on the back end code to prevent this.
[00:17:58]  No, sir.
[00:17:58]  I was working on the data analysis part.
[00:18:00]  So I was working mainly with dbt, metabase, mainly dbt where I was using Jinja to clean the data.
[00:18:08]  You used ingest for background jobs?
[00:18:12]  Yes, sir.
[00:18:13]  Why did you use ingest?
[00:18:15]  So basically ingest was used to sing the user from clerk.
[00:18:20]  With the MongoDB or if I'm using...
[00:18:23]  Basically write a Chrome job for it, right?
[00:18:24]  Why to use an ingest?
[00:18:27]  So this was a project that was made during the training part.
[00:18:32]  So at that time, so they suggested me to use the ingest because it becomes easy to sync the user which are from clear with the database.
[00:18:39]  What is the job in ingest?
[00:18:41]  How do you retry?
[00:18:43]  How do you?
[00:18:44]  How do you retry?
[00:18:45]  How does it retry if job fails?
[00:18:50]  How does it return?
[00:18:51]  For the messaging that are there, how do you ensure messaging order basically?
[00:18:56]  If user A sends a message to user B, so if user A sends message 1 and message 2, okay, how do you guarantee that they don't appear in reverse order?
[00:19:03]  The first message should appear in the first order and the second method should appear in the second order.
[00:19:08]  That should be part of collab, right?
[00:19:13]  Yes.
[00:19:14]  So how did you manage that?
[00:19:16]  Very simple example.
[00:19:17]  You are sending Raga Bhai and then how are you?
[00:19:20]  So Bhai should receive first and how are you should receive second?
[00:19:24]  How do you manage this?
[00:19:26]  In case of let's say first request went, there was a latency issue.
[00:19:29]  Second request went forward.
[00:19:31]  How do you manage the sequencing?
[00:19:36]  Don't.
[00:19:39]  I cannot recall any snowman.
[00:19:44]  So you're good at DSA then?
[00:19:46]  I'll take it.
[00:19:48]  In DSA you can.
[00:19:53]  Which batch you pass out of 2026 LPU?
[00:19:55]  Yes, sir.
[00:19:56]  Where are you staying right now?
[00:19:58]  In college itself.
[00:20:19]  कितना टाइम हो गया लोगेट में आपको लोगेट में मेरा हो गया है लगम से 8-9 मंस 8-9 मंस पहले होस्टल हाँ पहले होस्टल रहता था
[00:20:33]  LRU cache, you know?
[00:20:36]  LRU cache, yeah, it's recently used, it's an English apposition, it's a hard level guy.
[00:20:42]  Open, just type LRU cache, let's do this.
[00:21:29]  And you are from Kanpur.
[00:21:51]  अब मेरा हुआ है सेंचल में 6.5 का लगा हुआ है अभी मैंने ब्लीवो कभी दिया है तो उसका भी सारा राउंड निकल गया था और कंपनी और कोई भी तो प्लेसमेंट सेल में बैठे होगे प्लेसमेंट
[00:23:30]  निकल गया उसके बाद दो इंटरव्यू राउंड वह मेली डीएसए फोकस है और यह एसपेल फोकस है तो वह भी क्लियर किया हूं इसका फाइनली रिजल्ट अभी आना बाकी है 15 को तो मैं राउंड सारे क्लियर हो गए हैं इसका फाइनली आना बाकी और बाकी मेरा एसेंचर का भी हो गया है 6.5 वाला
[00:23:52]  इतने, या, you can continue with this question.
[00:51:08]  What's happening, Adarsh?
[00:51:10]  Yeah, I was saying that.
[00:51:14]  I know, but your approach is correct.
[00:51:21]  I had this kind of stuff.
[00:51:26]  What did you do?
[00:51:28]  We just went to next node.
[00:51:30]  Next node.
[00:51:31]  Previous node.
[00:51:32]  Next node.
[00:51:33]  You have to first check the map.
[00:51:34]  Check the map.
[00:51:34]  Represent.
[00:51:37]  Then after that, what are we doing?
[00:51:38]  We have to start the node.
[00:51:40]  Then we have to set it up where the node is present.
[00:51:43]  Then we have to take the node.
[00:51:46]  उसका previous node ले लिया previous node का next होगा previous node का next होगा node का next हो जाएगा और जो node का जो आगे वाला node होगा उसको मैंने previous node से जोड़ दिया तो मैं लग कि ये connection हो गया है
[00:51:57]  अब जो node अब इसको हमको starting में लगाना है तो node का next है वो head connect हो जाएगा और node का previous head हो जाएगा head connect node हो जाएगा और node का next है उसका जो previous node हो जाएगा तो यहाँ पे भी connection हो जाएगा पूरा उसके बाद map में भी update कर दिया है उसके बाद answer return कर दिया है
[00:52:13]  उन्हें तो minus 1 है और इसमें भी वही same है अगर key पहले से present है तो हम उस note को पहले हटा देंगे
[00:52:48]  Good, actually.
[00:52:55]  Let me pass on your feedback, Adarsh, once.
[00:52:57]  Yes, sir.
[00:52:58]  Yeah, try focusing more on, I know DSA part is important.
[00:53:04]  It's absolutely essential.
[00:53:05]  But what you do right away right now is try focusing and learning more of like what is authentication, what is API gateways, what is, you know, these actually core fundamental concepts.
[00:53:18]  So for the backend, I know basically the basic sub like authentication, I can create APIs or basic APIs.
[00:53:25]  So if you are talking about like production level code, using system design or LLD design, so that part I'm weak at.
[00:53:33]  No, no, no.
[00:53:33]  System designs and no one cares.
[00:53:36]  No one cares.
[00:53:37]  Trust me at this position, this level, no one cares.
[00:53:40]  I'll give you the system design, pura ka pura, when it's actually working together, right?
[00:53:44]  You're directly reporting to me.
[00:53:46]  My responsibility is to give you the entire design.
[00:53:49]  Your responsibility is to write the code for it.
[00:53:52]  Right.
[00:53:53]  That writing code is nothing but a crud operations only.
[00:53:56]  Yes.
[00:53:56]  Understood.
[00:53:57]  So that's the entire profile and job part for someone at your level.
[00:54:02]  Slowly, slowly you will learn.
[00:54:03]  But yeah, actually good speaking to you.
[00:54:06]  I'll pass on your feedback.
[00:54:07]  Let me see.
[00:54:08]  Okay, sir.
[00:54:09]  Okay.
[00:54:09]  Thank you so much.
[00:54:11]  Thank you.