social media crossposting tool. 3rd time's the charm
zenfyr.dev
mastodon
misskey
crossposting
bluesky
1CREATE TABLE IF NOT EXISTS posts (
2 id INTEGER UNIQUE PRIMARY KEY AUTOINCREMENT,
3 user TEXT NOT NULL,
4 service TEXT NOT NULL,
5 identifier TEXT NOT NULL,
6 parent INTEGER NULL REFERENCES posts(id),
7 root INTEGER NULL REFERENCES posts(id),
8 reposted INTEGER NULL REFERENCES posts(id),
9 extra_data TEXT NULL
10);
11
12CREATE TABLE IF NOT EXISTS mappings (
13 original INTEGER NOT NULL REFERENCES posts(id) ON DELETE CASCADE,
14 mapped INTEGER NOT NULL REFERENCES posts(id) ON DELETE CASCADE,
15 UNIQUE(original, mapped)
16);