Understanding the impact of failed long-running transactions in PostgreSQL, how dead rows affect performance, and comparing different cleanup approaches.

The Hidden Cost of Failed Long-Running Transactions in PostgreSQL

A deep dive into PostgreSQL Index Scans and Index Only Scans, their differences, use cases, and how to optimize your queries using them effectively.

Understanding PostgreSQL Index Scans vs Index Only Scans

Deep dive into PostgreSQL Visibility Map, its role in Index Only Scans, and how to maintain it effectively through VACUUM operations.

PostgreSQL Visibility Map: Understanding and Optimization

Sequential Scan, Index Scan, and Bitmap Index Scan in PostgreSQL with examples and comparisons.

PostgreSQL Scans Explained

This article provides a guide on managing multiple SSH keys for various GitHub.com accounts. It enables you to access multiple accounts and projects, each with distinct credentials.

Git - Effective Guide to Managing Multiple SSH Keys for Different GitHub Accounts

Nginx (pronounced "engine-x") is a popular and powerful open-source web server software. It is often used as a reverse proxy server, load balancer, and HTTP cache*. It is known for its high performance, low resource usage, and ability to handle a large number of concurrent connections efficiently.

NGINX - Load balancer, Web server and Reverse Proxy

This blog demonstrates how you can generate JWT from scratch without using native nodejs crypto module and also shows you how to generate jwt using jsonwebtoken library.

JWT - Generating JWT token from scratch and using Jsonwebtoken library

Generating keypair, data protection(ecnryption and decryption) and digital signature (signing and verifying).

Nodejs - KeyPair generation and usage of keys

In Solidity, a factory is a contract that will deploy multiple instances of other contracts. It is a design pattern that creates contracts based on a template.

Solidity - Simple Contract Factory

The function visibility feature in Solidity smart contracts is used to ensure that when functions are specified, their level of accessibility, including public, external, internal, and private, are maintained as they were intended by the developers.

Hi, I am Krishna🤝

Welcome to a little corner of the web where I share everything from software development hacks to random musings and useful resources. It’s tech, it’s helpful, and it's all me! 💻✨.

Explore.Learn.Develop.

Latest

The Hidden Cost of Failed Long-Running Transactions in PostgreSQL

Understanding PostgreSQL Index Scans vs Index Only Scans

PostgreSQL Visibility Map: Understanding and Optimization