ZOYKU火线榜

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