Vishad Patel

@vishadtech09

From Code to Content: The Full Stack Engineer Who Writes the Future

Gujarat, IndiaJoined June 2024

About

Nothing here yet.

Available for

Consulting, project-based work, or long-term collaboration. Let’s connect to discuss how my technical prowess can drive your business.

Vishad Patel's blogs

TechieBytesvishad.hashnode.dev32 posts

Articles Threads Comments

Recently published

vishad.hashnode.dev

Hibernate Performance Tuning: Cut Memory & Latency with Read-Only Sessions

Most developers working with Hibernate rely on the default Session, which comes with a built-in persistence context (a first-level cache). This persistence context is great for tracking loaded entities, detecting changes, and managing dirty checking—...

Sep 6, 20253 min read

vishad.hashnode.dev

MySQL & PostgreSQL Performance: The Hidden Cost of Using Functions on Indexed Columns

🚨 Problem: A common mistake in SQL queries is applying functions like LOWER(), UPPER(), TRIM(), or DATE() directly on indexed columns. When you do this, the database engine cannot use the index efficiently, because the expression inside the WHERE cl...

Sep 5, 20253 min read

vishad.hashnode.dev

Unlock Faster Queries: A Guide to Composite Indexes in MySQL & PostgreSQL

🚨 Problem: When your SQL queries involve filtering and sorting using multiple columns, relying on individual (single-column) indexes often causes the database to ignore those indexes — or worse, perform a full table scan. This results in slower perf...

Sep 5, 20253 min read

vishad.hashnode.dev

How to Solve Even Subarrays on Leetcode

Problem Description You are given an integer array A. Your task is to determine whether it is possible to divide this array into one or more subarrays, each having an even length. Additionally, for each of these subarrays, the first and last elements...

Sep 15, 20242 min read

vishad.hashnode.dev

Boost Node.js Security: A Guide to Two-Factor Authentication

Introduction Explanation of Two-Factor Authentication (2FA) Two-Factor Authentication (2FA) is a security process that enhances the protection of your online accounts by requiring two different forms of identification before granting access. This met...

Sep 14, 202416 min read

Vishad Patel

About

Available for

Vishad Patel's blogs

Recently published

Hibernate Performance Tuning: Cut Memory & Latency with Read-Only Sessions

MySQL & PostgreSQL Performance: The Hidden Cost of Using Functions on Indexed Columns

Unlock Faster Queries: A Guide to Composite Indexes in MySQL & PostgreSQL

How to Solve Even Subarrays on Leetcode

Boost Node.js Security: A Guide to Two-Factor Authentication

Search Hashnode

Vishad Patel

About

Available for

Vishad Patel's blogs

Recently published

Hibernate Performance Tuning: Cut Memory & Latency with Read-Only Sessions

MySQL & PostgreSQL Performance: The Hidden Cost of Using Functions on Indexed Columns

Unlock Faster Queries: A Guide to Composite Indexes in MySQL & PostgreSQL

How to Solve Even Subarrays on Leetcode

Boost Node.js Security: A Guide to Two-Factor Authentication