Skip to content

DEV Community

Database

Posts on building, using, and learning about databases.

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

Feb 17

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

#database #duckdb #analytics #data

14 min read

Kelvin

Mar 13

sql and databases

#beginners #database #sql #tutorial

12 min read

Wanda

Mar 13

How Should You Design API Pagination for Millions of Records?

#api #database #performance #systemdesign

7 min read

Mar 13

Connecting power bi to SQL databases locally and through cloud service.

#sql #database #productivity #beginners

5 min read

Athreya aka Maneshwar

Mar 22

Inside SQLite’s Frontend: How the Query Optimizer Makes Your SQL Fast

#webdev #architecture #database #programming

5 min read

OPEYEMI OLUWAGBEMIGA

Mar 3

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

#database #systemdesign #postgres

2 min read

catatsuy

Mar 15

Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL

#mysql #postgres #database #sql

13 min read

Mar 12

ACID Properties in Database Systems: The Foundation of Reliable Data Management

#acid #database #scalability

4 min read

Feb 17

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

#database #performance #sql #sre

6 min read

Tanushree Poojary

Feb 17

Why SQL Makes You Stand Ahead of Most Candidates

#sql #analytics #database #datascience

2 min read

Mar 2

Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely

#postgres #database #sql #backend

5 min read

Santhoshi Mary A

Mar 22

Number Guessing Game

#database #python #sql #tutorial

2 min read

Mohamed Hussain S

Feb 17

Two ClickHouse Internals That Change How You Write Queries

#clickhouse #database #backend #performance

4 min read

Philip McClarence

Mar 2

PostgreSQL vs MongoDB in 2026: When to Choose SQL Over NoSQL

#database #mongodb #postgres #sql

12 min read

Maximilian Both

Mar 22

Introducing MoltenDB: A Local-First, Pure Rust Database for the Browser and Server

#rust #nosql #typescript #database

3 min read

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