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.
Great Stack to Doesn't Work #1 — PostgreSQL: "I Added an Index and It Got Slower"

Great Stack to Doesn't Work #1 — PostgreSQL: "I Added an Index and It Got Slower"

Comments
7 min read
Data Modeling, Joins, Relationships, and Different Schemas

Data Modeling, Joins, Relationships, and Different Schemas

Comments
3 min read
Why AI Agents Make Me Reach for SQLite

Why AI Agents Make Me Reach for SQLite

10
Comments 9
10 min read
How GBase 8a Rough Index Works: Block‑Level Pruning for 10x Faster Queries

How GBase 8a Rough Index Works: Block‑Level Pruning for 10x Faster Queries

2
Comments
2 min read
Search in the LLM Era: Vector RAG vs Vectorless Search vs LLM-Wiki

Search in the LLM Era: Vector RAG vs Vectorless Search vs LLM-Wiki

Comments
4 min read
Fencing a node that doesn't know it's dead: pgrac build log #2

Fencing a node that doesn't know it's dead: pgrac build log #2

1
Comments
6 min read
Linux Fundamentals for Data Engineering.

Linux Fundamentals for Data Engineering.

6
Comments
5 min read
We Open-Sourced Our Entire Database Management Platform. Here's Why.

We Open-Sourced Our Entire Database Management Platform. Here's Why.

Comments
3 min read
LioranDB Progress

LioranDB Progress

1
Comments
1 min read
Oracle Fusion vs EBS: 7 SQL Patterns Every BIP Report Developer Needs

Oracle Fusion vs EBS: 7 SQL Patterns Every BIP Report Developer Needs

Comments
5 min read
Hexagons, Hypertables, and 240 Dead Tags: Migrating a Maritime Data Platform to TimescaleDB

Hexagons, Hypertables, and 240 Dead Tags: Migrating a Maritime Data Platform to TimescaleDB

Comments
11 min read
GBase 8a Partitioning Best Practices: From Design to Operations

GBase 8a Partitioning Best Practices: From Design to Operations

2
Comments
3 min read
Six SQL patterns I use to catch transaction fraud

Six SQL patterns I use to catch transaction fraud

Comments
8 min read
Introduction to Python for Data Analysis

Introduction to Python for Data Analysis

Comments
1 min read
A Practical Introduction to SQL: DDL, DML, and Data Analysis

A Practical Introduction to SQL: DDL, DML, and Data Analysis

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