feat: add waitlist signup count

1 files changed, 15 insertions, 0 deletions

diff --git a/apps/web/src/lib/waitlist.ts b/apps/web/src/lib/waitlist.ts
new file mode 100644
index 00000000..c397109d
--- /dev/null
+++ b/apps/web/src/lib/waitlist.ts
@@ -0,0 +1,15 @@
+import { db } from "@/lib/db";

+import { waitlist } from "@/lib/db/schema";

+import { sql } from "drizzle-orm";

+

+export async function getWaitlistCount() {

+  try {

+    const result = await db

+      .select({ count: sql<number>`count(*)` })

+      .from(waitlist);

+    return result[0]?.count || 0;

+  } catch (error) {

+    console.error("Failed to fetch waitlist count:", error);

+    return 0;

+  }

+}