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.
Highlights of RisingWave v1.4: The Open-Source Streaming Database

Highlights of RisingWave v1.4: The Open-Source Streaming Database

Comments
5 min read
Kubernetes(K8s) Autoscaler — a detailed look at the design and implementation of VPA

Kubernetes(K8s) Autoscaler — a detailed look at the design and implementation of VPA

Comments
7 min read
Enhancing Fraud Detection with Apache AGE: A Graph Database Approach

Enhancing Fraud Detection with Apache AGE: A Graph Database Approach

Comments
3 min read
On-Premise, Cloud e o Híbrido oque é ? qual e quando usar?

On-Premise, Cloud e o Híbrido oque é ? qual e quando usar?

Comments
4 min read
Choosing the Right Database for Your Application

Choosing the Right Database for Your Application

7
Comments 1
3 min read
How Vector Databases Work: A Hands-On Tutorial!

How Vector Databases Work: A Hands-On Tutorial!

8
Comments
9 min read
How to Shrink EBS Volumes

How to Shrink EBS Volumes

Comments
6 min read
Deep Dive Into the RisingWave Stream Processing Engine - Part 1: Overview

Deep Dive Into the RisingWave Stream Processing Engine - Part 1: Overview

Comments
6 min read
Materialized View to improve the performance of complex queries?

Materialized View to improve the performance of complex queries?

1
Comments
3 min read
History of Database

History of Database

Comments
5 min read
Indexes in MySQL – Notes

Indexes in MySQL – Notes

Comments
5 min read
Evaluating performance of time series collections

Evaluating performance of time series collections

1
Comments
12 min read
How We Optimized Dragonfly to Get 30x Throughput with BullMQ

How We Optimized Dragonfly to Get 30x Throughput with BullMQ

Comments
13 min read
Why do we NOLOCK in SQL server with an example

Why do we NOLOCK in SQL server with an example

1
Comments
1 min read
Why do we NOLOCK AND LOCK in SQL server with an example

Why do we NOLOCK AND LOCK in SQL server with an example

Comments
1 min read
How to create and configure a linked server in SQL Server Management Studio

How to create and configure a linked server in SQL Server Management Studio

Comments
2 min read
Inserting Data from One Table to Another in SQL using INSERT INTO using SELECT Statement

Inserting Data from One Table to Another in SQL using INSERT INTO using SELECT Statement

Comments
1 min read
Crafting Efficient MongoDB Queries

Crafting Efficient MongoDB Queries

1
Comments
10 min read
Leveraging Apache Age for Advanced Data Analytics

Leveraging Apache Age for Advanced Data Analytics

1
Comments
3 min read
Google FireStore Data Source Plugin for Grafana.

Google FireStore Data Source Plugin for Grafana.

Comments
1 min read
SQL Math Functions with Use Cases

SQL Math Functions with Use Cases

3
Comments 3
2 min read
Backup sem estresse: Como criar o dump do seu BD PostgreSQL no Docker de forma simples

Backup sem estresse: Como criar o dump do seu BD PostgreSQL no Docker de forma simples

1
Comments
2 min read
Partition Strategies: Fundamental Concepts for PostgreSQL Partitioning

Partition Strategies: Fundamental Concepts for PostgreSQL Partitioning

3
Comments
4 min read
TableSpace ;

TableSpace ;

Comments
5 min read
Modern Database Management Explained

Modern Database Management Explained

1
Comments
13 min read
It's not surprising that it's N times faster than ORACLE, such lightweight is the king

It's not surprising that it's N times faster than ORACLE, such lightweight is the king

2
Comments
7 min read
Three tips to reduce MongoDB database size

Three tips to reduce MongoDB database size

1
Comments
4 min read
Introdução aos Dados Geoespaciais no MongoDB

Introdução aos Dados Geoespaciais no MongoDB

Comments
3 min read
Understanding simple-pgvector-python: A Tool for Vector Search in Python

Understanding simple-pgvector-python: A Tool for Vector Search in Python

5
Comments
1 min read
A Solution for Retrieving Quiz URL IDs from Moodle's Database

A Solution for Retrieving Quiz URL IDs from Moodle's Database

Comments
2 min read
Unveiling the Robust Architecture of SQL Server A Comprehensive Overview

Unveiling the Robust Architecture of SQL Server A Comprehensive Overview

Comments
2 min read
How Metis Detects Too Many Open Connections on Postgres

How Metis Detects Too Many Open Connections on Postgres

Comments
3 min read
Dominando JOINs no SQL: Guia Completo

Dominando JOINs no SQL: Guia Completo

1
Comments
4 min read
DATA ENGINEERING ROADMAP FOR BEGINNERS.

DATA ENGINEERING ROADMAP FOR BEGINNERS.

Comments
8 min read
The Comprehensive Guide to Time Series Models: Navigating the Depths of Temporal Data

The Comprehensive Guide to Time Series Models: Navigating the Depths of Temporal Data

Comments
2 min read
O que são triggers?

O que são triggers?

1
Comments
2 min read
PostgreSQL. How to list the most IOPs-intensive queries?

PostgreSQL. How to list the most IOPs-intensive queries?

3
Comments
1 min read
PostgreSQL and NoSQL: Bridging the Gap with JSON and Hstore

PostgreSQL and NoSQL: Bridging the Gap with JSON and Hstore

Comments
3 min read
Unlocking the Power of Apache Age: Advanced Techniques for SQL/Cypher Hybrid Queries

Unlocking the Power of Apache Age: Advanced Techniques for SQL/Cypher Hybrid Queries

Comments
2 min read
Explicando ORM (Object Relational Mapping)

Explicando ORM (Object Relational Mapping)

2
Comments 3
2 min read
PostgreSQL: script to connect to DB, and get tables, their records number and size.

PostgreSQL: script to connect to DB, and get tables, their records number and size.

1
Comments 1
2 min read
Group By, Grouping Sets, Cube, and Rollup Queries in SQL

Group By, Grouping Sets, Cube, and Rollup Queries in SQL

Comments
5 min read
TypeORM - remove children with orphanedRowAction

TypeORM - remove children with orphanedRowAction

3
Comments
2 min read