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