A Node.js Express service for handling ownership transfers with PostgreSQL database.
- Express.js REST API
- PostgreSQL database integration
- Authorization with access key
- Health check endpoint
- Docker support
- Development with hot reload
- Node.js 18+
- PostgreSQL 15+
- Docker & Docker Compose (optional)
-
Copy environment file:
cp .env.example .env
-
Start services:
pnpm docker:dev
-
View logs:
pnpm docker:logs
-
Stop services:
pnpm docker:down
-
Install dependencies:
pnpm install
-
Setup environment:
cp .env.example .env # Edit .env with your database configuration -
Setup database (run init.sql in your PostgreSQL database)
-
Start server:
pnpm dev
Transfer ownership to target email.
Headers:
Authorization-Access-Key: your-secret-access-key
Body:
{
"targetEmail": "[email protected]"
}Response:
{
"success": true
}Health check endpoint.
Response:
{
"status": "healthy",
"database": { "success": true, "time": "2023-..." },
"timestamp": "2023-..."
}# Build Docker image
pnpm docker:build
# Run Docker container
pnpm docker:run
# Development with Docker Compose
pnpm docker:dev
# Stop Docker Compose
pnpm docker:down
# View logs
pnpm docker:logsPORT- Server port (default: 9009)CONNECTION_URL- PostgreSQL connection stringAUTHORIZATION_ACCESS_KEY- API access keyNODE_ENV- Environment (development/production)
users- User accounts with emailassets- Assets with ownershipownership_transfers- Transfer history
pnpm start- Start production serverpnpm dev- Start development server with hot reloadpnpm docker:dev- Start with Docker Composepnpm docker:down- Stop Docker Compose services
ISC