#database Development Tutorials & Tips | Roast Dev

100daysofcode 100daysofdevops 100pay 10mistakes 10yearworkanniversary 11 11labs 11tly 11ty 127001

SQL Execution Order: What Really Happens Under the Hood

If you’ve ever written SQL queries and wondered why sometimes things don’t behave as you expect —or why certain clauses must come before others— you’re not alone. SQL can feel a bit weird at...

12.04.2025 0 Read More

How MySQL Handles a Single Data Insert

1. Background: Basic MySQL Architecture Overall, MySQL is roughly divided into two parts: the Server layer and the Storage Engine layer. Server Layer This includes the connection mana...

12.04.2025 0 Read More

Database Optimization: Partitioning vs Indexing

𝗣𝗮𝗿𝘁𝗶𝘁𝗶𝗼𝗻𝗶𝗻𝗴 - Horizontal partitioning divides large tables across multiple storage nodes based on region, such as East, West, and South.Vertical partitioning, on t...

12.04.2025 0 Read More

📍The Art of Choosing the Right Database

"Should I use SQL or NoSQL? B-Trees or LSM Trees?" If you've ever felt overwhelmed choosing the right database for your app, you're not alone. Underneath every database is a rich ecosystem of storage...

13.04.2025 0 Read More

Data Models in DBMS

Database Management System allows us to store tons of data in an efficient manner. A Data Model defines how data is stored, connected and accessed. Essentially, it is the backbone of DBMS.Here are som...

13.04.2025 0 Read More

Duplicate Rows Detection in MySQL

Duplicate Rows Detection in MySQL We've been working on a Candidate Management system for JoBins, a platform that allows recruitment agents to Manage their Candidates. Sometimes, the same ca...

13.04.2025 0 Read More

Understanding Atomicity: The First Pillar of ACID Transactions

Introduction If you've worked with relational databases, you've likely come across the term ACID—an acronym that ensures reliable database transactions. Each letter in ACID holds deep meani...

13.04.2025 0 Read More

"MMAP" System Call for DBMS

MMAP, which stands for Memory Mapping, allows to map files into a process's virtual memory space. It makes it faster to load certain things, as the common data can be kept in primary memory (like RAM)...

13.04.2025 0 Read More

Entity-Relationship (ER) Diagrams: Visualizing Your Database Structure

What is an ER Diagram? An Entity-Relationship (ER) Diagram is a visual representation of the entities in your database, their attributes, and the relationships between them. It serves as a blueprint f...

13.04.2025 0 Read More

Belajar Flyway Episode 1: Pengenalan dan Migrasi Pertama

Pendahuluan Halo teman-teman! Selamat datang di seri Belajar Flyway. 🎉 Di episode pertama ini, kita akan berkenalan dengan Flyway, sebuah tool untuk mengelola migrasi database, dan langsun...

13.04.2025 0 Read More

SQL Execution Order: What Really Happens Under the Hood

How MySQL Handles a Single Data Insert

Database Optimization: Partitioning vs Indexing

📍The Art of Choosing the Right Database

Data Models in DBMS

Duplicate Rows Detection in MySQL

Understanding Atomicity: The First Pillar of ACID Transactions

"MMAP" System Call for DBMS

Entity-Relationship (ER) Diagrams: Visualizing Your Database Structure

Belajar Flyway Episode 1: Pengenalan dan Migrasi Pertama

#reading

#popular