MSMikhail Shytskoinmikhail-shytsko.hashnode.dev·19h ago · 15 min readWriting a Postgres Seed Script That Survives the Next MigrationTL;DR: A seed script is a SQL or code file (seed.sql, seed.ts) that inserts a known set of rows into a Postgres database after migrations run. A good one orders inserts by foreign key, stays idempoten00
MGMahesh Guptainthedebugledger.hashnode.dev·1d ago · 14 min readHow to Diagnose a Slow Oracle SQL Query Before Adding Another IndexPicture this: It's 11 p.m. You've had five Oreos from the office vending machine, and a healthcare claims report that has been finishing in about 10 seconds for months is now 15 minutes in and still r00
MSMr. S. Guptainsurajsrggupta.hashnode.dev·23h ago · 8 min readSQL vs NoSQL, Explained the Way I Wish Someone Had Explained It to MeWhen I was starting out with backend development, there was one question that kept messing with my head more than anything else. Should I be learning SQL or NoSQL? And every single tutorial seemed to 00
RSRajaram Sinrajaram0203.hashnode.dev·23h ago · 9 min read🗄️ Database Fundamentals — SQL vs NoSQL, When to Use Which⏱️ 10–12 min read · 🎯 Beginner · 📚 Part 13 of 20 👉 Missed Part 12? Webhooks — Event-Driven APIs 🎉 Welcome to Section 4 — Databases & SQL Parts 1 through 12 covered how APIs talk to clients and to00
SSystemCraftDevinsystemcraftpress.hashnode.dev·1d ago · 4 min readWhy 'WHERE x = NULL' Never Works in SQL (And What to Use Instead)Adapted from the SQL Essentials Companion Guide. You write a query to find every customer with no phone number on file. WHERE phone = NULL looks obviously correct — and it returns zero rows, even tho00
LZLION ZHANLinplaybasketballbros-engineering.hashnode.dev·1d ago · 8 min readPinpoint #837: Model Delivery Evidence in PostgreSQL Without a Boolean TrapPinpoint #837 is about things that are delivered. For a database designer, the five clues are a warning against reducing a domain event to a single delivered boolean. The puzzle for Saturday, August 100
AArisyninarisyn.hashnode.dev·3d ago · 6 min readThin Agents, Smart Data: A Better Architecture for Enterprise AIAs enterprises move from one AI assistant to many specialized agents, the hard problem shifts from agent intelligence to shared enterprise understanding. The multi-agent future sounds straightforward.00
SLSean Liuinzhaidata.com·4d ago · 9 min readWhat Took BI Engineers Hours, WrenAI Did in 15 Minutes — A Hands-On Test with Manufacturing DataAs a data engineer with years of experience building pipelines and dashboards, I've always felt the traditional BI workflow could be faster: connecting data sources, writing SQL, designing visualizati02S
CMChidozie Managwuinfreecodecamp.org·3d ago · 16 min readHow to Build a Production-Ready AI Agent for $0/Month Using PHP, cPanel, and Gemini FlashIn this tutorial, you’ll build a practical AI agent that can receive a user prompt, decide whether it needs to use a tool, execute that tool in PHP, store conversation history in MySQL, and continue r00
MNMichael Nocitoinmichaelnocito.hashnode.dev·4d ago · 20 min readSubquery vs CTE in SQL: Same Logic, One You Can CheckBy the end of this page you can write a query that uses the answer to another query, recognise the four places one can go, spot the correlated kind that runs once per row, avoid the NOT IN that silent00
