DEV Community

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
From Statistical Evidence to Executable Data Graphs

From Statistical Evidence to Executable Data Graphs

1
Comments
1 min read
SQL JOINS AND WINDOW FUNCTIONS WITH CASE EXAMPLE

SQL JOINS AND WINDOW FUNCTIONS WITH CASE EXAMPLE

Comments
6 min read
IVFFlat vs HNSW in pgvector: Which Index Should You Use?

IVFFlat vs HNSW in pgvector: Which Index Should You Use?

1
Comments
4 min read
Construir Aplicaciones RAG Listas para Producción con Bases de Datos Vectoriales

Construir Aplicaciones RAG Listas para Producción con Bases de Datos Vectoriales

Comments
2 min read
How SQLite Converts Data: Affinity Rules in Action

How SQLite Converts Data: Affinity Rules in Action

18
Comments
4 min read
Why I Switched from Firebase to Supabase + PostgreSQL (And Cut My Costs 80%)

Why I Switched from Firebase to Supabase + PostgreSQL (And Cut My Costs 80%)

2
Comments
5 min read
The Complete Guide to UUID: Versions, Differences, and When to Use Each One

The Complete Guide to UUID: Versions, Differences, and When to Use Each One

Comments
2 min read
ER Diagram

ER Diagram

3
Comments
9 min read
Index Key Format in SQLite

Index Key Format in SQLite

12
Comments
4 min read
Choosing the Right chunk_time_interval for Your Workload

Choosing the Right chunk_time_interval for Your Workload

1
Comments
4 min read
Execution Strategy στο Entity Framework Core

Execution Strategy στο Entity Framework Core

1
Comments
2 min read
SQL JOINS AND WINDOW FUNCTIONS

SQL JOINS AND WINDOW FUNCTIONS

1
Comments
2 min read
Optimizing Continuous Aggregate Performance for Large Datasets

Optimizing Continuous Aggregate Performance for Large Datasets

Comments
4 min read
How to Monitor PostgreSQL metrics with OpenTelemetry

How to Monitor PostgreSQL metrics with OpenTelemetry

Comments
13 min read
Challenges and Solutions in Developing a Stable, User-Friendly, Open-Source Cross-Platform Database Client

Challenges and Solutions in Developing a Stable, User-Friendly, Open-Source Cross-Platform Database Client

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