Kkameninpureengine.hashnode.dev·Sep 23 · 4 min readAn Engineer Left ddl-auto=update in Staging. Production Ended Up With Two Columns Instead of One.The deployment window was Sunday night specifically because it was supposed to be quiet, the lowest-traffic slot in the week, the safest possible time to ship a schema change nobody expected to notice00
V-VisuaLeaf - MongoDB Data Workspaceinvisualeaf.hashnode.dev·Sep 22 · 8 min readMySQL Database Management System: Manage Your Data VisuallyMySQL uses tables to store application data. For instance, an online store can have individual tables for its customers, orders, items, and transactions. SQL is the language used to read and change th00
HDHarsh Dubeyindecoding-dev.hashnode.dev·Sep 17 · 15 min readFrom One Click to a Screen Full of Data: A Full-Stack Story for People Who Never Studied Computer ScienceRead this before your first line of code — not after. Why I'm writing this Hi I'm Harsh Dubey I am an ECE grad, not a CSE one. Nobody ever sat me down and explained what a computer actually does. So w11S
MMehradinmehradsadeghi.hashnode.dev·Sep 13 · 8 min readMySQL Overselling: Why SELECT Isn't Enough and How SELECT ... FOR UPDATE Solves ItImagine you’re running an online store, there’s exactly one item left in stock. Two customers click Buy at almost exactly the same time. Both requests reach your application. Both transactions ask the00
MMehradinmehradsadeghi.hashnode.dev·Sep 13 · 8 min readTwo Transactions, One Row: What Does MySQL Actually Let You See ?Can one transaction see another transaction’s uncommitted changes ? Can the same query return different results inside a single transaction ? And why does SELECT sometimes give you a snapshot, while S00
ZZyVOPinblog.zyvop.com·Sep 10 · 18 min readPostgres vs MySQL vs MongoDB: The 2026 Decision GuidePostgreSQL just posted its biggest DB-Engines score gain on record. MySQL still outranks it on raw popularity. MongoDB makes you read a license clause before you build a business on top of it. None of00
SHSanskriti Harmukhinvultr.hashnode.dev·Sep 9 · 8 min readInstalling WordPress on Ubuntu 24.04WordPress is a free, open-source content management system (CMS) built with PHP and backed by MySQL or MariaDB. It began as a blogging tool and has since grown into one of the most widely used platfor00
SHSarwar Hosseininwebequipe.hashnode.dev·Sep 9 · 6 min readStoring PDF Content Page by Page: A Database Design Deep DiveThe schema and query design behind page-level indexing, and how it quietly makes page-number search results possible. On this page The Problem With One Text Blob Per File Splitting Storage by Page 00
DDreievinl2calendar.hashnode.dev·Sep 6 · 4 min readBuilding a game server tracker: what I learned exposing a public JSON APIA few months ago I shipped L2 Calendar, a tracker for Lineage 2 private server openings. Players kept asking the same thing: "when's the next Interlude server?" and server owners had no good place to 00
DNDavid Nguyenineplus.dev·Sep 4 · 14 min readMigrating to Cloud SQL from Amazon RDS for MySQL Using Database Migration Service - GSP859Overview Database Migration Service provides options for one-time and continuous jobs to migrate data to Cloud SQL. It offers various connectivity methods, including IP allowlists, reverse SSH tunnels00
