malpercio.dev
WIP! A BB-style forum, on the ATmosphere!
We're still working... we'll be back soon when we have something to show off!
node
typescript
hono
htmx
atproto
1CREATE TABLE "backfill_errors" (
2 "id" bigserial PRIMARY KEY NOT NULL,
3 "backfill_id" bigint NOT NULL,
4 "did" text NOT NULL,
5 "collection" text NOT NULL,
6 "error_message" text NOT NULL,
7 "created_at" timestamp with time zone NOT NULL
8);
9--> statement-breakpoint
10CREATE TABLE "backfill_progress" (
11 "id" bigserial PRIMARY KEY NOT NULL,
12 "status" text NOT NULL,
13 "backfill_type" text NOT NULL,
14 "last_processed_did" text,
15 "dids_total" integer DEFAULT 0 NOT NULL,
16 "dids_processed" integer DEFAULT 0 NOT NULL,
17 "records_indexed" integer DEFAULT 0 NOT NULL,
18 "started_at" timestamp with time zone NOT NULL,
19 "completed_at" timestamp with time zone,
20 "error_message" text
21);
22--> statement-breakpoint
23ALTER TABLE "backfill_errors" ADD CONSTRAINT "backfill_errors_backfill_id_backfill_progress_id_fk" FOREIGN KEY ("backfill_id") REFERENCES "public"."backfill_progress"("id") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
24CREATE INDEX "backfill_errors_backfill_id_idx" ON "backfill_errors" USING btree ("backfill_id");