Understanding MySQL Indexes Through Everyday Queries
Learn when indexes help searches and how to inspect queries with EXPLAIN.
A JOURNAL ABOUT TECHNOLOGY
Learn something new.
Write. Share.
A space to connect knowledge, one line of code a day.
Discover tutorials, ideas, and notes from a learning journey.
FOR YOUR CURIOSITY
Latest notes.
Database Transactions: Keeping Changes Together
Understand commit and rollback through a stock transfer between locations.
Database normalization: from 1NF to 3NF
Reduce data duplication by understanding the three most commonly used normal forms.
Understanding database transaction level isolation
Learn the difference between Read Committed and Repeatable Read and their impact on concurrently read data.
Connection pooling: why apps need a database connection pool
Find out why database connections should be reused, not opened and closed each request.
Knowledge grows when shared.
Stay curious. There is always something new to learn.
ABOUT THE AUTHOR
Dr (C). Ir. Putu Adi Guna Permana, S.Kom., M.Kom., IPM., ASEAN Eng.
Writer and founder of Diary Coding — sharing notes, tutorials, and experiences about programming for anyone who wants to keep learning.