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.
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
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
SQL Database Projects and AI: A Match Made in Heaven
lovelacecoding profile

SQL Database Projects and AI: A Match Made in Heaven

#dotnet #sql #ai #beginners
1
Comments
8 min read
Window functions vs Aggregate functions
mark_glemba_962f6bc8a12dd profile

Window functions vs Aggregate functions

#analytics #database #datascience #sql
Comments
9 min read
Text-to-SQL in Practice: When to Trust AI Output and When to Gate It
databaseinsights profile

Text-to-SQL in Practice: When to Trust AI Output and When to Gate It

#sql #ai #database #devops
Comments 1
4 min read
Cursor Pagination vs Offset Pagination: Which One Should You Use?
omeiza_ahmed profile

Cursor Pagination vs Offset Pagination: Which One Should You Use?

#backend #database #performance #sql
Comments
3 min read
Same question, same database, two callers
ashish_sinha_5241c7673d93 profile

Same question, same database, two callers

#ai #database #llm #sql
1
Comments
2 min read
38% of an analyst's questions get "no records found" when the data is right there
ashish_sinha_5241c7673d93 profile

38% of an analyst's questions get "no records found" when the data is right there

#sql #ai #database #security
Comments
5 min read
Window Functions vs. Aggregate Functions in SQL (With Examples)
ericmwaimiri profile

Window Functions vs. Aggregate Functions in SQL (With Examples)

#database #programming #sql #tutorial
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.