Pradip KharalTransitioning from Normalization to DenormalizationIn database management system achieving an optimal performance is a constant challenge as data volumes and user demands grows. Traditional…Jul 24Jul 24
Pradip KharalQuery Performance in postgresqlQuery performance is a critical aspect of database management that focuses on the efficiency and speed at which database queries are…Jul 20Jul 20
Pradip KharalFull text search in postgresqlFull text searching or just text search is a process of identifying natural-language documents that satisfy a query, and optionally to sort…Jul 18Jul 18
Pradip KharalViews On SqlA view in sql are virtual tables, having saying that it does not store any data on disk like tables but it define sql statement and that…Jul 17Jul 17
Pradip KharalConverting a Callback Function to a Promise.Converting callbacks to Promises in JavaScript offers several benefits that make asynchronous code easier to read, write, and maintain:Jul 16Jul 16
Pradip KharalIndexing on database to increase performance and it’s trade-offs.In database , indexing is a technique used to improve the speed of the data retrieval operations on a table at the cost of additional…Jul 16Jul 16
Pradip KharalEmail As Micro service in Go langThe micro-services architecture is a development methodology wherein you can divide a single application into a series of smaller services…Feb 3, 2021Feb 3, 2021
Pradip KharalHow I Made A YouTube Bot ?Well, let’s start with a bot. A bot is a software application designed to do automation task without help of human. So typically they…Dec 11, 2020Dec 11, 2020