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.
A Practical Guide to Caching: What to Cache and When

A Practical Guide to Caching: What to Cache and When

Comments
14 min read
Designing Database Tables for an Online Food Ordering Service

Designing Database Tables for an Online Food Ordering Service

37
Comments
2 min read
Explorando Funções de Agregação no SQL: SUM, MAX, MIN, AVG

Explorando Funções de Agregação no SQL: SUM, MAX, MIN, AVG

1
Comments
5 min read
API completa em Golang - Parte 7

API completa em Golang - Parte 7

63
Comments 5
22 min read
Mastering Table Relationships in Relational Databases: The Role of Primary and Foreign Keys

Mastering Table Relationships in Relational Databases: The Role of Primary and Foreign Keys

6
Comments
3 min read
UUID in PostgreSQL

UUID in PostgreSQL

71
Comments 7
5 min read
To UUID, or not to UUID, that is the primary key question

To UUID, or not to UUID, that is the primary key question

23
Comments
8 min read
PySpark & Apache Spark - Overview

PySpark & Apache Spark - Overview

Comments
3 min read
Elasticsearch: An Introduction To The Database And Heart Of The Elastic Stack

Elasticsearch: An Introduction To The Database And Heart Of The Elastic Stack

1
Comments 1
4 min read
Understanding and Optimizing Parallel Queries in PostgreSQL

Understanding and Optimizing Parallel Queries in PostgreSQL

Comments
2 min read
Database .NET Review

Database .NET Review

3
Comments
5 min read
Shift Left For DevOps: Enhancing Service Ownership in Databases

Shift Left For DevOps: Enhancing Service Ownership in Databases

Comments
8 min read
Understanding SQL: The Language of Relational Databases

Understanding SQL: The Language of Relational Databases

1
Comments
3 min read
FIRST_VALUE Function In SQL Server

FIRST_VALUE Function In SQL Server

5
Comments
2 min read
Normalização em Banco de Dados: Estruturando Dados com Eficiência e Integridade

Normalização em Banco de Dados: Estruturando Dados com Eficiência e Integridade

3
Comments
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.