DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
For Structured Data, Retrieval Accuracy Isn't a Model Problem
melih_birim_8363f43966da2 profile

For Structured Data, Retrieval Accuracy Isn't a Model Problem

#ai #sql #csv #agents
Comments 2
3 min read
Detecting SQLite Full Table Scans in Node.js
edysilva profile

Detecting SQLite Full Table Scans in Node.js

#node #sqlite #performance #sql
Comments
3 min read
Why AI-Generated Migrations Need a Different Gate Than Code Patches
github_7727 profile

Why AI-Generated Migrations Need a Different Gate Than Code Patches

#database #postgres #softwareengineering #sql
Comments 1
4 min read
Database Isolation Levels & Read Phenomena: An Extensive Deep Dive
urvish_shah profile

Database Isolation Levels & Read Phenomena: An Extensive Deep Dive

#backend #database #sql
1
Comments 1
12 min read
Composite Indexes Explained: Why Column Order Is the Whole Game
arnavsharma2711 profile

Composite Indexes Explained: Why Column Order Is the Whole Game

#database #sql #postgres #backend
Comments
4 min read
Your Index Only Scan Is Lying: Covering Indexes and the Visibility Map
arnavsharma2711 profile

Your Index Only Scan Is Lying: Covering Indexes and the Visibility Map

#database #postgres #sql #performance
Comments
4 min read
iris-agentic-dev -- Give Your AI a Live Connection to IRIS, Part 1: The Problem, the Tool, and Getting Started
intersystemsdev profile

iris-agentic-dev -- Give Your AI a Live Connection to IRIS, Part 1: The Problem, the Tool, and Getting Started

#sql #ai #coding #tooling
Comments
8 min read
How Database Indexes Work (And Why Yours Might Be Useless)
arnavsharma2711 profile

How Database Indexes Work (And Why Yours Might Be Useless)

#database #programming #sql
Comments
6 min read
The SQL Worked Perfectly. The Data Was Wrong.
eduardo-ortega profile

The SQL Worked Perfectly. The Data Was Wrong.

#sql #database #debugging #programming
Comments 2
5 min read
GROUP BY and HAVING: How to Summarize Rows Without Getting a Fake Answer
michaelnocito profile

GROUP BY and HAVING: How to Summarize Rows Without Getting a Fake Answer

#sql #database #tutorial #beginners
Comments
13 min read
SQL Foundations, Start to Finish
michaelnocito profile

SQL Foundations, Start to Finish

#sql #database #tutorial #beginners
Comments
15 min read
SQL Window Functions: How to Get the Top Row Per Group
michaelnocito profile

SQL Window Functions: How to Get the Top Row Per Group

#sql #database #tutorial #beginners
Comments
15 min read
SQL CTEs: How to Build a Query in Steps You Can Check
michaelnocito profile

SQL CTEs: How to Build a Query in Steps You Can Check

#sql #database #tutorial #beginners
Comments
12 min read
How to Grade Search Relevance Before You Touch the Ranking Weights
libme profile

How to Grade Search Relevance Before You Touch the Ranking Weights

#postgres #database #sql #testing
Comments
6 min read
Your Test Went Red. Can You Read It?
onurkesim profile

Your Test Went Red. Can You Read It?

#postgres #testing #sql #debugging
Comments
8 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.