BfArM-MVH/grz-tools

Migrate database columns to JSONB types

Open

#548 opened on Apr 24, 2026

View on GitHub
 (1 comment) (0 reactions) (0 assignees)Python (12 forks)auto 404
good first issuepackage: grz-dbpriority: low

Repository metrics

Stars
 (3 stars)
PR merge metrics
 (PR metrics pending)

Description

At least for postgresql.

Not sure about sqlite: https://github.com/sqlalchemy/sqlalchemy/discussions/13259

Contributor guide

Research direction
Investigate how to alter column types to JSONB in SQLAlchemy migrations for PostgreSQL, and determine if a similar change is possible for SQLite.
Tech stack
pythonpostgresql
Domain
database
Issue type
Refactor
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
Half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Fresh
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Needs investigation
Prerequisites
PythonSQLAlchemyPostgreSQL
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
60