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.
Sharding in Databases: How Queries Identify the Right Shard

Sharding in Databases: How Queries Identify the Right Shard

1
Comments
3 min read
A Polished, Read‑Only Cloudflare D1 Explorer (Express + Vanilla JS)

A Polished, Read‑Only Cloudflare D1 Explorer (Express + Vanilla JS)

Comments 1
2 min read
Unraveling the Hidden Web of Your SQL Server Database

Unraveling the Hidden Web of Your SQL Server Database

Comments
5 min read
How to Migrate Your On-Premise Database to Google Cloud SQL? A Detailed Guide

How to Migrate Your On-Premise Database to Google Cloud SQL? A Detailed Guide

6
Comments
5 min read
OLAP vs OLTP — What Every Beginner Should Know

OLAP vs OLTP — What Every Beginner Should Know

Comments
1 min read
Automating Old Partition Cleanup in Oracle with PL/SQL

Automating Old Partition Cleanup in Oracle with PL/SQL

6
Comments
3 min read
Handle Large PostgreSQL Schemas with a GUI Tool

Handle Large PostgreSQL Schemas with a GUI Tool

6
Comments
3 min read
Understanding Variables and Data Types for Beginners

Understanding Variables and Data Types for Beginners

5
Comments
2 min read
Atomicity Consistency Isolation Durability = ACID

Atomicity Consistency Isolation Durability = ACID

Comments
1 min read
Audit Trigger for Tracking User Updates and Deletions in table

Audit Trigger for Tracking User Updates and Deletions in table

5
Comments
3 min read
Filtering and Retrieving in SQL

Filtering and Retrieving in SQL

1
Comments 2
3 min read
Real-Time CDC with Debezium and Kafka for Sharded PostgreSQL Integration

Real-Time CDC with Debezium and Kafka for Sharded PostgreSQL Integration

1
Comments
9 min read
Eliminating Lost Update Anomalies in Spring Boot with Redlock and Custom AOP

Eliminating Lost Update Anomalies in Spring Boot with Redlock and Custom AOP

1
Comments
3 min read
When a node crashes, how does it catch up with the cluster? That’s where Raft shines.

When a node crashes, how does it catch up with the cluster? That’s where Raft shines.

Comments
2 min read
Database Indexing in .NET with EF Core – Boost Your Query Performance

Database Indexing in .NET with EF Core – Boost Your Query Performance

1
Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.