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.
Less boilerplate than raw SQL, less magic than ORM: generating PostgreSQL queries from Go structs
juggle73 profile

Less boilerplate than raw SQL, less magic than ORM: generating PostgreSQL queries from Go structs

#go #postgres #sql #opensource
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
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
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
Scaling n8n with PostgreSQL and Redis on Upsun 🚀
florabrandao profile

Scaling n8n with PostgreSQL and Redis on Upsun 🚀

#sql
Comments
1 min read
SQL Server Heaps: Understanding Tables Without Clustered Indexes
namrata_khorjuwekar_ profile

SQL Server Heaps: Understanding Tables Without Clustered Indexes

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