Search
Dispelling the Myth: count(*) vs. count(1) Efficiency in Modern Databases
As an experienced DBA, I often encounter the belief that SELECT COUNT(1) is faster than SELECT COUNT(*). While this may have held true...
Alon Spiegel
Nov 26, 20231 min read
Real world use case for JSON in RDBMS PostgreSQL
How I used JSON in RDBMS. I used PostgreSQL but other databases that support JSON, such as MySQL, can also be used
Alon Spiegel
Jan 7, 20212 min read
Monitoring Databases
Let’s imagine a futuristic refrigerator, fridge for short. This fridge has the most amazing feature, it can recognize the groceries...
Ishay Wayner
Jan 2, 20212 min read