personal activity index (bluesky, leaflet, substack)
pai.desertthunder.dev
desertthunder.dev
rss
bluesky
1-- Personal Activity Index D1 Schema
2-- This schema is compatible with both SQLite (CLI) and D1 (Worker)
3
4CREATE TABLE IF NOT EXISTS items (
5 id TEXT PRIMARY KEY,
6 source_kind TEXT NOT NULL,
7 source_id TEXT NOT NULL,
8 author TEXT,
9 title TEXT,
10 summary TEXT,
11 url TEXT NOT NULL,
12 content_html TEXT,
13 published_at TEXT NOT NULL,
14 created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP
15);
16
17CREATE INDEX IF NOT EXISTS idx_items_source_date ON items (source_kind, source_id, published_at DESC);
18CREATE INDEX IF NOT EXISTS idx_items_published ON items (published_at DESC);