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.
RUM—Storing More in the Index

RUM—Storing More in the Index

Comments
6 min read
I Built a Bloom Filter from Scratch in Pure Python and Finally Understood How Databases Skip Reading Data

I Built a Bloom Filter from Scratch in Pure Python and Finally Understood How Databases Skip Reading Data

Comments
6 min read
33/60 Days System Design Questions

33/60 Days System Design Questions

1
Comments 4
1 min read
GIN: Understanding PostgreSQL's Inverted Index and Its Limitations

GIN: Understanding PostgreSQL's Inverted Index and Its Limitations

1
Comments
5 min read
Entity Framework vs. Dapper: Choosing the Right ORM for .NET

Entity Framework vs. Dapper: Choosing the Right ORM for .NET

Comments
4 min read
State of the Program #1

State of the Program #1

Comments
3 min read
Database Optimization Techniques for High-Traffic Laravel Applications

Database Optimization Techniques for High-Traffic Laravel Applications

Comments
4 min read
DuckLake Spec, pg_background 2.0, and pgsql_tweaks 1.0.3 Enhance Database Ecosystem

DuckLake Spec, pg_background 2.0, and pgsql_tweaks 1.0.3 Enhance Database Ecosystem

Comments
4 min read
Update record using JooqTemplate

Update record using JooqTemplate

Comments
1 min read
Retention cohort analysis with plain SQL

Retention cohort analysis with plain SQL

Comments
2 min read
PostgreSQL 22013 Error: Causes and Solutions Complete Guide

PostgreSQL 22013 Error: Causes and Solutions Complete Guide

1
Comments
3 min read
T-SQL patterns that break when you migrate SQL Server to PostgreSQL (and where they hide in Java/C#)

T-SQL patterns that break when you migrate SQL Server to PostgreSQL (and where they hide in Java/C#)

Comments
1 min read
Self-Host Postgres or Use Supabase? Here's How to Decide

Self-Host Postgres or Use Supabase? Here's How to Decide

Comments
3 min read
GBase 8c Audit and Log Governance: Don't Wait Until Disks Are Full

GBase 8c Audit and Log Governance: Don't Wait Until Disks Are Full

Comments
3 min read
Starting a Migration: Shifting from a Legacy Data System to a Modern Data Stack

Starting a Migration: Shifting from a Legacy Data System to a Modern Data Stack

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