Zangqing Backend

Express + PostgreSQL + Socket.IO backend for the haiy.space social app.

Project Layout

.
|-- src/              # application source
|-- scripts/db/       # one-off database maintenance scripts
|-- database/         # schema and seed SQL files
|-- docs/             # deployment and feature notes
|-- Dockerfile
|-- docker-compose.yml
`-- .env.example

Quick Start

1. Copy the environment template:

cp .env.example .env

2. Install dependencies:

npm install

3. Start the server:

npm run dev

Useful Scripts

npm start
npm run dev
npm run db:migrate:ip
npm run db:backfill:ip
npm run db:migrate:collections

Database Files

• database/schema.sql: base schema
• database/seeds/demo.sql: demo seed data
• database/seeds/dense.sql: denser seed data for messages, notifications, and collections
• database/seeds/shop.sql: sample shop items and bundles

Docs

• docs/DEPLOY.md: deployment guide
• docs/FEATURES_MEMBERSHIP_HISTORY.md: JWT, membership, and history notes
• docs/SHOP_API.md: shop backend API
• docs/SHOP_FRONTEND.md: frontend integration guide for shop