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

zenfyr.dev / xpost

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

mastodon misskey crossposting bluesky

xpost / database / connection.py

at bfd693d6c44da12ad2eb2a2dcaa006f0f938d3c0 430 B view raw

 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