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.
LatticeDB vs SQLite: I Ran the Graph Traversal Benchmarks. The Gap Is Real but the Fine Print Matters

LatticeDB vs SQLite: I Ran the Graph Traversal Benchmarks. The Gap Is Real but the Fine Print Matters

Comments
8 min read
Why Is My SQL Query Slow Only in Production? (The Parameter Sniffing Trap)

Why Is My SQL Query Slow Only in Production? (The Parameter Sniffing Trap)

Comments 1
2 min read
How to compare two PostgreSQL schemas

How to compare two PostgreSQL schemas

1
Comments
6 min read
Database interview questions for backend engineers

Database interview questions for backend engineers

Comments 1
5 min read
Magento 2 Database Index Strategy & Query Optimization

Magento 2 Database Index Strategy & Query Optimization

1
Comments
6 min read
BUILDING GREENWOOD ACADEMY DATABASE USING POSTGRESQL

BUILDING GREENWOOD ACADEMY DATABASE USING POSTGRESQL

1
Comments
5 min read
How to Build Rock-Solid Real-Time Data Pipelines from the Factory Floor IoT

How to Build Rock-Solid Real-Time Data Pipelines from the Factory Floor IoT

5
Comments
3 min read
How an Employee Hierarchy Helped Me Understand Recursive CTEs

How an Employee Hierarchy Helped Me Understand Recursive CTEs

6
Comments 1
13 min read
SQLite vs PostgreSQL: Choosing the Right Database

SQLite vs PostgreSQL: Choosing the Right Database

Comments
5 min read
How We Do Bank-Grade Encryption and Cross-Device Sync Without Running a Server

How We Do Bank-Grade Encryption and Cross-Device Sync Without Running a Server

Comments 1
2 min read
Building a Data Pipeline for Real Estate Feasibility Analysis

Building a Data Pipeline for Real Estate Feasibility Analysis

Comments 1
7 min read
What Durable Actually Means for Money-Critical Code

What Durable Actually Means for Money-Critical Code

Comments
3 min read
I Opened the Network Tab and Found a Problem I Didn’t Know I Had

I Opened the Network Tab and Found a Problem I Didn’t Know I Had

3
Comments 1
4 min read
Una migración sin vuelta atrás es una apuesta

Una migración sin vuelta atrás es una apuesta

Comments 1
2 min read
Day 100 of #100DaysOfClickHouse: Optimizing Data Lake Queries with ClickHouse® 26.3 LTS

Day 100 of #100DaysOfClickHouse: Optimizing Data Lake Queries with ClickHouse® 26.3 LTS

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