Mohit Gupta

Mohit Gupta

I am a passionate postgraduate student at IIIT-Delhi, pursuing M.Tech in CSE with a specialization in AI. My focus lies in the captivating field of NLP, particularly in Text Generation and LLMs.

5 Important PostgreSQL functions

less than 1 minute read

Published:

Hello folks, I’m back with a new article. This article is a bit interesting and knowledgeable as you can see in the title as well. This article can be very useful for you during your databases interviews and exams. This topics were asked in my interview, and in some of them, I’m blank at that moment XD. Then, I learn about these concepts and find them very interesting.

In this article, I’ll be discussing about some of the powerful functions of the postgreSQL, which can help you in solving mathematical queries in your interviews and exams. With this, I’ll be discussing some questions as well so that you can understand where we can use these functions properly.

This article is published on Medium.
Do check here

You May Also Enjoy

Stooge Sort: An Un-popular sorting Algorithm

less than 1 minute read

Published:

Stooge sort is a sorting algorithm, used to sort a linear array having n number of elements. What it does is, recursively sorts the partitions of the array of 2/3rd size, and after sorting each partition, the complete array gets sorted. It is not much efficient algorithm, but this algorithm can help to get a better understanding of recursion. Read more

Introduction to DICOM & its Viewers

less than 1 minute read

Published:

Hey Readers! Hope you are doing well. In this article, I’ll be sharing some of my learning in Medical Science Technologies I had learned during one of the best phases of my life…My Summer Internship at e-Yantra Labs, where I got a chance to research in the field of Medical Imaging & Radiology.
Read more

A Simple RESTful API using Nodejs & PostgreSQL.

less than 1 minute read

Published:

Hey geeks! Hope you are doing well. From the title of this article, you will understand what we are talking about in this article. So in this article, we will be learning how easy can be to build a RESTFUL API, integrated with a PostgreSQL server. I learned it when one of my friends needs a secure interface for sending the sensor data from the hardware to the SQL server. He asked me, is there was any way I can send the data directly to the server? So, the first time I worked with SQL & NodeJs. Because in most of the cases Nodejs is combined with NoSQL servers like Mongo DB.
Read more