social media crossposting tool. 3rd time's the charm
zenfyr.dev
mastodon
misskey
crossposting
bluesky
1import sqlite3
2from pathlib import Path
3
4
5def get_conn(db: Path) -> sqlite3.Connection:
6 conn = sqlite3.connect(db, autocommit=True, check_same_thread=False)
7 conn.row_factory = sqlite3.Row
8 _ = conn.executescript("""
9 PRAGMA journal_mode = WAL;
10 PRAGMA mmap_size = 134217728;
11 PRAGMA cache_size = 4000;
12 PRAGMA synchronous = NORMAL;
13 PRAGMA foreign_keys = ON;
14 """)
15 return conn