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.
Your Search Query Is a Program: Composing Role-Based SQL With the Strategy Pattern
purbano profile

Your Search Query Is a Program: Composing Role-Based SQL With the Strategy Pattern

#java #springboot #sql #security
Comments 1
13 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
PostgreSQL Unique Constraint vs Unique Index: Which to Use, and How to Add One Without Locking the Table
tbson87 profile

PostgreSQL Unique Constraint vs Unique Index: Which to Use, and How to Add One Without Locking the Table

#postgres #database #sql #migrations
Comments
9 min read
Your Test Suite Is Slow Because It Tests Postgres
_66d02d0cc1ece7d1137c5f profile

Your Test Suite Is Slow Because It Tests Postgres

#testing #pytest #postgres #sql
Comments
3 min read
NL-to-SQL tools will happily DROP your table. Screen the output.
lixingliangsy profile

NL-to-SQL tools will happily DROP your table. Screen the output.

#sql #ai #database #programming
Comments
2 min read
Production SQLite in 2026: Running Laravel Without a Database Server
klytron profile

Production SQLite in 2026: Running Laravel Without a Database Server

#backend #database #laravel #sql
Comments
3 min read
Why Regex SQL Converters Break on Legacy Stored Procedures and How to Fix Them)
harulmozhi profile

Why Regex SQL Converters Break on Legacy Stored Procedures and How to Fix Them)

#database #sql #dataengineering #architecture
Comments
3 min read
Polymorphic Associations in PostgreSQL: One commentable_id Column or a Foreign Key per Table?
tbson87 profile

Polymorphic Associations in PostgreSQL: One commentable_id Column or a Foreign Key per Table?

#database #postgres #sql #rails
Comments
7 min read
Zero updated rows do not fail a D1 batch: testing the rollback boundary
hirodeath profile

Zero updated rows do not fail a D1 batch: testing the rollback boundary

#cloudflare #sql #database #javascript
1
Comments 2
4 min read
5 SQL patterns that run fine and still return the wrong answer
analyticsdurgesh profile

5 SQL patterns that run fine and still return the wrong answer

#career #dataengineering #sql #beginners
1
Comments
4 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
NOT IN can be executed as an Anti-Join (NOT EXISTS) in PG19
franckpachot profile

NOT IN can be executed as an Anti-Join (NOT EXISTS) in PG19

#postgres #sql #database #performance
Comments
7 min read
Apache Iceberg Query Optimization: Production Guide
jonisar profile

Apache Iceberg Query Optimization: Production Guide

#iceberg #dataengineering #snowflake #sql
Comments
40 min read
ersioning Business Semantics for Enterprise AI
arisyndata profile

ersioning Business Semantics for Enterprise AI

#ai #llm #data #sql
Comments
7 min read
Window functions vs Aggregate functions
mark_glemba_962f6bc8a12dd profile

Window functions vs Aggregate functions

#analytics #database #datascience #sql
Comments
9 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.