# ADR 005: Capability-specific database defaults

- HTML version: https://robbiepalmer.me/projects/personal-engineering-platform/adrs/005-database-defaults
- Project: Personal Engineering Platform (https://robbiepalmer.me/projects/personal-engineering-platform.md)
- Status: Accepted
- Date: 2026-09-12
- Initiatives: Semi-autonomous Software Development (https://robbiepalmer.me/initiatives/semi-autonomous-software-development.md)

## Context

Transactional storage and analytical SQL have different requirements. One
database slot would hide those differences.

## Decision

Use separate preferred slots. Select PostgreSQL for relational storage, Neon
when PostgreSQL needs a managed host, and DuckDB for OLAP. Neon requires the
PostgreSQL selection.

## Consequences

Database-backed projects activate only the capabilities they use. A project
can replace one choice without overriding the others.

---

Markdown index of this site: https://robbiepalmer.me/llms.txt