Something went wrong. Try again.
[READ-ONLY] Mirror of https://github.com/danielroe/nuxt.fyi. Celebrating sites built with Nuxt in the wild. nuxt.fyi
Something went wrong. Try again.
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273import { DatabaseSync } from 'node:sqlite'import { existsSync } from 'node:fs'import { resolve, join } from 'node:path'import { createError, useRuntimeConfig } from 'nuxt/server'
let cached: DatabaseSync | null = nulllet loggedPath = false
function dbPath(): string { return join(resolve(useRuntimeConfig().dataDir), 'nuxt-fyi.db')}
/** * Opens the daemon's SQLite database read-only. Cached for the process lifetime; safe * across concurrent Nitro request handlers because WAL mode lets readers proceed without * blocking each other or the writer. */export function getDb(): DatabaseSync { if (cached) return cached const path = dbPath() if (!loggedPath) { console.log(`[dashboard] sqlite path: ${path}`) loggedPath = true } if (!existsSync(path)) { throw createError({ status: 503, statusText: 'Service Unavailable', message: `daemon database not yet available at ${path}`, }) } cached = new DatabaseSync(path, { readOnly: true }) return cached}
export interface ScanRow { domain: string scanned_at: number is_nuxt: number nuxt_version: string | null confidence: number signals: string final_url: string | null title: string | null og_image: string | null screenshot_key: string | null og_image_key: string | null nsfw_label: 'safe' | 'suggestive' | 'nsfw' | null nsfw_score: number | null nsfw_categories: string | null nsfw_classified_at: number | null redirected_to: string | null error: string | null outcome: 'ok' | 'blocked' | 'error' | null block_signal: string | null http_status: number | null hosting_platform: string | null hosting_cdn: string | null}
export interface DomainRow { domain: string first_seen_at: number last_seen_at: number seen_count: number}
export interface NotificationRow { domain: string channel: string posted_at: number}