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.
Kysely Has a Free Type-Safe SQL Query Builder With Zero Magic

Kysely Has a Free Type-Safe SQL Query Builder With Zero Magic

Comments
2 min read
Getting Started with Seal Report: Applying Dependant Filters

Getting Started with Seal Report: Applying Dependant Filters

Comments
3 min read
Atomicity

Atomicity

Comments
1 min read
Understanding Data Modeling in Power BI: Joins, Relationships, and Schemas

Understanding Data Modeling in Power BI: Joins, Relationships, and Schemas

1
Comments
2 min read
ORMs Are a Lie We Tell Junior Developers So They Don't Have to Learn SQL

ORMs Are a Lie We Tell Junior Developers So They Don't Have to Learn SQL

1
Comments
4 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
DuckDB Has a Free API: The SQLite for Analytics

DuckDB Has a Free API: The SQLite for Analytics

Comments
2 min read
Hi I'm Ruddy

Hi I'm Ruddy

Comments
2 min read
Meet Your New AI-Powered Senior DBA: Bridging the Gap Between Metadata and Architectural Excellence

Meet Your New AI-Powered Senior DBA: Bridging the Gap Between Metadata and Architectural Excellence

Comments
2 min read
Diagramas de banco sempre ficam desatualizados. Parei de tentar “manter” e passei a gerar.

Diagramas de banco sempre ficam desatualizados. Parei de tentar “manter” e passei a gerar.

Comments
1 min read
🚨 Why Your SQL Window Functions Betray You in Cloud SSMS vs Snowflake

🚨 Why Your SQL Window Functions Betray You in Cloud SSMS vs Snowflake

Comments
2 min read
Building an AI-Powered Natural Language SQL Interface: An MVP Journey

Building an AI-Powered Natural Language SQL Interface: An MVP Journey

Comments
6 min read
PostgreSQL 18: A Paradigm Shift for Modern Data Workloads

PostgreSQL 18: A Paradigm Shift for Modern Data Workloads

Comments
5 min read
SQL Interviews in the Age of LLMs: Patterns Over Queries

SQL Interviews in the Age of LLMs: Patterns Over Queries

10
Comments 3
25 min read
Users, Roles, Groups

Users, Roles, Groups

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