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.
INTRODUCTION TO SQL

INTRODUCTION TO SQL

1
Comments 2
4 min read
Tracking Personal Finances with SQL: Learn As You Manage Your Money!

Tracking Personal Finances with SQL: Learn As You Manage Your Money!

9
Comments
2 min read
SQL | DDL, DQL, DML, DCL and TCL Commands

SQL | DDL, DQL, DML, DCL and TCL Commands

6
Comments
2 min read
Using AI on top of your DB

Using AI on top of your DB

Comments 1
1 min read
Asgard saviour: Neurelo

Asgard saviour: Neurelo

2
Comments
3 min read
How to connect to Oracle, MySql and PostgreSQL databases using Python?

How to connect to Oracle, MySql and PostgreSQL databases using Python?

3
Comments
2 min read
Modern Data Quality (MDQ): Everything You Need to Know

Modern Data Quality (MDQ): Everything You Need to Know

Comments
5 min read
Optimizing Firebase Updates: Batch Multiple Paths in a Single Commit

Optimizing Firebase Updates: Batch Multiple Paths in a Single Commit

1
Comments
2 min read
Laravel Log DB Queries

Laravel Log DB Queries

9
Comments 2
1 min read
SQL DATA MANIPULATION

SQL DATA MANIPULATION

2
Comments
3 min read
How to efficiently migrate and manage database schema changes in a Laravel application?

How to efficiently migrate and manage database schema changes in a Laravel application?

Comments 1
3 min read
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.

9
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
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 join tables in PostgreSQL using the WITH clause?

How to join tables in PostgreSQL using the WITH clause?

1
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

726
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
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 ? 🐘

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

89
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
loading...