All topics
The Secret of Safe Number Handling in JavaScript
JavaScript’s handling of numbers includes limitations due to its use of a 64-bit floating-point format…
All topics
Managing Database Migrations best practice
Database migrations are essential for maintaining the integrity and structure of applications as they evolve.…
All topics
A Comprehensive Guide to Indexing in MySQL: Boost Your Database Performance
Indexes are essential tools in MySQL that drastically improve query performance, especially when dealing with…
All topics
Exploring Views in MySQL and PostgreSQL: A Guide to Performance, Use Cases, and Materialized Views
Views are a powerful feature in relational databases like MySQL and PostgreSQL, allowing you to…
All topics
Ruby
Ruby on Rails
Avoid N+1 Queries in Rails: Best Practices for Optimized Performance
To avoid the N+1 query problem in Rails, you need to minimize database queries that…
All topics
The secret of Locking Behavior in Mysql and Postgres
The default locking behavior of MySQL and PostgreSQL can affect how transactions interact with one…
Generation
Javascript/Typescript
The Hidden Potential of Incremental Static Regeneration (ISR)
1. What is ISR? ISR (Incremental Static Regeneration) is a rendering strategy introduced by Next.js…
All topics
Database
PostgreSQL
Postgres Index Methods: Things you need to know
In PostgreSQL, different types of index methods are used to optimize query performance, especially for…
All topics
Architecture & Design
Database
PostgreSQL
How to prevent table lock when add/drop index in Postgres?
The CONCURRENTLY option in PostgreSQL is used when creating or dropping indexes to avoid locking…
All topics
Ruby
Behind the Scenes of Ruby Objects lifecycle
In Ruby, objects form the core of the language. Everything in Ruby is an object—from…
