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

70
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

21
Comments
8 min read
PySpark & Apache Spark - Overview

PySpark & Apache Spark - Overview

Comments
3 min read
Understanding and Optimizing Parallel Queries in PostgreSQL

Understanding and Optimizing Parallel Queries in PostgreSQL

Comments
2 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
Database .NET Review

Database .NET Review

3
Comments
5 min read
SQL Notebook I Wish I Had Crafted Sooner in My Coding Path

SQL Notebook I Wish I Had Crafted Sooner in My Coding Path

1
Comments
1 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
Out of Range statistics with PostgreSQL & YugabyteDB

Out of Range statistics with PostgreSQL & YugabyteDB

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