A simple Bluesky bot to make sense of the noise, with responses powered by Gemini, similar to Grok.
indexx.dev
1CREATE TABLE `conversations` (
2 `id` text NOT NULL,
3 `did` text NOT NULL,
4 `post_uri` text NOT NULL,
5 `revision` text NOT NULL,
6 `created_at` integer DEFAULT CURRENT_TIMESTAMP NOT NULL,
7 `last_active` integer DEFAULT CURRENT_TIMESTAMP NOT NULL
8);
9--> statement-breakpoint
10CREATE UNIQUE INDEX `conversations_id_unique` ON `conversations` (`id`);--> statement-breakpoint
11CREATE UNIQUE INDEX `conversations_did_unique` ON `conversations` (`did`);--> statement-breakpoint
12CREATE TABLE `messages` (
13 `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
14 `conversation_id` text NOT NULL,
15 `revision` text NOT NULL,
16 `did` text NOT NULL,
17 `post_uri` text NOT NULL,
18 `text` text NOT NULL,
19 `created_at` integer DEFAULT CURRENT_TIMESTAMP NOT NULL,
20 FOREIGN KEY (`conversation_id`) REFERENCES `conversations`(`id`) ON UPDATE no action ON DELETE no action,
21 FOREIGN KEY (`revision`) REFERENCES `conversations`(`revision`) ON UPDATE no action ON DELETE no action
22);