PMPhilip McClarenceinpostgresdba.hashnode.devHow to Find and Fix Missing Indexes in PostgreSQLHow to Find and Fix Missing Indexes in PostgreSQL A sequential scan on a 100-row table takes microseconds. A sequential scan on a 10-million-row table takes hundreds of milliseconds. The SQL is identical. The schema is identical. The only difference ...18h ago·5 min read
SDSylvester Dasinminifyn.comDecoding Code: Common Mistakes New Programmers Make (and How to Avoid Them)Starting your journey into the world of programming can feel like learning a new language – because, well, it is! You're bound to stumble, make mistakes, and sometimes feel like your code is actively 22h ago·7 min read
PMPhilip McClarenceinpostgresdba.hashnode.devUnderstanding and Fixing Table Bloat in PostgreSQLUnderstanding and Fixing Table Bloat in PostgreSQL Every row you update in PostgreSQL leaves a corpse behind. Not metaphorically -- literally. PostgreSQL's MVCC architecture means that UPDATE doesn't modify a row in place. It creates a brand new vers...1d ago·5 min read
PMPhilip McClarenceinpostgresdba.hashnode.devPostgreSQL Autovacuum Tuning: A Practical GuidePostgreSQL Autovacuum Tuning: A Practical Guide Here's a question that separates experienced PostgreSQL operators from everyone else: how many dead tuples does your busiest table accumulate before autovacuum kicks in? If you're running defaults on a ...1d ago·6 min read
PPPayal Porwalincodeswithpayal.hashnode.devDay 36 – Money Tracker (Filtering, Sorting, Pagination, Validation, Frontend)By the end of Day 36, students will be able to: ✅ Filter data (income / expense)✅ Sort data (amount, latest first)✅ Use pagination (page & limit)✅ Validate input properly✅ Connect frontend (HTML/CSS/J2d ago·6 min read
AJAkshat Jaininakshatjme.hashnode.devStrategies to Scale Database WritesIn the previous article, we saw how to scale reads by reducing the amount of work the database has to do for every query. Writes have a different problem. A write is not just “store this data”.A write often means: Update indexes Maintain order Enfor...2d ago·3 min read
AJAkshat Jaininakshatjme.hashnode.devStrategies to Handle Both Reads and Writes at ScaleIn the previous two articles, we saw something important: To scale reads, we reduce the work the database does per query. [LINK] To scale writes, we reduce the work the database does per insert. [LINK] But what happens when a system has both heavy ...2d ago·7 min read
PPPayal Porwalincodeswithpayal.hashnode.devDay 35 – Complete CRUD with MySQL (Node.js + Express)Mini Project Start: 💰 Money Tracker Day 35 Goal By the end of Day 35, students will be able to: ✅ Perform complete CRUD with MySQL✅ Create Update & Delete APIs✅ Handle errors properly (best practice3d ago·6 min read
ATAditya Trivediinadityatrivedi.hashnode.devThe Thundering Herd Problem: ExplainedImagine you're standing outside Apple store on the release of it's new store. The doors are locked, and 1,000 people are huddled outside, all waiting for the same new IPhone 18 Pro Max. The moment tho3d ago·6 min read
PPPayal Porwalincodeswithpayal.hashnode.devMaster the Top SQL Queries: Clear Explanations + Practical Examples1️⃣ SELECT (Basic Data Fetching) 🔹 What it does: Fetch data from a table. 🔹 Syntax: SELECT column1, column2 FROM table_name; 🔹 Example: SELECT name, salary FROM employees; 🔹 Use Case: Showing u3d ago·5 min read
