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.
Spring Crud Generator v1.2.0 — Improved DB Compatibility, JSON Collections, and More Reliable Docker Runs

Spring Crud Generator v1.2.0 — Improved DB Compatibility, JSON Collections, and More Reliable Docker Runs

1
Comments
2 min read
Using encrypted fields with mongodb community

Using encrypted fields with mongodb community

Comments
7 min read
COALESCE in SQL: the “Don’t Let NULL Win” Function You’ll Use Everywhere

COALESCE in SQL: the “Don’t Let NULL Win” Function You’ll Use Everywhere

Comments
2 min read
Databasus released full backups portability: backups recoverable without Databasus itself

Databasus released full backups portability: backups recoverable without Databasus itself

Comments
4 min read
SQL Joins and Window Functions: The Difference Between Combining Data and Analyzing It

SQL Joins and Window Functions: The Difference Between Combining Data and Analyzing It

1
Comments
3 min read
How to Query PostgreSQL from VS Code (Without Installing Anything Else)

How to Query PostgreSQL from VS Code (Without Installing Anything Else)

1
Comments
2 min read
.Net Learning Notes: Custom In-Memory Provider(3) - Storage Write Model and Key-Based Retrieval

.Net Learning Notes: Custom In-Memory Provider(3) - Storage Write Model and Key-Based Retrieval

Comments
4 min read
ACID compliance in data analytics platforms: what it is, why it matters, and how to verify it (2026)

ACID compliance in data analytics platforms: what it is, why it matters, and how to verify it (2026)

Comments
14 min read
Slapping Secondary Indexes on Random Fields is Silently Killing Your Database.

Slapping Secondary Indexes on Random Fields is Silently Killing Your Database.

2
Comments
2 min read
SQL Joins and Window Functions- Ultimate Guide

SQL Joins and Window Functions- Ultimate Guide

3
Comments
3 min read
PostgreSQL global statistics on partitionned table require a manual ANALYZE

PostgreSQL global statistics on partitionned table require a manual ANALYZE

6
Comments
8 min read
Zero-Downtime Schema Changes in SQL Server: The Reality Behind “Just Run the Migration”

Zero-Downtime Schema Changes in SQL Server: The Reality Behind “Just Run the Migration”

Comments
6 min read
Why SQL Makes You Stand Ahead of Most Candidates

Why SQL Makes You Stand Ahead of Most Candidates

Comments
2 min read
Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely

Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely

3
Comments
5 min read
Two ClickHouse Internals That Change How You Write Queries

Two ClickHouse Internals That Change How You Write Queries

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