database/connection.py at ada6f7ddf74f5000e11973c6f513a6cf15dd6977 · zenfyr.dev/xpost

zenfyr.dev / xpost

social media crossposting tool. 3rd time's the charm

mastodon misskey crossposting bluesky

xpost / database / connection.py

at ada6f7ddf74f5000e11973c6f513a6cf15dd6977 429 B view raw

 1from pathlib import Path
 2import sqlite3
 3
 4def get_conn(db: Path) -> sqlite3.Connection:
 5    conn = sqlite3.connect(db, autocommit=True, check_same_thread=False)
 6    conn.row_factory = sqlite3.Row
 7    _ = conn.executescript("""
 8        PRAGMA journal_mode = WAL;
 9        PRAGMA mmap_size = 134217728;
10        PRAGMA cache_size = 4000;
11        PRAGMA synchronous = NORMAL;
12        PRAGMA foreign_keys = ON;
13    """)
14    return conn