Articles by Tag #mysql
Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!
CRUD Isn’t a Lifestyle: Stop Turning It Into a Spiritual Journey
Let’s clear something up. CRUD is not a religious ritual. It’s not a PhD thesis. It’s not the final...
Powering Up PolyDisease Predictor: Backend Integration and Expanding Horizons! 🚀
Hey everyone! I'm excited to share some significant progress on the PolyDisease Predictor, a...
How MySQL Actually Works: A Deep Dive into Database Internals
You write this query: SELECT * FROM users WHERE id = 42; Enter fullscreen mode ...
Battling Laravel's Sneaky DELETEs: How I Got ORDER BY and LIMIT to Play Nice with Joins
Hey folks, if you've ever stared at your terminal in horror as Laravel cheerfully deletes half a...
I solved the local database problem, so I built a tool
I hit a massive pain point in my day-to-day work—and once I solved it for myself, I couldn’t not...
🚀 sqltool: A Lightweight Local MySQL/MariaDB Instance Manager (No Containers Needed)
👉 GitHub repo: sqltool If you’ve ever spun up a MySQL or MariaDB database for local...
Part 1 - MySQL vs PostgreSQL: Connection Architecture
Part 1 - MySQL vs PostgreSQL: Connection Architecture MySQL and PostgreSQL take...
HNG Portal DevOps Technical Documentation
On behalf of my team... Executive Summary This document outlines the complete DevOps...
Scaling Read Tracking with Redis Bitmaps
A friend recently came to me with a problem. They had designed a feature to track whether each user...
Part 3 - MySQL vs PostgreSQL: Features & Capabilities Comparison
Table of Contents 1. Philosophy & Design Principles: The Core DNA 2. Standards...
Part 4: MySQL vs PostgreSQL - Transaction Processing and ACID Compliance
Table of Contents 1. Overview: Key Architectural Differences 2. Isolation Levels and...
Part 2 - MySQL vs PostgreSQL: Storage Architecture
MySQL and PostgreSQL take fundamentally different approaches to data storage. MySQL (InnoDB) uses a...
How to Create a Web App with Crow C++, MySQL, and TailwindCSS
Watch the series/playlist containing 9 videos that show step-by-step how to develop a web application...
Partition-Based Parallel Data Loading: An Architectural Practice for Improving Mass Data Import Efficiency
In modern database systems, data volume is growing exponentially. How to efficiently load data from...
🚀 Introducing Laravel ObjectId — The Fastest MongoDB-Style Identifier for Laravel Models
Works seamlessly with MySQL, MariaDB, and PostgreSQL — no MongoDB required. Every Laravel...
PostgreSQL MVCC vs MySQL Key-Next Locking: How Transaction Isolation Affects Concurrency
When developers talk about ACID databases, two giants dominate: PostgreSQL and MySQL (InnoDB). Both...
MySQL Installer Not Working on Windows 11 25H2 — Full Fix (Error Code 2738 / VBScript Missing)
Author: Mukesh Lilawat Updated: October 2025 🧩 Overview After updating to Windows 11...
MySQL Memory Management and Replication Best Practices for High-Load Environments
Understanding MySQL’s Memory Use and OOM Risks: MySQL heavily utilizes caching and memory buffers,...
How a Cache Invalidation Bug Nearly Took Down Our System - And What We Changed After
A few weeks ago, we had one of those production incidents that quietly start in the background and...
PostgreSQL vs MySQL vs MongoDB in 2026: The Honest Comparison Nobody Asked For
Tired of biased database comparisons? We break down when to actually use PostgreSQL, MySQL, or MongoDB based on real-world use cases, performance data, and developer experience in 2026.
🌏 Nusantara-API 🇮🇩 — from MySQL dump to a tiny 420 KB library
A while ago, I was looking for Indonesian regional data for one of my projects. Most of the datasets...
Is Cloud SQL Enterprise Plus Worth It? Evaluating the MySQL upgrade at SpareRoom
At SpareRoom, MySQL is a core part of our infrastructure and it's been running on Google Cloud SQL...
Build a Complete Data Pipeline from Scratch: CSV to Dashboard Using Python, MySQL, and Airflow”
Building a Simple Yet Powerful Data Pipeline: From Raw CSV to Dashboard Visualization Every Data...
Eliminating Lost Update Anomalies in Spring Boot with Redlock and Custom AOP
In modern distributed systems, ensuring data consistency under high concurrency is one of the biggest...
Database Indexing Done Right: Why Your "Optimized" Queries Might Be Slower Than Before
The Indexing Paradox That Cost Me 3 Seconds Per Query I learned the hard way that adding...
Overview of Real-Time Data Synchronization from MySQL to VeloDB
In the process of migrating data from MySQL (including MySQL-compatible databases such as Amazon...
Country Data API
A RESTful API that fetches country data from external APIs, stores it in a MySQL database, and...
SQL Commands Guide
Introduction Structured Query Language (SQL) is the standard language used to manage...
Lesson 3 - Integrating MySQL (First Database)
Series: From Code to Cloud: Building a Production-Ready .NET Application By: Farrukh Rehman - Senior...
Express + MySQL Boilerplate Project Structure (Real App Ready)
project-root/ │ ├── src/ │ ├── config/ │ │ ├── db.js │ │ └── index.js │ │ │ ├──...