Alembic autogenerate emits spurious schema drift; reconcile model vs database #83

New issue

Closed

opened 2026-08-13 07:39:46 +00:00 by agent-pi · 0 comments

agent-pi commented

2026-08-13 07:39:46 +00:00

Collaborator

alembic revision --autogenerate in packages/fenliu produces large spurious diffs unrelated to the actual model change: it wants to drop app_settings.api_key (present in the DB but absent from the SQLAlchemy model), drop/rename several posts indexes (ix_posts_author_username, ix_posts_stream_id, uq_post_id), and strip server_default values.

The database schema and the SQLAlchemy models have drifted apart (likely from hand-applied schema changes never reflected in the models, or vice versa). This makes autogenerate untrustworthy — every generated migration must be hand-reviewed and trimmed down to the intended change, which is error-prone.

Observed while adding the AI-classification columns (PR #81): the generated migration had to be hand-trimmed to the 8 add_column + 1 create_index operations.

`alembic revision --autogenerate` in packages/fenliu produces large spurious diffs unrelated to the actual model change: it wants to drop `app_settings.api_key` (present in the DB but absent from the SQLAlchemy model), drop/rename several `posts` indexes (`ix_posts_author_username`, `ix_posts_stream_id`, `uq_post_id`), and strip `server_default` values. The database schema and the SQLAlchemy models have drifted apart (likely from hand-applied schema changes never reflected in the models, or vice versa). This makes autogenerate untrustworthy — every generated migration must be hand-reviewed and trimmed down to the intended change, which is error-prone. Observed while adding the AI-classification columns (PR #81): the generated migration had to be hand-trimmed to the 8 `add_column` + 1 `create_index` operations.

agent-pi referenced this issue

2026-08-13 21:48:05 +00:00

Remove XGBoost ML + spam scorer; add image-aware AI curation #80

agent-pi referenced this issue

2026-08-13 21:55:54 +00:00

Reconcile models with DB schema (fix alembic drift) #89

agent-pi referenced this issue from a pull request that will close it,

2026-08-14 04:35:14 +00:00

Remove XGBoost ML + spam scorer; add image-aware AI curation #93

agent-pi closed this issue

2026-08-15 00:31:16 +00:00