AAnish Ansari14h ago · 7 min readSystem Design Drill Day 4: Read Replicas and Replication LagA customer places an order, gets redirected to "My Orders", and the list is empty. They refresh and the order appears. Anyone who has added read replicas to a busy app will recognise that support tick14KAblog.anishansari.com.np
VV. Vaidehi2d ago · 9 min readBuilding BCB CRM: A Lead Management System with Laravel and MySQLIntroduction For my second MCA mini project, I worked on BCB CRM & Lead Management System, a web application designed to help a business organize and manage its interactions with potential customers. 2Kvaidehi.hashnode.dev
DDalya Akram2d ago · 15 min readWhat I learned from analyzing more than 1M online retail transactionsWhen I started looking for a new data analysis project, I didn’t want another small and already-clean dataset where I could immediately tell what charts I was supposed to make. I wanted something closdalya.hashnode.dev
WWebToolBench4d ago · 2 min readRandom UUIDs as MySQL primary keys: the cost nobody mentionsVersion 4 UUIDs are 122 random bits formatted as 36 characters. Their value is that any system can generate one without coordinating with anything else, and collisions stay effectively impossible. Thawebtoolbench.hashnode.dev
Jjaberadam20015d ago · 11 min readThe Lock Queue: Why a 2 ms ALTER TABLE Can Freeze ProductionYou can watch this outage happen on your own machine in about a minute. All it takes is three database sessions and an ALTER TABLE that, on its own, finishes in milliseconds. Most zero-downtime migratsimplyexplained.hashnode.dev
Aara-ta3Oct 15 · 5 min readHow to Get the Latest Row per Group in MySQL 8 Using ROW_NUMBER()Introduction I sometimes need to get the latest row for each group in MySQL: the most recent login per user, the latest status per order, or the last edit per article. For MySQL 8.0 and later, ROW_NUMara-ta3.hashnode.dev
MMahir FaysalOct 15 · 12 min readMySQL GROUP_CONCAT with ORDER BY, SEPARATOR and DISTINCT (Tested on 8.4)To join several rows into one string per group in MySQL, use GROUP_CONCAT() with GROUP BY. The order and the separator go inside the brackets: GROUP_CONCAT(subject ORDER BY subject SEPARATOR ', '). Admfaysaldev.hashnode.dev
SSanskriti HarmukhOct 14 · 5 min readInstalling phpMyAdmin on Ubuntu 24.04phpMyAdmin is an open-source, web-based tool for managing MySQL databases. Installing it gives you a browser interface for creating, modifying, and deleting databases, tables, and fields, managing usevultr.hashnode.dev
Jjaberadam2001Oct 13 · 12 min readOffset vs Cursor Pagination: The 3 Ways Rows Still Go MissingYou ship an infinite-scroll feed. A week later a ticket arrives: "Page two sometimes shows a post I just saw on page one." You reproduce it, shrug, and switch the endpoint from LIMIT/OFFSET to cursor simplyexplained.hashnode.dev
MMohammed Abdelhadi KhaterOct 12 · 9 min readHow AI Coding Tools Can Help PHP Developers Work SmarterUsing AI assistants with PHP and MySQL: practical benefits, real limitations, and a better development workflow. Software development is not only about writing code. A developer also needs to understamohammedkhater.hashnode.dev
