BlueSky & more on desktop
lazurite.stormlightlabs.org/
tauri
rust
typescript
bluesky
appview
atproto
solid
1CREATE TABLE drafts (
2 id TEXT PRIMARY KEY,
3 account_did TEXT NOT NULL,
4 text TEXT NOT NULL,
5 reply_parent_uri TEXT,
6 reply_parent_cid TEXT,
7 reply_root_uri TEXT,
8 reply_root_cid TEXT,
9 quote_uri TEXT,
10 quote_cid TEXT,
11 title TEXT,
12 created_at TEXT NOT NULL,
13 updated_at TEXT NOT NULL
14);
15
16CREATE INDEX idx_drafts_account_updated ON drafts (account_did, updated_at DESC);