Create devenv for PG. Add drizzle.
Change-Id: If322ee9ef1c290465e93bd7140eadfc90ee2d30d
Reviewed-on: https://git.clicks.codes/c/Caramels/Lotting/+/343
Reviewed-by: Samuel Shuert <coded@clicks.codes>
Tested-by: Samuel Shuert <coded@clicks.codes>
diff --git a/lib/db.ts b/lib/db.ts
new file mode 100644
index 0000000..310cb08
--- /dev/null
+++ b/lib/db.ts
@@ -0,0 +1,13 @@
+import { drizzle } from "drizzle-orm/postgres-js";
+import { migrate } from "drizzle-orm/postgres-js/migrator";
+import postgres from "postgres";
+
+const sql = postgres("...", { max: 1 })
+const db = drizzle(sql);
+
+(async () => {
+ await migrate(db, { migrationsFolder: "drizzle" });
+ await sql.end();
+})();
+
+export { db }
\ No newline at end of file