My goal is to create tables during the database initialization stage with a structure like this:
CREATE TABLE IF NOT EXISTS users (
"id" SERIAL PRIMARY KEY,
"created_at" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
"name" TEXT NOT NULL,
)
Ordinarily, setting this up in a standard server environment would be straightforward (even in an async setup), but Nextjs lacks a centralized "init" stage. I have devised the following workaround so far:
import { setupTables } from "./tables";
import { getDBSingleton } from "./init";
let isInitialized = false;
export async function getDB() {
const scope = getDBSingleton();
if (!isInitialized) {
await setupTables(scope.db);
isInitialized = true;
}
return scope;
}
The getDBSingleton() function I am using is based on this response:
Where should I initialize pg-promise
While this workaround functions as intended, it necessitates calling await getDB() within every single function that interacts with the database, rather than just once per module.
Is there a more efficient way to handle this?