tap/src/drizzle.ts at main · rocksky.app/rocksky

rocksky.app / rocksky

fork atom

A decentralized music tracking and discovery platform built on AT Protocol 🎵 rocksky.app

spotify atproto lastfm musicbrainz scrobbling listenbrainz

fork atom

rocksky / tap / src / drizzle.ts

at main 22 lines 582 B view raw

wrap content

tsiry-sandratraina.com Improve batch flushing and DB pragmas 2mo ago

ffa18956

 1import { drizzle } from "drizzle-orm/libsql";
 2import { createClient } from "@libsql/client";
 3
 4const client = createClient({
 5  url: Deno.env.get("TAP_CACHE_DATABASE_URL") || "file:tap-cache.db",
 6});
 7
 8await client.execute("PRAGMA journal_mode = WAL;");
 9
10await client.execute("PRAGMA busy_timeout = 30000;");
11
12await client.execute("PRAGMA synchronous = NORMAL;");
13
14await client.execute("PRAGMA cache_size = -10000;");
15
16await client.execute("PRAGMA wal_autocheckpoint = 1000;");
17
18await client.execute("PRAGMA temp_store = MEMORY;");
19
20const db = drizzle(client);
21
22export default { db };