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.
Coding Cat Oran S2 Ep5 — The Many-to-Many Disaster

Coding Cat Oran S2 Ep5 — The Many-to-Many Disaster

Comments
5 min read
Coding Cat Oran S2 Ep6 — The Abstract Table and the Gateway

Coding Cat Oran S2 Ep6 — The Abstract Table and the Gateway

Comments
6 min read
Coding Cat Oran S2 Ep4 — The Voluntary Table

Coding Cat Oran S2 Ep4 — The Voluntary Table

Comments
4 min read
PostgreSQL JSON Ext., Vector Search, & SQLite Window Func Overflow

PostgreSQL JSON Ext., Vector Search, & SQLite Window Func Overflow

Comments
3 min read
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
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
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
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
Redis 101: The Swiss Army Knife of Backend Development

Redis 101: The Swiss Army Knife of Backend Development

Comments 1
4 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.