Shreyansh's blog
SQL Performance Explained by Markus Winand

SQL Performance Explained by Markus Winand

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

Shreyansh Gupta
Shreyansh Gupta
4 min read
Example for optimizing queries

Example for optimizing queries

Shreyansh Gupta
Shreyansh Gupta
6 min read
How to write efficient queries in MySQL

How to write efficient queries in MySQL

Shreyansh Gupta
Shreyansh Gupta
10 min read
Indexes in MySQL

Indexes in MySQL

Shreyansh Gupta
9 min read
Data types in MySQL

Data types in MySQL

Shreyansh Gupta
8 min read
Strong migrations in Ruby on Rails

Strong migrations in Ruby on Rails

Shreyansh Gupta
3 min read
ACID transactions in databases

ACID transactions in databases

Shreyansh Gupta
3 min read
gh-ost - an Online Schema Change tool

gh-ost - an Online Schema Change tool

Shreyansh Gupta
5 min read
Replication formats in databases

Replication formats in databases

Shreyansh Gupta
4 min read
Strong migrations

Strong migrations

Shreyansh Gupta
9 min read
Multiple granularities of database locks

Multiple granularities of database locks

Shreyansh Gupta
4 min read
Isolation levels in database transactions

Isolation levels in database transactions

Shreyansh Gupta
3 min read