ZOYKUHot Board

jatindotdev/express-drizzle-postgres-starter기술 문서

A opinionated starter template for building REST APIs with Express, Drizzle ORM and PostgreSQL.

언어 대체 안내:해당 저장소의 한국어 문서가 제공되지 않아 공식 영문 원본(English)으로 표시됩니다.
npm i express-drizzle-postgres-starter

Express-Drizzle-PostgreSQL-Starter

A opinionated starter template for building REST APIs with Express, Drizzle ORM and PostgreSQL.

Features

  • User registration
  • User verification via email
  • User deletion
  • Admin routes

API Documentation

GET /user

Returns the user. Requires AUTH_TOKEN in the request header.

PUT /user/update

Updates the user. Requires AUTH_TOKEN in the request header.

User can only update themselves. Properties that can be updated are name, email and password.

if email is updated, the user will be unverified and a new verification email will be sent.

POST /user/create

Creates a new user. Requires name, email and password in the request body.

GET /user/verify

Verifies the user. Requires token and email in the query string.

DELETE /user/remove

Removes the user. Requires AUTH_TOKEN in the request header.

A user can only remove themselves. A admin can remove any user.

POST /user/login

Logs in the user. Requires email and password in the request body.

GET /admin/all-users

Returns all users. It is an admin route, requires AUTH_TOKEN.

GET /admin/all-verfied-users

Returns all verified users. It is an admin route, requires AUTH_TOKEN.

DELETE /admin/remove-unverified-users

Removes all unverified users. It is an admin route, requires AUTH_TOKEN.

Running the app

Install the dependencies

pnpm install

Run the development server:

pnpm dev

Built with

GitHub 공식 원본 저장소에서 아카이브된 문서 미러 · GitHub 저장소 방문
동기화 기준일: 2026-11-08