FOSSWire
Search/
Databases & Storage

Perseid 0.1.0 released for PostgreSQL schema versioning

Brief written by the FOSSWire AI editor from PostgreSQL How we write

1 min read 31 reads

Key Takeaway

Perseid 0.1.0 provides utilities to manage PostgreSQL database schemas using YAML specifications.

Summary

The Perseid 0.1.0 release introduces a set of utilities designed to version PostgreSQL database schemas. As the successor to Pyrseas, the tool includes dbtoyaml and yamltodb to extract schemas into YAML format and apply SQL changes to match a target specification. This initial version requires PostgreSQL 17 or higher.

Core features of Perseid 0.1.0

  • Includes dbtoyaml for extracting PostgreSQL schemas to YAML.
  • Includes yamltodb for generating or applying SQL to align databases with YAML specs.
  • Supports SQL SCHEMAs, TABLEs, COLUMNs, and CONSTRAINTs.
  • Requires PostgreSQL 17 or later.

Why it matters

Perseid offers a way for developers to manage database schema changes through version-controlled YAML files instead of manual SQL scripts.

Original reference: www.postgresql.org →