internal/db/migrations · tidepool · Tangled

Read-only ActivityPub → atproto bridge for the threadiverse using Coves lexicons

tidepool internal db migrations

42 files

· feat(handles): bridged handle scheme under ap.tdpl.io with an in-place rename job · 2w ago

001_create_ap_objects.sql

Task 01: scaffold, config, errors, migrations, storage spine

002_create_bridged_actors.sql

Task 01: scaffold, config, errors, migrations, storage spine

003_create_communities.sql

Task 01: scaffold, config, errors, migrations, storage spine

004_create_inbox_events.sql

Task 01: scaffold, config, errors, migrations, storage spine

005_create_service_keys.sql

Task 02: ActivityPub client protocol layer (internal/ap)

006_create_repo_tables.sql

Task 03: did:plc identity minting, key custody, virtual repo layer

007_firehose_retention_index.sql

Task 04: com.atproto.sync.* surface + subscribeRepos firehose

008_create_blobs.sql

Task 05: AP -> social.coves.* materializer

009_ingestion_queue.sql

Task 06: ingestion pipeline — inbox, queue, dispatch, follow, backfill, consent

010_vote_aggregates.sql

Task 07: vote aggregation side channel — aggregator, XRPC, seeding

011_account_events.sql

Task 11: pre-internet-facing hardening — admission control, #account frame, pruners

012_follow_retry.sql

Task 11: pre-internet-facing hardening — admission control, #account frame, pruners

013_rename_service_key_column.sql

Task 11: pre-internet-facing hardening — admission control, #account frame, pruners

014_vote_stats_watermark.sql

feat(votes): emit bridgedStats on records via debounced refresher

015_scoped_tombstones.sql

fix(ingest): authorize announced deletes by membership, scope tombstones

016_ap_object_community.sql

wip(task19): postv2 flip cycles 1-4 — digest rkey, author-repo postv2, community_did spine, acceptance writer

017_ap_actors.sql

wip(task13): cycles 1-6 — custodian RSA, ap_actors store, local-part derivation, mint, serving surface

018_consumer_state.sql

fix(task14): second-opinion fix wave — envelope validation, gate atomicity, consent gating, hardening

019_account_event_seq.sql

fix(task14): second-opinion fix wave — envelope validation, gate atomicity, consent gating, hardening

020_outbound_delivery.sql

fix(task15): second-opinion fix wave — inbox same-authority (SSRF), atomic delivery state, real-parent causal gate, hardening

021_admissions.sql

accept: a banned author's edit no longer evicts the post from the purge set

022_admission_snapshot.sql

wip(task16): cycle 3 — admin surface (list admissions + readmit reusing decide()), evaluated_snapshot (migration 022), main mount

023_vote_seed_netting.sql

feat(votes): net our written-back votes out of the re-seed baseline (17b)

024_ap_object_community_backfill.sql

fix(ingest): bind the verified signer, never the claimed actor (SEC-1)

025_object_moderation.sql

fix(moderation): close the legacy lock paths and split the moderation seam (17c-2 review)

026_ap_object_thread_root.sql

feat(moderation): thread locks and native comment removal (17c-2)

027_community_bans.sql

fix(moderation): a lapsed ban acts on nothing, and the gate covers every write (17c-3 review)

028_federation_pref_account_source.sql

feat(optout): the two opt-out tiers, and the fan-out that makes erasure real (17d)

029_actor_tombstone.sql

feat(optout): the two opt-out tiers, and the fan-out that makes erasure real (17d)

030_federation_pref_purged.sql

fix(optout): a withdrawal that survives its own replay, and stays withdrawn (17d review)

031_admissions_post_uri_unique.sql

accept: settle jurisdiction before merit in decide(); make post_uri unique

032_ap_objects_arrival.sql

feat(delegation): delegate only instances with standing announced contributions

033_handle_claims.sql

feat(handles): bridged handle scheme under ap.tdpl.io with an in-place rename job

034_actor_preferred_username.sql

feat(handles): bridged handle scheme under ap.tdpl.io with an in-place rename job

035_identity_events.sql

feat(handles): bridged handle scheme under ap.tdpl.io with an in-place rename job

036_handle_rename.sql

feat(handles): bridged handle scheme under ap.tdpl.io with an in-place rename job

037_handle_migration_error.sql

feat(handles): bridged handle scheme under ap.tdpl.io with an in-place rename job

038_handle_migration_error_username.sql

feat(handles): bridged handle scheme under ap.tdpl.io with an in-place rename job

039_handle_migration_runs.sql

feat(handles): bridged handle scheme under ap.tdpl.io with an in-place rename job

040_handle_migration_run_rollback.sql

feat(handles): bridged handle scheme under ap.tdpl.io with an in-place rename job

041_bridged_actor_pending_revert_submitted.sql

feat(handles): bridged handle scheme under ap.tdpl.io with an in-place rename job

042_instances.sql

feat(handles): bridged handle scheme under ap.tdpl.io with an in-place rename job