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.
SQL ARTICLE

SQL ARTICLE

Comments
2 min read
Why "Vibe Coding" Your Data Warehouse is a Terrible Idea

Why "Vibe Coding" Your Data Warehouse is a Terrible Idea

2
Comments 1
2 min read
MCP 生态系统研究 2025:数据库连接器现状与机遇

MCP 生态系统研究 2025:数据库连接器现状与机遇

Comments
1 min read
Auditing in Java systems: RLS in the database or application-level control?

Auditing in Java systems: RLS in the database or application-level control?

1
Comments
2 min read
My First Week with SQL: A Beginner's Guide to Building, Filling, and Querying a Real Database

My First Week with SQL: A Beginner's Guide to Building, Filling, and Querying a Real Database

1
Comments
7 min read
ETL vs ELT: Which One Should You Use and Why?

ETL vs ELT: Which One Should You Use and Why?

Comments
7 min read
Why PostgreSQL Ignores Your Index (Sometimes), Entry #2

Why PostgreSQL Ignores Your Index (Sometimes), Entry #2

3
Comments
3 min read
SQLite PRAGMA: The Underrated Lever That Controls Your DB

SQLite PRAGMA: The Underrated Lever That Controls Your DB

10
Comments 1
3 min read
I built an open-source encyclopedia of psychoactive substances with Next.js 16 — here's what I learned

I built an open-source encyclopedia of psychoactive substances with Next.js 16 — here's what I learned

Comments
2 min read
How to Find and Kill Long-Running Queries in SQL Server

How to Find and Kill Long-Running Queries in SQL Server

1
Comments
3 min read
SQL Concepts and Practical Application

SQL Concepts and Practical Application

1
Comments
2 min read
Write Your SQL Like a Pro: Mastering Common Table Expressions (CTEs)

Write Your SQL Like a Pro: Mastering Common Table Expressions (CTEs)

1
Comments
5 min read
SQLite WAL Mode for Better Concurrent Web Performance

SQLite WAL Mode for Better Concurrent Web Performance

1
Comments
3 min read
SQL CASE Expressions: Write Smarter Queries with Conditional Logic

SQL CASE Expressions: Write Smarter Queries with Conditional Logic

Comments
5 min read
I Built a 20-Hour DBMS Interview Prep System Using LLMs — Does It Actually Work?

I Built a 20-Hour DBMS Interview Prep System Using LLMs — Does It Actually Work?

Comments 2
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.