Skip to main content

Database

SPN uses PostgreSQL with Alembic for migrations.

Migrations

Generate Migration

Apply Migrations

Rollback

View History

Schema

Core Tables

The companies table includes a search_vector column for fast search:

Connecting to Database

From Host

From Container

Common Tasks

Add a Column

  1. Update model in backend/app/models/domain.py
  2. Generate migration: alembic revision --autogenerate
  3. Review the migration file
  4. Apply: alembic upgrade head

Reset Database

Warning: This deletes all data!