Loramel Stock Monorepo

A full-stack monorepo project structured using npm workspaces with React, Express Node.js, TypeScript, PostgreSQL, and MongoDB.

📁 Repository Structure

loramel-stock/
├── package.json               # Root workspaces & script orchestrator
├── tsconfig.json              # Monorepo shared base TypeScript config
├── docker-compose.yml         # Local PostgreSQL & MongoDB container orchestration
│
├── frontend/                  # React 18 + Vite + TypeScript Web Dashboard
│   ├── src/
│   │   ├── App.tsx            # Interactive Status & Data Control Dashboard
│   │   ├── index.css          # Glassmorphism dark mode aesthetic design system
│   │   └── main.tsx
│   ├── vite.config.ts         # Vite server & API proxy (/api -> http://localhost:5001)
│   └── package.json           # Workspace package: @loramel/frontend
│
├── backend/                   # Express + Node.js + TypeScript API Server
│   ├── src/
│   │   ├── index.ts           # Express server entrypoint
│   │   ├── config.ts          # Server & env configuration
│   │   └── routes.ts          # API endpoints for Health, Postgres, & Mongo
│   └── package.json           # Workspace package: @loramel/backend
│
├── database-pg/               # PostgreSQL Database Module
│   ├── schema.sql             # Relational SQL schema & sample data seed
│   ├── src/
│   │   ├── client.ts          # pg Connection Pool & typed query helpers
│   │   └── index.ts           # Module exports
│   └── package.json           # Workspace package: @loramel/database-pg
│
└── database-mongo/            # MongoDB Database Module
    ├── src/
    │   ├── client.ts          # Mongoose connection & logging helpers
    │   ├── models/            # ActivityLog Mongoose schemas & interfaces
    │   └── index.ts           # Module exports
    └── package.json           # Workspace package: @loramel/database-mongo
Copy

🚀 Quick Start

1. Install Dependencies Across Monorepo

npm install
Copy

2. Start PostgreSQL & MongoDB Databases via Docker Compose

npm run db:up
Copy

• PostgreSQL: localhost:5432 (db: loramel_stock_db, user: postgres, pass: postgrespassword)
• MongoDB: localhost:27017 (db: loramel_stock_mongo, user: admin, pass: mongopassword)

3. Build Monorepo Workspace Modules

npm run build
Copy

4. Run Development Servers Concurrently

npm run dev
Copy

• Frontend App: http://localhost:3000
• Backend API: http://localhost:5001

🛠️ Monorepo Commands

🔌 API Endpoints Summary

• GET /api/health: Check system status across Node, PostgreSQL, and MongoDB.
• GET /api/stock: Returns all stock items from PostgreSQL.
• POST /api/stock: Adds a new item to PostgreSQL and logs action to MongoDB.
• GET /api/activity: Returns recent audit/activity logs from MongoDB.
• POST /api/activity: Logs custom activity into MongoDB.