gem-hunter

Drizzle ORM + Neon + tRPC + Zod

import { pgTable, serial, text } from "drizzle-orm-pg";
import { createInsertSchema } from "drizzle-zod/pg";
import { z } from "zod";

export const users = pgTable("users", {
  id: serial("id").primaryKey(),
  name: text("name").notNull(),
  email: text("email"),
  projectRole: text<"admin" | "user">("role"),
});

export const apiUser = createInsertSchema(users, {
  projectRole: z.enum(["admin", "user"]),
});

// zod schema for API user creation
export const apiCreateUser = apiUser.omit({ id: true })

npm i

## see https://neon.tech/docs/guides/node/
PGHOST='<endpoint_hostname>:<port>'
PGDATABASE='<dbname>'
PGUSER='<username>'
PGPASSWORD='<password>'
ENDPOINT_ID='<endpoint_id>'

npm run start:server
npm run start:client

npm run generate