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.
How to find the third and fifth-highest values in a PostgreSQL table?

How to find the third and fifth-highest values in a PostgreSQL table?

Comments
2 min read
About transaction identifier (transaction_id) in PostgreSQL.

About transaction identifier (transaction_id) in PostgreSQL.

Comments
2 min read
PostgreSQL. How to check connections that are not using SSL encryption?

PostgreSQL. How to check connections that are not using SSL encryption?

Comments
2 min read
Statistical information about tables in a PostgreSQL Database.

Statistical information about tables in a PostgreSQL Database.

Comments
2 min read
How to check if the PostgreSQL tables of the same structure have identical data using aggregated hash and md5?

How to check if the PostgreSQL tables of the same structure have identical data using aggregated hash and md5?

Comments
2 min read
Weekly Updates - Apr 26, 2024

Weekly Updates - Apr 26, 2024

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

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

Comments
1 min read
How to join tables in PostgreSQL using the WITH clause?

How to join tables in PostgreSQL using the WITH clause?

Comments
2 min read
Caching in depth

Caching in depth

Comments
7 min read
Unlocking the Power of Databases in Java with JDBC

Unlocking the Power of Databases in Java with JDBC

Comments
2 min read
The Untold Truth: Data Quality Issues in Your Data Warehouse Nobody Will Tell You About

The Untold Truth: Data Quality Issues in Your Data Warehouse Nobody Will Tell You About

Comments
4 min read
How to schedule RDS instances (start/stop) easily

How to schedule RDS instances (start/stop) easily

3
Comments
6 min read
Seeking Insights from Application Developers

Seeking Insights from Application Developers

Comments
1 min read
Levantando um SQL Server RDS em AWS

Levantando um SQL Server RDS em AWS

Comments
4 min read
My AWS Resume Challenge and the troubles I faced.

My AWS Resume Challenge and the troubles I faced.

Comments
2 min read
Understanding of NULL in PostgreSQL database.

Understanding of NULL in PostgreSQL database.

2
Comments
2 min read
PostgreSQL: Deleting all records from a table, except for the first and last ones.

PostgreSQL: Deleting all records from a table, except for the first and last ones.

1
Comments
2 min read
Beyond Code Generation: Crafting Custom Hive Adapters

Beyond Code Generation: Crafting Custom Hive Adapters

Comments
6 min read
Modern Data Quality: Navigating the Landscape

Modern Data Quality: Navigating the Landscape

Comments
4 min read
CAP Theorem

CAP Theorem

1
Comments
2 min read
NoSQL DATABASES

NoSQL DATABASES

1
Comments
1 min read
Simulate Clock Skew in Docker Container

Simulate Clock Skew in Docker Container

1
Comments
2 min read
Calculate the Total Price According to the Cumulative Price Table

Calculate the Total Price According to the Cumulative Price Table

6
Comments 3
1 min read
Getting Started With Database Views in SQL

Getting Started With Database Views in SQL

Comments
4 min read
Embracing Open Source: A Catalyst for Scientific Progress

Embracing Open Source: A Catalyst for Scientific Progress

Comments
2 min read
INTRO : Apache Cassandra

INTRO : Apache Cassandra

Comments
2 min read
All Your Monitoring Solutions Are Just Wrong

All Your Monitoring Solutions Are Just Wrong

Comments
8 min read
Distributed Databases

Distributed Databases

Comments
1 min read
Running schema/database migrations using Geni

Running schema/database migrations using Geni

2
Comments
4 min read
Introducing usage monitoring in Xata

Introducing usage monitoring in Xata

Comments
5 min read
Discover the Latest in ApsaraDB for MongoDB 7.0 and How It Can Benefit Your Business

Discover the Latest in ApsaraDB for MongoDB 7.0 and How It Can Benefit Your Business

Comments
4 min read
How to Transpose Rows to Columns on Multiple Fields in Each Group

