social media crossposting tool. 3rd time's the charm
zenfyr.dev
mastodon
misskey
crossposting
bluesky
1import sqlite3
2
3
4def migrate(conn: sqlite3.Connection):
5 _ = conn.execute("""
6 CREATE INDEX IF NOT EXISTS idx_posts_service_user_identifier
7 ON posts (service, user, identifier);
8 """)
9 _ = conn.execute("""
10 CREATE UNIQUE INDEX IF NOT EXISTS ux_mappings_original_mapped
11 ON mappings (original, mapped);
12 """)