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.
The World Is Too Messy for SQL to Work
franckpachot profile

The World Is Too Messy for SQL to Work

#sql #database #relational #document
21
Comments 15
10 min read
Foreign Keys: A must in SQL, but not in a Document Database?
franckpachot profile

Foreign Keys: A must in SQL, but not in a Document Database?

#mongodb #sql #database #postgres
21
Comments
7 min read
Hacker rank's Median SQL Solution
meghanananju profile

Hacker rank's Median SQL Solution

#sql #hackerrank #tircky #programming
1
Comments
3 min read
DuckDB 🦆: Unleashing the Powerhouse Query Engine Within
mikekenneth77 profile

DuckDB 🦆: Unleashing the Powerhouse Query Engine Within

#duckdb #sql #database #performance
3
Comments
6 min read
Basic Relational Database Schemas 📚 to amplify development
aryan015 profile

Basic Relational Database Schemas 📚 to amplify development

#sql #dbms #mongodb #postgres
Comments
2 min read
Automating SQL Queries with LangChain and Gemini : A Step-by-Step Guide
exson_joseph profile

Automating SQL Queries with LangChain and Gemini : A Step-by-Step Guide

#sql #llm #gemini #langchain
5
Comments
4 min read
The Evolution of Databases: Relational vs. NoSQL
satyamlucifer profile

The Evolution of Databases: Relational vs. NoSQL

#database #sql #nosql #productivity
11
Comments
3 min read
7 Best SQL Books for Beginners
bobbyiliev profile

7 Best SQL Books for Beginners

#sql #database #postgres #books
11
Comments 2
3 min read
Postgres 🐘 vs. SQL Server: a Complete Comparison ⚖️ in 2025
op3ratordec profile

Postgres 🐘 vs. SQL Server: a Complete Comparison ⚖️ in 2025

#postgres #sqlserver #database #sql
6
Comments
7 min read
How to simplify nested SQL in applications with esProc
esproc_spl profile

How to simplify nested SQL in applications with esProc

#discuss #programming #devops #sql
11
Comments
4 min read
Practical SQL Injection Exploitation Cheat Sheet - @verylazytech
verylazytech profile

Practical SQL Injection Exploitation Cheat Sheet - @verylazytech

#programming #sql #cybersecurity #database
5
Comments
3 min read
Mastering System Analysis and Architecture: A Comprehensive Guide
thatohatsi880 profile

Mastering System Analysis and Architecture: A Comprehensive Guide

#database #sql #design #architecture
Comments
6 min read
How to Optimize SQL Queries for Speed and Efficiency
bikodes profile

How to Optimize SQL Queries for Speed and Efficiency

#sql #sqlserver #database #dataengineering
3
Comments 2
5 min read
Calculate the Number of Intersections between Adjacent Subsets after Grouping — From SQL to SPL #14
judith677 profile

Calculate the Number of Intersections between Adjacent Subsets after Grouping — From SQL to SPL #14

#database #sql #esprocspl #programming
5
Comments 1
2 min read
Optimising Database Performance Using Dapper
adrianbailador profile

Optimising Database Performance Using Dapper

#sql #programming #csharp #dotnet
11
Comments 1
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.