How to Transpose Rows to Columns on Multiple Fields in Each Group

5
Comments 1
2 min read
Understanding Database Normalization: A Comprehensive Guide

Understanding Database Normalization: A Comprehensive Guide

Comments
4 min read
Criar massa de dados para teste

Criar massa de dados para teste

Comments
1 min read
Inside DuckDB: Deep Dive into DuckDB MetaPipeline

Inside DuckDB: Deep Dive into DuckDB MetaPipeline

Comments
1 min read
Xata Dedicated Clusters for PostgreSQL

Xata Dedicated Clusters for PostgreSQL

Comments
8 min read
Custom SQL Scripts in PostgreSQL PgBench

Custom SQL Scripts in PostgreSQL PgBench

2
Comments
6 min read
Database Education Needs Moderization

Database Education Needs Moderization

Comments
1 min read
How to Calculate Median on Values That Have Corresponding Quantities

How to Calculate Median on Values That Have Corresponding Quantities

5
Comments
2 min read
Data Warehouse, Data Mart e Data Lake: Uma Visão Abrangente

Data Warehouse, Data Mart e Data Lake: Uma Visão Abrangente

Comments
3 min read
Move Fast and “Branch” Things

Move Fast and “Branch” Things

1
Comments
8 min read
Serverless Postgres with Neon - My first impression

Serverless Postgres with Neon - My first impression

5
Comments
8 min read
OracleBootCamp - 5 May 2024

OracleBootCamp - 5 May 2024

Comments
1 min read
Unveiling the Power of Database-Side Rendering: Elevating Web Development Standards

Unveiling the Power of Database-Side Rendering: Elevating Web Development Standards

Comments
2 min read
Local-first for FlutterFlow

Local-first for FlutterFlow

Comments 2
1 min read
Migrating MySQL database to SQL Server Using Radzen Blazor Studio.

Migrating MySQL database to SQL Server Using Radzen Blazor Studio.

Comments
2 min read
Introducing pgzx: create PostgreSQL extensions using Zig

Introducing pgzx: create PostgreSQL extensions using Zig

Comments
10 min read
What happens when you type https://www.google.com in your browser and press Enter?

What happens when you type https://www.google.com in your browser and press Enter?

Comments
4 min read
How To Create a Linux Virtual Machine in Microsoft Azure - Password Authentication

How To Create a Linux Virtual Machine in Microsoft Azure - Password Authentication

Comments
5 min read
ReductStore CLI Client now in Rust

ReductStore CLI Client now in Rust

1
Comments
2 min read
MongoDB Shell Commands - A Comprehensive Guide

MongoDB Shell Commands - A Comprehensive Guide

Comments
2 min read
MongoDB vs Redis: A Comprehensive Comparison

MongoDB vs Redis: A Comprehensive Comparison

2
Comments 2
5 min read
Time Series Blob Data: ReductStore vs. MongoDB

Time Series Blob Data: ReductStore vs. MongoDB

1
Comments
7 min read
AWS Read Replica vs Multi-AZ

AWS Read Replica vs Multi-AZ

Comments
3 min read
Making FoodIntake, Part I

Making FoodIntake, Part I

Comments
3 min read
How to check the distribution of timestamps in a PostgreSQL table?

How to check the distribution of timestamps in a PostgreSQL table?

Comments
3 min read
PostgreSQL. How do you find potentially ineffective indexes?

PostgreSQL. How do you find potentially ineffective indexes?

Comments
2 min read
How do you check the top IOPs intensive queries in PostgreSQL DB?

How do you check the top IOPs intensive queries in PostgreSQL DB?

Comments
2 min read
🪄 DuckDB sql hack : get things SORTED w/ constraint CHECK

🪄 DuckDB sql hack : get things SORTED w/ constraint CHECK

Comments 2
3 min read
How to assign the foreign key in the existing table.

How to assign the foreign key in the existing table.

Comments
2 min read
loading...