✕ Clear all filters
122 articles
▶ Videos →

📰 Dev.to · Mads Hansen

122 articles · Updated every 3 hours · View all reads

All Articles 184,939Blog Posts 166,975Tech Tutorials 49,659Research Papers 36,240News 23,023 ⚡ AI Lessons
A successful pg_dump is not a recovery test
Dev.to · Mads Hansen 🔧 Backend Engineering 1mo ago
A successful pg_dump is not a recovery test
A nightly pg_dump exits zero. That proves a backup command ran—not that the system is recoverable. A...
Your RLS policy can work while the error still leaks data
Dev.to · Mads Hansen 🔧 Backend Engineering 1mo ago
Your RLS policy can work while the error still leaks data
A forbidden row never appears. Then the database says duplicate key or foreign key violation—and the...
LIMIT 20 is not a sampling strategy
Dev.to · Mads Hansen 📊 Data Analytics & Business Intelligence 1mo ago
LIMIT 20 is not a sampling strategy
“Show me twenty examples” sounds harmless. The generated SQL adds LIMIT 20 without a stable...
Three correct database queries can produce one contradictory AI answer
Dev.to · Mads Hansen 📰 AI News & Updates 1mo ago
Three correct database queries can produce one contradictory AI answer
An AI assistant asks the database three reasonable questions: how many incidents are open? which...
Your AI did not change the metric. Your business did.
Dev.to · Mads Hansen 📊 Data Analytics & Business Intelligence 1mo ago
Your AI did not change the metric. Your business did.
Ask an AI assistant for MRR today and again next quarter. The SQL can be valid both times while the...
Two safe database aggregates can reveal one person's value
Dev.to · Mads Hansen 📰 AI News & Updates 1mo ago
Two safe database aggregates can reveal one person's value
An aggregate can hide every row and still reveal one person's value. Imagine an AI assistant returns...
Your enterprise AI answer needs more than a generated-at timestamp
Dev.to · Mads Hansen 📰 AI News & Updates 1mo ago
Your enterprise AI answer needs more than a generated-at timestamp
An enterprise AI answer can be correct and already too old. The query ran seconds ago. The warehouse...
The credential that discovers your database should not query it
Dev.to · Mads Hansen 📰 AI News & Updates 1mo ago
The credential that discovers your database should not query it
The credential that helps an AI discover a database should not automatically be able to query...
A valid SQL query is not proof that the question was answerable
Dev.to · Mads Hansen 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
A valid SQL query is not proof that the question was answerable
A syntactically valid SQL query can still be the wrong answer. Ask, “How many active customers do we...
The MCP server you choose should pass an exit test
Dev.to · Mads Hansen ☁️ DevOps & Cloud ⚡ AI Lesson 1mo ago
The MCP server you choose should pass an exit test
The easiest MCP server to adopt can become the hardest one to leave. The endpoint is not the whole...
AI needs your database schema. It does not need every row.
Dev.to · Mads Hansen 📰 AI News & Updates ⚡ AI Lesson 1mo ago
AI needs your database schema. It does not need every row.
An AI assistant needs enough database structure to form useful questions. It does not need...
A database credential is not rotated until the old one fails
Dev.to · Mads Hansen 🔐 Cybersecurity ⚡ AI Lesson 1mo ago
A database credential is not rotated until the old one fails
Creating a new database secret is the beginning of a rotation—not the end. The old credential may...
Audit logs become a liability when they copy every database result
Dev.to · Mads Hansen 🔐 Cybersecurity ⚡ AI Lesson 1mo ago
Audit logs become a liability when they copy every database result
An audit log can begin as a security control and end as a second database full of sensitive...
Don't let the first real user become your database connector test
Dev.to · Mads Hansen 🔧 Backend Engineering ⚡ AI Lesson 1mo ago
Don't let the first real user become your database connector test
The worst time to discover a database connector's assumptions is when the first executive asks it a...
A database answer without provenance is just a confident claim
Dev.to · Mads Hansen 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
A database answer without provenance is just a confident claim
A fluent database answer can be impossible to review. The number looks plausible, but the response...
Let ChatGPT explain the finance close only after the numbers reconcile
Dev.to · Mads Hansen 📰 AI News & Updates ⚡ AI Lesson 1mo ago
Let ChatGPT explain the finance close only after the numbers reconcile
The dangerous finance-close answer is not obviously wrong. It is a polished explanation built from...
A new database connector can return a valid answer and still break the contract
Dev.to · Mads Hansen ☁️ DevOps & Cloud ⚡ AI Lesson 1mo ago
A new database connector can return a valid answer and still break the contract
A database connector migration can pass every setup check and still change the answer. The new path...
A database count can still reveal the row you tried to hide
Dev.to · Mads Hansen 🔐 Cybersecurity ⚡ AI Lesson 1mo ago
A database count can still reveal the row you tried to hide
A read-only AI database tool can block names, emails, and row exports and still reveal a...
The useful output of anomaly detection is a review queue, not another dashboard
Dev.to · Mads Hansen 📊 Data Analytics & Business Intelligence ⚡ AI Lesson 1mo ago
The useful output of anomaly detection is a review queue, not another dashboard
A natural-language database workflow should not produce a longer dashboard. It should produce a...
An AI agent should never guess whether a database retry is safe
Dev.to · Mads Hansen 🤖 AI Agents & Automation ⚡ AI Lesson 1mo ago
An AI agent should never guess whether a database retry is safe
“Database error” is not enough information for an AI agent. Was the input invalid? Was access...