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 programmatically backup your Firestore database with simple steps

How to programmatically backup your Firestore database with simple steps

5
Comments
2 min read
JOINS IN SQL

JOINS IN SQL

2
Comments
2 min read
Replacing Planetscale

Replacing Planetscale

Comments
8 min read
Multiple operations in a single DynamoDB update expression

Multiple operations in a single DynamoDB update expression

Comments
3 min read
How to Back Up and Restore Azure SQL Databases

How to Back Up and Restore Azure SQL Databases

1
Comments
8 min read
How to calculate the distance between Kyoto and Tokyo using a PostgreSQL database?

How to calculate the distance between Kyoto and Tokyo using a PostgreSQL database?

3
Comments 1
2 min read
Optimizing SQL Performance: Best Practices for Efficient Database Operations

Optimizing SQL Performance: Best Practices for Efficient Database Operations

Comments
3 min read
A smaller YugabyteDB image for CI/CD (example with Sakila)

A smaller YugabyteDB image for CI/CD (example with Sakila)

2
Comments
3 min read
Ultra High-Performance Database OpenM(ysq)LDB: Seamless Compatibility with MySQL Protocol and Multi-Language MySQL Client

Ultra High-Performance Database OpenM(ysq)LDB: Seamless Compatibility with MySQL Protocol and Multi-Language MySQL Client

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

About transaction identifier (transaction_id) in PostgreSQL.

8
Comments
2 min read
Platform Engineers Must Change Developers and Databases - And Here Is How

Platform Engineers Must Change Developers and Databases - And Here Is How

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

Statistical information about tables in a PostgreSQL Database.

3
Comments
2 min read
Understanding of NULL in PostgreSQL database.

Understanding of NULL in PostgreSQL database.

3
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.

3
Comments
2 min read
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?

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

How to join tables in PostgreSQL using the WITH clause?

1
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?

2
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?

1
Comments
2 min read
Caching in depth

Caching in depth

3
Comments
7 min read
Mastering Relational Database Design: A Comprehensive Guide

Mastering Relational Database Design: A Comprehensive Guide

716
Comments 49
20 min read
Calculate the Total Price According to the Cumulative Price Table

Calculate the Total Price According to the Cumulative Price Table

11
Comments 3
1 min read
Custom SQL Scripts in PostgreSQL PgBench

Custom SQL Scripts in PostgreSQL PgBench

8
Comments
6 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
Serverless Postgres with Neon - My first impression

Serverless Postgres with Neon - My first impression

6
Comments
8 min read
OracleBootCamp - 4 May 2024

OracleBootCamp - 4 May 2024

Comments 1
1 min read
Levantando um SQL Server RDS em AWS

Levantando um SQL Server RDS em AWS

1
Comments
4 min read
Configure Amazon RDS Proxy

Configure Amazon RDS Proxy

1
Comments
3 min read
Relational Databases on AWS: Comparing RDS and Aurora

Relational Databases on AWS: Comparing RDS and Aurora

11
Comments
8 min read
Difference between WHERE vs HAVING Clause in SQL

Difference between WHERE vs HAVING Clause in SQL

46
Comments 1
3 min read
Local-first for FlutterFlow

Local-first for FlutterFlow

Comments 2
1 min read
Deploy MongoDB on Kubernetes with ArgoCD and Helm charts

Deploy MongoDB on Kubernetes with ArgoCD and Helm charts

7
Comments
5 min read
Elevate Your Laravel Eloquent Queries with Tappable Scopes

Elevate Your Laravel Eloquent Queries with Tappable Scopes

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

Beyond Code Generation: Crafting Custom Hive Adapters

2
Comments
6 min read
What's coming to PostgreSQL ? 🐘

What's coming to PostgreSQL ? 🐘

74
Comments 6
5 min read
Modern Data Quality: Navigating the Landscape

Modern Data Quality: Navigating the Landscape

Comments
4 min read
Setting up a Database Driver, Repository and Implementation of a transaction function for your Go App

Setting up a Database Driver, Repository and Implementation of a transaction function for your Go App

4
Comments 2
13 min read
Introducing Text to Reports - A new way to visualize your data using Flowtrail AI.

Introducing Text to Reports - A new way to visualize your data using Flowtrail AI.

4
Comments
3 min read
Double bind the foreign key to avoid unnecessary JOIN in TypeORM

Double bind the foreign key to avoid unnecessary JOIN in TypeORM

Comments
3 min read
Say Goodbye to ElasticSearch: Discover MongoDB's Powerful Search Capabilities

Say Goodbye to ElasticSearch: Discover MongoDB's Powerful Search Capabilities

Comments
4 min read
Simulate Clock Skew in Docker Container

Simulate Clock Skew in Docker Container

2
Comments
2 min read
Getting Started With Database Views in SQL

Getting Started With Database Views in SQL

Comments
4 min read
Meet Datomic: the immutable and functional database.

Meet Datomic: the immutable and functional database.

88
Comments 11
9 min read
OCI - Database Cloud Metrics - #1 Basic Management Metrics

OCI - Database Cloud Metrics - #1 Basic Management Metrics

Comments
2 min read
What is MySQL Throughput?

What is MySQL Throughput?

Comments
3 min read
What I learned from managing hundred millions of data in MongoDB

What I learned from managing hundred millions of data in MongoDB

5
Comments 1
2 min read
How to Transpose Columns in Each Group to a Single Row

How to Transpose Columns in Each Group to a Single Row

7
Comments
2 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

11
Comments 1
2 min read
Get started with Prisma ORM and Xata's Postgres service

Get started with Prisma ORM and Xata's Postgres service

3
Comments
5 min read
This is How You Build AI Apps Using the RAG Framework in 5 Minutes!

This is How You Build AI Apps Using the RAG Framework in 5 Minutes!

19
Comments 1
6 min read
Integrating Georeferenced Maps: Passing Data from Firebase Backend to Frontend

Integrating Georeferenced Maps: Passing Data from Firebase Backend to Frontend

Comments
1 min read
Importance of Cyber Security in Business Continuity

Importance of Cyber Security in Business Continuity

Comments
3 min read
Collection of Hands-on Exercises to Get Started with Apache Iceberg

Collection of Hands-on Exercises to Get Started with Apache Iceberg

6
Comments
4 min read
Iniciando no Elasticsearch: Conceitos básicos

Iniciando no Elasticsearch: Conceitos básicos

8
Comments
6 min read
OCI - Restore DB System Backups across OCI Cloud regions is now available.

OCI - Restore DB System Backups across OCI Cloud regions is now available.

Comments
1 min read
Boom 💥, Supabase Marks Its GA Milestone

Boom 💥, Supabase Marks Its GA Milestone

11
Comments 2
3 min read
SQL Pro Tips : industrial GCP BigQuery SQL using WITH

SQL Pro Tips : industrial GCP BigQuery SQL using WITH

3
Comments
5 min read
SQL Pro Tips : industrial AWS Athena SQL using WITH

SQL Pro Tips : industrial AWS Athena SQL using WITH

3
Comments
4 min read
All MongoDB commands you need to know

All MongoDB commands you need to know

89
Comments 31
4 min read
Oracle Database - Identifying Session Tracefiles - without actually tracing them :-)

Oracle Database - Identifying Session Tracefiles - without actually tracing them :-)

4
Comments
5 min read
loading...