Shreyansh's blog

Shreyansh's blog

Shreyansh's blog

Example for optimizing queries

Example for optimizing queries

Nov 29, 20246 min read

How to write efficient queries in MySQL

How to write efficient queries in MySQL

Nov 29, 202410 min read

SQL Performance Explained by Markus Winand

SQL Performance Explained by Markus Winand

Here, I have listed some interesting concepts from the book.

Dec 14, 20244 min read

Indexes in MySQL

Indexes in MySQL

Nov 24, 20249 min read

Data types in MySQL

Data types in MySQL

Nov 20, 20248 min read

Strong migrations in Ruby on Rails

Strong migrations in Ruby on Rails

Gems in Ruby on Rails to facilitate Strong Migrations.

Nov 17, 20243 min read

ACID transactions in databases

ACID transactions in databases

Understand ACID transactions in context of databases.

Nov 17, 20243 min read

gh-ost - an Online Schema Change tool

gh-ost - an Online Schema Change tool

Let's take a look at github/gh-ost, an Online Schema Change (OSC) tool.

Oct 27, 20245 min read

Replication formats in databases

Replication formats in databases

Understanding the different replication formats in databases.

Oct 26, 20244 min read

Strong migrations

Strong migrations

Understanding strong migrations while working on applications with large databases.

Oct 24, 20249 min read

Multiple granularities of database locks

Multiple granularities of database locks

Understand the multiple granularities of database locks

Oct 19, 20244 min read