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.
UUID Best Practices: v4, v7, and When You Should Use Each

UUID Best Practices: v4, v7, and When You Should Use Each

Comments
3 min read
💡 MySQL INNER JOIN vs LEFT JOIN — which one should you actually use?

💡 MySQL INNER JOIN vs LEFT JOIN — which one should you actually use?

Comments 1
7 min read
Tracking Long Transactions in GBase 8s with onstat

Tracking Long Transactions in GBase 8s with onstat

2
Comments
2 min read
Minigraf 1.0: An Embedded Bi-Temporal Datalog Database in Rust

Minigraf 1.0: An Embedded Bi-Temporal Datalog Database in Rust

2
Comments
3 min read
GBase 8s Collection Attributes: count, limit, exist, first, last, next, prior

GBase 8s Collection Attributes: count, limit, exist, first, last, next, prior

2
Comments
2 min read
Merging PSM Backups Across GBase 8s Nodes for Continuous onbar Recovery

Merging PSM Backups Across GBase 8s Nodes for Continuous onbar Recovery

2
Comments
2 min read
Performance and Apache Iceberg's Metadata

Performance and Apache Iceberg's Metadata

Comments
7 min read
Stop Using Subqueries: 3 Advanced SQL CTE Patterns That Saved My Production Database

Stop Using Subqueries: 3 Advanced SQL CTE Patterns That Saved My Production Database

Comments 1
3 min read
DataPop: Generate Realistic Synthetic Datasets in Python

DataPop: Generate Realistic Synthetic Datasets in Python

Comments
2 min read
DuckDB 1.5.1, MacBook Benchmarks, & Browser-based Postgres Workspace

DuckDB 1.5.1, MacBook Benchmarks, & Browser-based Postgres Workspace

Comments
3 min read
Four Ways to Use AI With Your Database in VS Code

Four Ways to Use AI With Your Database in VS Code

Comments 1
2 min read
I Built a Tiny Database in Go to Understand How Real Ones Work

I Built a Tiny Database in Go to Understand How Real Ones Work

1
Comments
6 min read
GBase 8s User Management: Mapping OS Users and Internal Users

GBase 8s User Management: Mapping OS Users and Internal Users

2
Comments
2 min read
PostgreSQL WHERE Clause Optimization

PostgreSQL WHERE Clause Optimization

Comments
9 min read
GBase 8a Data Distribution Strategies: Hash, Random, and Replicated Tables

GBase 8a Data Distribution Strategies: Hash, Random, and Replicated Tables

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