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.
The Complete Guide to PostgreSQL SQL Query Analysis & Optimization

The Complete Guide to PostgreSQL SQL Query Analysis & Optimization

2
Comments
10 min read
Beyond CRUD: How easy-query Brings OLAP Superpowers to Your Java ORM

Beyond CRUD: How easy-query Brings OLAP Superpowers to Your Java ORM

2
Comments
7 min read
Basic SQL Select Queries

Basic SQL Select Queries

1
Comments
2 min read
Dissecting MongoDB — It Uses B-Trees Too, So Why Are Writes Actually Faster?

Dissecting MongoDB — It Uses B-Trees Too, So Why Are Writes Actually Faster?

4
Comments
10 min read
Stop writing cron jobs: I built a C++ database with native temporal states

Stop writing cron jobs: I built a C++ database with native temporal states

5
Comments
1 min read
How the Two Most Popular Open-Source Databases (MySQL & PostgreSQL) Handle INSERT, UPDATE, DELETE

How the Two Most Popular Open-Source Databases (MySQL & PostgreSQL) Handle INSERT, UPDATE, DELETE

Comments
6 min read
How I made a 31M-row SQLite query go from 168 seconds to 5 seconds

How I made a 31M-row SQLite query go from 168 seconds to 5 seconds

1
Comments
4 min read
Next.js 16 SaaS Database Schema with Prisma: Users, Subscriptions, and AI Chat

Next.js 16 SaaS Database Schema with Prisma: Users, Subscriptions, and AI Chat

1
Comments
4 min read
Building a Content Cleanup System for Old Videos

Building a Content Cleanup System for Old Videos

Comments
2 min read
AUTOVACUUM in SQLite: How Your Database Cleans Up After Itself

AUTOVACUUM in SQLite: How Your Database Cleans Up After Itself

21
Comments 5
4 min read
Introducing Xata OSS: Postgres platform with branching, now Apache 2.0

Introducing Xata OSS: Postgres platform with branching, now Apache 2.0

6
Comments
7 min read
Building QuizTest — A WPF Quiz Application for Educational Institutions

Building QuizTest — A WPF Quiz Application for Educational Institutions

2
Comments
3 min read
pg_duckpipe: Real-time CDC for streaming Postgres Table into Columnar Ducklake

pg_duckpipe: Real-time CDC for streaming Postgres Table into Columnar Ducklake

1
Comments
3 min read
Reacting to Database Changes in Real-Time: How I Built a CDC Tool

Reacting to Database Changes in Real-Time: How I Built a CDC Tool

1
Comments 2
8 min read
Salesforce Put Heroku Into Maintenance Mode.

Salesforce Put Heroku Into Maintenance Mode.

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