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.
Mastering Database Consistency: Unlocking the 'C' in ACID with PostgreSQL

Mastering Database Consistency: Unlocking the 'C' in ACID with PostgreSQL

5
Comments
5 min read
From DWH to Data Mesh: How Data Architectures Evolved to Meet Business Demands

From DWH to Data Mesh: How Data Architectures Evolved to Meet Business Demands

Comments
1 min read
🚀 SQL Query Optimization in 2025: 7 Techniques for Faster Performance

🚀 SQL Query Optimization in 2025: 7 Techniques for Faster Performance

Comments
1 min read
From Snowflake to Databend: Leading Game Platform replaced Snowflake with Databend Cloud for real-time Data Cloud

From Snowflake to Databend: Leading Game Platform replaced Snowflake with Databend Cloud for real-time Data Cloud

Comments
4 min read
The Three Normal Forms in Database and Why You Might Ignore Them

The Three Normal Forms in Database and Why You Might Ignore Them

6
Comments
6 min read
How to build Dashboards from MySQL data

How to build Dashboards from MySQL data

Comments
3 min read
Connecting to a Private RDS Instance via an EC2 Proxy

Connecting to a Private RDS Instance via an EC2 Proxy

7
Comments
2 min read
📍The Art of Choosing the Right Database

📍The Art of Choosing the Right Database

111
Comments 3
4 min read
I need a smart friend or someone to believe in me

I need a smart friend or someone to believe in me

Comments
1 min read
🐍 PostgreSQL + Python = Absolute Power: Meet PL/Python

🐍 PostgreSQL + Python = Absolute Power: Meet PL/Python

Comments
1 min read
CEAPs_Data_analysis

CEAPs_Data_analysis

Comments
2 min read
How to Optimize SQLite Performance With Indexed Views and Write-Ahead Logging

How to Optimize SQLite Performance With Indexed Views and Write-Ahead Logging

Comments
2 min read
Pessimistic & Optimistic Locking in Laravel

Pessimistic & Optimistic Locking in Laravel

2
Comments
4 min read
depuração ou refatoração?

depuração ou refatoração?

Comments
1 min read
Belajar Flyway Episode 2: Cara Kerja Flyway dan Versioned Migrations

Belajar Flyway Episode 2: Cara Kerja Flyway dan Versioned Migrations

5
Comments
8 min read
What is an ER Diagram

What is an ER Diagram

Comments
1 min read
Essential SQL Commands: A Quick Reference Guide

Essential SQL Commands: A Quick Reference Guide

5
Comments
8 min read
Unlocking 10x Revenue Growth with Data Analytics in Gaming

Unlocking 10x Revenue Growth with Data Analytics in Gaming

1
Comments
16 min read
How Timescale Solves Real-Time Analytics in Postgres

How Timescale Solves Real-Time Analytics in Postgres

Comments
5 min read
How to Dump Database Tables into Files to Speed Up Queries with esProc

How to Dump Database Tables into Files to Speed Up Queries with esProc

6
Comments
5 min read
🗃️ Introduction to Database Design: Concepts Every Beginner Should Know

🗃️ Introduction to Database Design: Concepts Every Beginner Should Know

Comments
4 min read
Mencegah SQL Injection di Prisma dengan Middleware dan withAccelerare

Mencegah SQL Injection di Prisma dengan Middleware dan withAccelerare

Comments
2 min read
Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20

Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20

6
Comments 1
2 min read
SQL Joins Made Easy: INNER, OUTER, LEFT, RIGHT Joins

SQL Joins Made Easy: INNER, OUTER, LEFT, RIGHT Joins

4
Comments 1
1 min read
VERSE.DB V3 (ANNOUNCEMENT)🔥

VERSE.DB V3 (ANNOUNCEMENT)🔥

4
Comments
1 min read
loading...