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.
😱 Stop Writing Useless SQL Queries! Discover the Secret Powers of Window Functions

😱 Stop Writing Useless SQL Queries! Discover the Secret Powers of Window Functions

Comments
3 min read
Amazon Athena: análises SQL diretas no S3 – quando usar, quanto custa e quais os limites

Amazon Athena: análises SQL diretas no S3 – quando usar, quanto custa e quais os limites

Comments
6 min read
A Beginner’s Journey with PostgreSQL

A Beginner’s Journey with PostgreSQL

Comments
3 min read
TIL: Transactions in .NET

TIL: Transactions in .NET

Comments
2 min read
Log015_sakila_mysql_pymongo

Log015_sakila_mysql_pymongo

Comments
2 min read
# Enforcing Row Level Security in Supabase: A Deep Dive into LockIn's Multi-Tenant Architecture

# Enforcing Row Level Security in Supabase: A Deep Dive into LockIn's Multi-Tenant Architecture

Comments
8 min read
JOIN the data analytics race: Apache Doris vs. ClickHouse, Databricks, and Snowflake

JOIN the data analytics race: Apache Doris vs. ClickHouse, Databricks, and Snowflake

Comments
6 min read
I Built a CLI to Test Supabase RLS Policies

I Built a CLI to Test Supabase RLS Policies

Comments
1 min read
Laravel app was slow. Here's how I fixed it

Laravel app was slow. Here's how I fixed it

2
Comments
1 min read
Database index tutorial with MYSQL

Database index tutorial with MYSQL

Comments
3 min read
Getting Started Building a Data Platform

Getting Started Building a Data Platform

Comments
3 min read
Building a Universal Lakehouse Catalog: Beyond Iceberg Tables

Building a Universal Lakehouse Catalog: Beyond Iceberg Tables

Comments
10 min read
Real-time Data Analytics at Scale: Integrating Apache Flink and Apache Doris with Flink Doris Connector and Flink CDC

Real-time Data Analytics at Scale: Integrating Apache Flink and Apache Doris with Flink Doris Connector and Flink CDC

Comments
10 min read
How Many DBAs Should a Technical Team Have?

How Many DBAs Should a Technical Team Have?

Comments
5 min read
How I Manage a Technical Team of Over 100 People

How I Manage a Technical Team of Over 100 People

1
Comments
7 min read
Solving Database Performance Bottlenecks in Node + MySQL

Solving Database Performance Bottlenecks in Node + MySQL

Comments
3 min read
(1) Emerging Data Lakehouse Handbook (2025): Concepts and Design of Data Warehouse Layering

(1) Emerging Data Lakehouse Handbook (2025): Concepts and Design of Data Warehouse Layering

Comments
5 min read
Chinese DBA's Story: Hu Zhonghao - The Journey of Becoming a DBA for Domestic Distributed Databases

Chinese DBA's Story: Hu Zhonghao - The Journey of Becoming a DBA for Domestic Distributed Databases

Comments
7 min read
Concurrency and API Protection - Part 3

Concurrency and API Protection - Part 3

Comments
7 min read
Why Every Microservice Should Have Its Own Database

Why Every Microservice Should Have Its Own Database

Comments
3 min read
Building Reliable AI Analysts: An Observability Framework for Text-to-SQL Systems

Building Reliable AI Analysts: An Observability Framework for Text-to-SQL Systems

4
Comments
6 min read
Chinese DBA’s Story: LiJianMing-The 14-Year Technical Journey and Growth Wisdom of an Ordinary DBA

Chinese DBA’s Story: LiJianMing-The 14-Year Technical Journey and Growth Wisdom of an Ordinary DBA

5
Comments
8 min read
Chinese DBA's Story: Wang Sifeng - Luck may not always be on your side, but hard work will never let you down

Chinese DBA's Story: Wang Sifeng - Luck may not always be on your side, but hard work will never let you down

Comments
6 min read
🧭System Design Roadmap for Data Engineers

🧭System Design Roadmap for Data Engineers

3
Comments
3 min read
Database analytics: Query your source of truth

Database analytics: Query your source of truth

Comments
12 min read
loading...