feat: production Docker image with health check and data persistence

- Non-root user (node), data volume at /app/data
- Startup migration script applies drizzle SQL before server starts
- HEALTHCHECK on port 3000 every 30s

1 files changed, 22 insertions, 0 deletions

diff --git a/scripts/migrate.js b/scripts/migrate.js
new file mode 100644
index 0000000..dee9411
--- /dev/null
+++ b/scripts/migrate.js
@@ -0,0 +1,22 @@
+import { createClient } from '@libsql/client';
+import { readdirSync, readFileSync } from 'node:fs';
+import { join } from 'node:path';
+
+const dbUrl = process.env.DATABASE_URL ?? 'file:./data/data.db';
+const client = createClient({ url: dbUrl });
+
+const dir = '/app/drizzle';
+const files = readdirSync(dir)
+	.filter((f) => f.endsWith('.sql'))
+	.sort();
+
+for (const file of files) {
+	const sql = readFileSync(join(dir, file), 'utf8');
+	const stmts = sql.split('--> statement-breakpoint').filter(Boolean);
+	for (const stmt of stmts) {
+		await client.execute(stmt);
+	}
+}
+
+console.log(`${files.length} migration(s) applied.`);
+client.close();