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.
PostgreSQL Ecosystem: New Extensions, Graph Queries, & Performance Insights
soytuber profile
soy

PostgreSQL Ecosystem: New Extensions, Graph Queries, & Performance Insights

#database #sql #sqlite
Comments
3 min read
SQL Injection Basics: My First Experience Testing SQLi in Real Applications
suraj_magar_9fb0201f4bdba profile

SQL Injection Basics: My First Experience Testing SQLi in Real Applications

#beginners #cybersecurity #security #sql
Comments
3 min read
PostgreSQL Connection Pooling Explained: How It Works and Why It Matters
sharafathalivk profile

PostgreSQL Connection Pooling Explained: How It Works and Why It Matters

#webdev #postgres #database #sql
Comments
15 min read
T-SQL on Microsoft Fabric - Episode 2: Grouping and Summarizing Data with GROUP BY and Aggregate Functions
lamkhac profile

T-SQL on Microsoft Fabric - Episode 2: Grouping and Summarizing Data with GROUP BY and Aggregate Functions

#dataengineering #fabric #microsoft #sql
Comments
3 min read
SQL for Developers: The Practical Guide (2026)
armorbreak profile

SQL for Developers: The Practical Guide (2026)

#beginners #database #sql #tutorial
Comments
5 min read
Your LLM fused the two columns you asked for — and the eval marked it wrong
omer_hochman profile

Your LLM fused the two columns you asked for — and the eval marked it wrong

#sql #llm #ai
Comments
3 min read
# Modernizing the Pitch: Building an Automated SQL Data Quality and Transformation Pipeline for Multi-Club Scouting Platforms
ishak_ahmed_1ea86b2efd2b9 profile

# Modernizing the Pitch: Building an Automated SQL Data Quality and Transformation Pipeline for Multi-Club Scouting Platforms

#automation #data #dataengineering #sql
Comments
5 min read
Clustered Indexes in SQL Server: How Data is Stored for Faster Queries
namrata_khorjuwekar_ profile

Clustered Indexes in SQL Server: How Data is Stored for Faster Queries

#sql #database #performance #backend
Comments
4 min read
AI-Assisted SQL Development with Claude Code — Rules, Skills and Agents That Enforce Conventions
marcus1968 profile
Marcus

AI-Assisted SQL Development with Claude Code — Rules, Skills and Agents That Enforce Conventions

#ai #claude #sql #database
Comments
7 min read
As 12 Regras de Codd: o que torna um banco de dados realmente relacional?
carlos-delfino profile

As 12 Regras de Codd: o que torna um banco de dados realmente relacional?

#sgbd #sql #sqlserver #mariadb
1
Comments
7 min read
LLM SQL Guard Architecture: Parser, Catalog, Policy Engine, Audit Log
_706015150500ca0399b12 profile

LLM SQL Guard Architecture: Parser, Catalog, Policy Engine, Audit Log

#architecture #llm #security #sql
Comments
1 min read
Fuzzy Text Search in PostgreSQL: How Trigrams Make Computers "Almost Right"
dhananjayharidas profile

Fuzzy Text Search in PostgreSQL: How Trigrams Make Computers "Almost Right"

#algorithms #database #postgres #sql
Comments
9 min read
Understanding the Key Differences Between SQL and NoSQL Databases
jefersoneiji profile

Understanding the Key Differences Between SQL and NoSQL Databases

#sql #nosql #database #comparison
Comments
1 min read
PostgreSQL 20000 Error: Causes and Solutions Complete Guide
dbmserror profile

PostgreSQL 20000 Error: Causes and Solutions Complete Guide

#postgres #database #dba #sql
Comments
3 min read
Oracle ORA-00215 Error: Causes and Solutions Complete Guide
dbmserror profile

Oracle ORA-00215 Error: Causes and Solutions Complete Guide

#oracle #database #dba #sql
Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.