Latest blogs

Keep learning new technologies.

composite index vs single column index

By admin

When deciding between using a composite index or single column indexes, it's essential to understand the differences and when one might be more beneficial than the other. Here's a comparison of the two:

Posted 9 months ago

Minimal app with Go,Gorm and Psql

By admin

To create a basic CRUD application in Go using Gorm and PostgreSQL, you need to have Go installed on your machine, PostgreSQL setup, and the Gorm package included in your project. Here's a step-by-step guide to set up a basic CRUD application:

Posted 9 months ago

find the largest distance between characters.

By admin

To find the largest distance between occurrences of a character x in a string str, where the distance is defined as the number of unique characters between two occurrences of x, you can iterate through the string while maintaining a set to track unique characters and an integer to track the maximum distance. Here's a step-by-step approach:

Posted 9 months ago

Handling concurrent data modifications in a psql database inside transaction

By admin

Using SELECT ... FOR UPDATE within a transaction is a standard and recommended practice for handling concurrent data modifications in a database. However, while it is designed to maintain data integrity, there are some scenarios where it could lead to potential issues if not used carefully:

Posted 9 months ago

What is partition in PSQL?

By admin

The `PARTITION BY` clause in PostgreSQL is used with window functions or for table partitioning. In the context of window functions, it defines a set of rows, or a "window," over which the function operates. When used for table partitioning, it defines how the table is divided into partitions based on the column values.

Posted 9 months ago

30+ Essential CSS Interview Questions and Answers

By admin

CSS (Cascading Style Sheets) is a cornerstone technology of the web, responsible for styling and laying out web pages. Here are over 30 interview questions ranging from fundamental concepts to complex scenarios, ideal for gauging expertise in CSS.

Posted 9 months ago