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.
SurrealDB: The "One-Size-Fits-All" Database for Lazy Developers (Part 1)

SurrealDB: The "One-Size-Fits-All" Database for Lazy Developers (Part 1)

1
Comments 1
2 min read
A Evolução do Modelo Relacional para Objeto-Relacional

A Evolução do Modelo Relacional para Objeto-Relacional

1
Comments
5 min read
Expanding the Dataset: A Comprehensive Guide to SQL Joins and Window Functions

Expanding the Dataset: A Comprehensive Guide to SQL Joins and Window Functions

1
Comments
3 min read
Joins and Windows Functions in SQL

Joins and Windows Functions in SQL

3
Comments
2 min read
A Pegadinha do Auto-Incremento: Como o SERIAL do PostgreSQL se compara a outros SGBDs

A Pegadinha do Auto-Incremento: Como o SERIAL do PostgreSQL se compara a outros SGBDs

1
Comments
3 min read
left join an effective satellite without duplicating rows (use a cte)

left join an effective satellite without duplicating rows (use a cte)

Comments
3 min read
Understanding Joins and Window Functions in SQL

Understanding Joins and Window Functions in SQL

2
Comments
5 min read
Refactoring the Nike Scraper: Replacing In-Memory Deduplication with SQLite

Refactoring the Nike Scraper: Replacing In-Memory Deduplication with SQLite

2
Comments
4 min read
Connecting Power BI to a SQL Database

Connecting Power BI to a SQL Database

5
Comments 1
5 min read
Clustered vs Non-Clustered Index in SQL(Complete Guide with Examples)

Clustered vs Non-Clustered Index in SQL(Complete Guide with Examples)

2
Comments
5 min read
pgvector Distance Functions: Cosine vs L2 vs Inner Product

pgvector Distance Functions: Cosine vs L2 vs Inner Product

1
Comments 1
3 min read
Text-to-SQL Finally Gets Real: DySQL-Bench, BibSQL, DLBench Fix the 'Perfect Query' Myth

Text-to-SQL Finally Gets Real: DySQL-Bench, BibSQL, DLBench Fix the 'Perfect Query' Myth

1
Comments
3 min read
Power BI DAX Pattern Library

Power BI DAX Pattern Library

Comments 1
3 min read
ajan-sql: Giving AI Safe, Read-Only SQL Access with MCP

ajan-sql: Giving AI Safe, Read-Only SQL Access with MCP

Comments
4 min read
# Understanding Joins and Window Functions in SQL

# Understanding Joins and Window Functions in SQL

2
Comments
7 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.