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.
One Month Post Product Hunt Launch: An Honest Review of Azimutt.app launch

One Month Post Product Hunt Launch: An Honest Review of Azimutt.app launch

2
Comments
7 min read
Getting Started with the MATCH Clause in Apache Age

Getting Started with the MATCH Clause in Apache Age

2
Comments
2 min read
[Python] How to implement a transactional decorator in FastAPI + SQLAlchemy - with reviewing other approaches

[Python] How to implement a transactional decorator in FastAPI + SQLAlchemy - with reviewing other approaches

2
Comments
7 min read
Learn Why we call to use index with PostgreSQL

Learn Why we call to use index with PostgreSQL

12
Comments
3 min read
Don't miss out on the GREATEST and LEAST functions in SQL Server

Don't miss out on the GREATEST and LEAST functions in SQL Server

3
Comments 2
2 min read
Handling Duplicates in BigQuery

Handling Duplicates in BigQuery

Comments
3 min read
A NoSQL embedded database for you Rust app

A NoSQL embedded database for you Rust app

Comments
3 min read
Oracle MERGE to UPDATE SQL

Oracle MERGE to UPDATE SQL

Comments
3 min read
Solving the Top 5 DBT Problems with Edge Cases: Streamlining Data Build Processes

Solving the Top 5 DBT Problems with Edge Cases: Streamlining Data Build Processes

1
Comments
3 min read
How to Find Bottlenecks in MongoDB: Profiling and Load Testing Strategies with JMeter

How to Find Bottlenecks in MongoDB: Profiling and Load Testing Strategies with JMeter

Comments
7 min read
1757. LeetCode's Recyclable and Low-Fat Products Solution - Simple & Logical SQL Command

1757. LeetCode's Recyclable and Low-Fat Products Solution - Simple & Logical SQL Command

1
Comments
1 min read
Predicate functions and user defined functions in Apache age

Predicate functions and user defined functions in Apache age

Comments
1 min read
Understanding the REMOVE Clause in Apache AGE

Understanding the REMOVE Clause in Apache AGE

3
Comments
2 min read
How to Run Queries 2600 Times Faster

How to Run Queries 2600 Times Faster

Comments
3 min read
Indexes in PostgreSQL

Indexes in PostgreSQL

1
Comments
2 min read
Compensation Transaction Patterns - The Key to Handling Failures in Distributed Applications

Compensation Transaction Patterns - The Key to Handling Failures in Distributed Applications

Comments
6 min read
Building a Data Warehouse for Traditional Industry: Hadoop is Overkill

Building a Data Warehouse for Traditional Industry: Hadoop is Overkill

Comments
6 min read
Database Design: "How to Create a Robust and Scalable Data Model"

Database Design: "How to Create a Robust and Scalable Data Model"

2
Comments
3 min read
Open-source SPL Eliminates Tens of Thousands of Intermediate Tables from Databases

Open-source SPL Eliminates Tens of Thousands of Intermediate Tables from Databases

Comments
8 min read
Understanding database indices by (poorly) implementing one

Understanding database indices by (poorly) implementing one

Comments
12 min read
A unique database for every PR using CodeSandbox

A unique database for every PR using CodeSandbox

18
Comments 1
4 min read
Building a Robust Data Lake with Python and DuckDB

Building a Robust Data Lake with Python and DuckDB

1
Comments
4 min read
Tutorial part-5: key-value store - TTL options

Tutorial part-5: key-value store - TTL options

2
Comments
2 min read
build dynamic query predicate in Linq

build dynamic query predicate in Linq

1
Comments
2 min read
The 8 considerations for designing public data APIs

The 8 considerations for designing public data APIs

Comments
10 min read
Dockerize an Express app and MongoDB

Dockerize an Express app and MongoDB

Comments
8 min read
Parallel Scan in YugabyteDB (ysql_select_parallelism=-1)

Parallel Scan in YugabyteDB (ysql_select_parallelism=-1)

Comments
3 min read
Data Import and Export: Techniques for Streamlining Data Transfer

Data Import and Export: Techniques for Streamlining Data Transfer

2
Comments
2 min read
Scalar functions in Apache age

Scalar functions in Apache age

Comments
1 min read
Erdős–Rényi Graph Model With Apache AGE

Erdős–Rényi Graph Model With Apache AGE

1
Comments
3 min read
Prepopulate Room with data.

Prepopulate Room with data.

Comments
3 min read
Realm 7, the frozen throne

Realm 7, the frozen throne

Comments
4 min read
Deploying an App Service in Azure and Connecting to SQL Database

Deploying an App Service in Azure and Connecting to SQL Database

2
Comments
3 min read
HTAP: Learning from Xiaohongshu

HTAP: Learning from Xiaohongshu

Comments
5 min read
Introduction to Age Viewer: A Web-Based Visualization Tool for Apache Age

Introduction to Age Viewer: A Web-Based Visualization Tool for Apache Age

2
Comments
3 min read
PostgreSQL on OpenBSD: 12 から 13 へのアップグレード - pg_dumpall 使用

PostgreSQL on OpenBSD: 12 から 13 へのアップグレード - pg_dumpall 使用

1
Comments
2 min read
The Trade-offs Between Database Normalization and Denormalization

The Trade-offs Between Database Normalization and Denormalization

8
Comments 1
4 min read