Release · v2.2.6
Refactor backend Supabase workflow and remove…
Refactor backend Supabase workflow and remove duplicate content from git.
Details
Reorganize into backend/supabase_db (CLI push/pull/verify, schema) and backend/runtime (GA config). Drop committed news_rows.json, SQL seeds, and local CV.pdf; site content is served from Supabase only. Co-authored-by: Cursor <cursoragent@cursor.com>
Files changed (41)
| .github/workflows/ci.yml | +2 | −2 |
| .gitignore | +7 | −5 |
| README.md | +9 | −11 |
| assets/documents/CV.pdf | — | — |
| backend/README.md | +6 | −0 |
| backend/config/.env.anon.template | +0 | −3 |
| backend/data/news_rows.json | +0 | −7 |
| backend/migrations/migrate_add_flairs_2026_links.sql | +0 | −14 |
| backend/migrations/migrate_document_titles.sql | +0 | −29 |
| backend/migrations/migrate_fix_dead_external_links.sql | +0 | −20 |
| backend/migrations/migrate_intro_link_labels.sql | +0 | −100 |
| backend/migrations/migrate_media_asset_titles.sql | +0 | −13 |
| backend/{ => runtime}/config/.env.runtime.template | +2 | −2 |
| backend/{ => runtime}/scripts/generate_runtime_config.sh | +6 | −5 |
| backend/scripts/export_catalog_seed.py | +0 | −233 |
| backend/scripts/upload_assets_to_storage_api.py | +0 | −238 |
| backend/scripts/upload_big_videos_tus.ts | +0 | −194 |
| backend/scripts/upsert_assets_api.py | +0 | −116 |
| backend/scripts/upsert_news_api.py | +0 | −81 |
| backend/scripts/verify_db_api.py | +0 | −130 |
| backend/seeds/seed_documents.sql | +0 | −25 |
| backend/seeds/seed_links.sql | +0 | −106 |
| backend/seeds/seed_media_assets.sql | +0 | −9 |
| backend/supabase_db/DATABASE.md | +41 | −0 |
| backend/{ => supabase_db}/config/.env.api.template | +0 | −0 |
| backend/supabase_db/data/.gitkeep | +0 | −0 |
| backend/supabase_db/migrations/README.md | +10 | −0 |
| backend/supabase_db/migrations/migrate_unique_keys_for_upsert.sql | +31 | −0 |
| backend/{seeds/seed_news.sql => supabase_db/schemas/examples/news_upsert.sql} | +2 | −10 |
| backend/{ => supabase_db}/schemas/schema.sql | +3 | −3 |
| backend/supabase_db/scripts/_db_common.py | +134 | −0 |
| backend/supabase_db/scripts/pull_db.py | +104 | −0 |
| backend/supabase_db/scripts/push_db.py | +189 | −0 |
| backend/supabase_db/scripts/sync_frontend_assets.py | +149 | −0 |
| backend/{ => supabase_db}/scripts/sync_github_secrets.py | +14 | −29 |
| backend/supabase_db/scripts/verify_db_api.py | +67 | −0 |
| backend/tsconfig.json | +0 | −13 |
| frontend/_data/runtime.yml.template | +1 | −1 |
| frontend/scripts/local.sh | +1 | −1 |
| package-lock.json | +0 | −167 |
…and 1 more files.