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.
CAP | ACID Properties| BASE in Database System

CAP | ACID Properties| BASE in Database System

5
Comments
2 min read
Priority Queue! Vamos destrinchar e aprender sobre essa parte de Estrutura de Dados.

Priority Queue! Vamos destrinchar e aprender sobre essa parte de Estrutura de Dados.

3
Comments
6 min read
Unlocking speed: the power of indexing in database performance

Unlocking speed: the power of indexing in database performance

4
Comments
4 min read
Simulating Database Operations with PostgreSQL on Kubernetes

Simulating Database Operations with PostgreSQL on Kubernetes

Comments
3 min read
Mastering MongoDB Aggregation: A Journey from Fundamentals to Advanced Optimization

Mastering MongoDB Aggregation: A Journey from Fundamentals to Advanced Optimization

4
Comments
7 min read
Indexing for a Scalable Serialization Isolation Level

Indexing for a Scalable Serialization Isolation Level

4
Comments 2
5 min read
Optimizing Pagination in PostgreSQL: OFFSET/LIMIT vs. Keyset

Optimizing Pagination in PostgreSQL: OFFSET/LIMIT vs. Keyset

2
Comments 1
4 min read
COBOL Tutorial Series: Working with Database - Session 5

COBOL Tutorial Series: Working with Database - Session 5

11
Comments 1
4 min read
ACID in Databases: A Brief Overview

ACID in Databases: A Brief Overview

Comments
1 min read
B-tree: The Secret Recipe Behind Efficient Data Handling 🍰

B-tree: The Secret Recipe Behind Efficient Data Handling 🍰

16
Comments
4 min read
Introducing Free Java Utility Package

Introducing Free Java Utility Package

Comments
5 min read
How to Use Unique Key Constraints in Database Tables

How to Use Unique Key Constraints in Database Tables

Comments
2 min read
EF Core raw queries (C#)

EF Core raw queries (C#)

1
Comments
5 min read
😻🦾 Top 5 Text2SQL AI Tools in 2024 🤖🔁

😻🦾 Top 5 Text2SQL AI Tools in 2024 🤖🔁

41
Comments 3
2 min read
Installing Vertica on a Single-Node Kubernetes Cluster Using Minikube

Installing Vertica on a Single-Node Kubernetes Cluster Using Minikube

1
Comments
2 min read
The Doctor's On-Call Shift example and a Normalized Relational Schema to Avoid Write Skew

The Doctor's On-Call Shift example and a Normalized Relational Schema to Avoid Write Skew

3
Comments 3
7 min read
How to Install Vertica DB Client (vsql) on Ubuntu 24.04

How to Install Vertica DB Client (vsql) on Ubuntu 24.04

2
Comments
2 min read
DevOps. Monitoring Databases. On-Premise and Cloud environments.

DevOps. Monitoring Databases. On-Premise and Cloud environments.

Comments
1 min read
Unleashing the Data Science Frontier: The Critical Roles and Skills an Aspiring Data Scientist Should Master.

Unleashing the Data Science Frontier: The Critical Roles and Skills an Aspiring Data Scientist Should Master.

Comments
4 min read
Access IRIS database with ODBC or JDBC using Python

Access IRIS database with ODBC or JDBC using Python

1
Comments
5 min read
A Guide to dbt Macros - Purpose, Benefits, and Usage

A Guide to dbt Macros - Purpose, Benefits, and Usage

6
Comments
4 min read
How to Use Common Table Expressions (CTEs) to Avoid N+1 Queries in Hierarchical Data

How to Use Common Table Expressions (CTEs) to Avoid N+1 Queries in Hierarchical Data

1
Comments
5 min read
Key terms In data analytics

Key terms In data analytics

Comments
1 min read
How to connect and query multiple databases with a single REST API

How to connect and query multiple databases with a single REST API

1
Comments
3 min read
Choose the Best Database Management Tool for PostgreSQL in 2025

Choose the Best Database Management Tool for PostgreSQL in 2025

10
Comments 4
12 min read
loading...