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.
When Runtime Plans Enter the Prompt: A Structured Debate for SQL Review Bots
dataio_4921 profile

When Runtime Plans Enter the Prompt: A Structured Debate for SQL Review Bots

#postgres #sql #ai #security
Comments
8 min read
Ranking a Two-Dimensional Catalog With One SQL Expression
citationbuilder profile

Ranking a Two-Dimensional Catalog With One SQL Expression

#sql #postgres #webdev #database
Comments
5 min read
SQL Basics: A Real-World Guide to Databases and Queries
harshitha_madhavarapu profile

SQL Basics: A Real-World Guide to Databases and Queries

#sql #database #beginners #tutorial
Comments
4 min read
SQL Interview Questions (With Model Answers)
peakblick profile

SQL Interview Questions (With Model Answers)

#sql #beginners #interview #database
Comments 1
4 min read
SQL Starters
kalyanam_venumadhav_aaddf profile

SQL Starters

#sql #sqlserver #database #mysql
Comments
2 min read
How I stopped manually rebuilding Java PreparedStatement SQL
olimar50 profile

How I stopped manually rebuilding Java PreparedStatement SQL

#java #sql #jdbc #webdev
Comments
2 min read
The Data Modeling Concepts Nobody Mentions After Star Schema 101
rahmanfrr profile

The Data Modeling Concepts Nobody Mentions After Star Schema 101

#dataengineering #datamodeling #sql #tutorial
1
Comments
6 min read
Why Your JOIN Doubled Your Totals — There's No Error, Just the Wrong Number
systemcraftdev profile

Why Your JOIN Doubled Your Totals — There's No Error, Just the Wrong Number

#sql #database #beginners #tutorial
1
Comments
4 min read
Why Adding an Index Won't Fix Your Slow COUNT(*) in PostgreSQL
bodanthebackend profile

Why Adding an Index Won't Fix Your Slow COUNT(*) in PostgreSQL

#postgres #sql #database #performance
1
Comments 1
5 min read
SQL PRACTICAL GUIDE
karen_wangui_ profile

SQL PRACTICAL GUIDE

#sql #datascience
1
Comments
4 min read
I gave my text-to-SQL agent a business glossary. One version helped a lot, one did nothing.
ashish_sinha_5241c7673d93 profile

I gave my text-to-SQL agent a business glossary. One version helped a lot, one did nothing.

#agents #ai #llm #sql
1
Comments 9
3 min read
When a SQL Engine Records Column Types but Never Reads Them
megapixel99 profile

When a SQL Engine Records Column Types but Never Reads Them

#sql #database #node #javascript
Comments
3 min read
No More Rewriting the Same Logic for Every Database
esproc_spl profile
Judy

No More Rewriting the Same Logic for Every Database

#programming #devops #sql #sqlazy
5
Comments
4 min read
PostgreSQL Graph Queries with MATCH: 3 Practical Traversal Patterns
ineron profile
Eugene

PostgreSQL Graph Queries with MATCH: 3 Practical Traversal Patterns

#postgres #sql #backend #ai
Comments
2 min read
CVE-2026-24031 Analysis — Dovecot SQL-Based Authentication Bypass (an auth_username_chars Regression)
guidance_white profile

CVE-2026-24031 Analysis — Dovecot SQL-Based Authentication Bypass (an auth_username_chars Regression)

#database #vulnerabilities #cve #sql
1
Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.