import sqlite3
from pathlib import Path


def get_conn(db: Path) -> sqlite3.Connection:
    conn = sqlite3.connect(db, autocommit=True, check_same_thread=False)
    conn.row_factory = sqlite3.Row
    _ = conn.executescript("""
        PRAGMA journal_mode = WAL;
        PRAGMA mmap_size = 134217728;
        PRAGMA cache_size = 4000;
        PRAGMA synchronous = NORMAL;
        PRAGMA foreign_keys = ON;
    """)
    return conn