A full-stack Express + PostgreSQL (Neon) bookstore inventory application featuring CRUD, image uploads, search, sorting, filtering, and clean server-rendered views using EJS + Tailwind CSS.

Built as part of The Odin Project, but structured like a production-grade MVC application.

Render: https://chapterhub-inventory.onrender.com/

Go to Live demo Section to see more pages - Error 500 Page, Edit Genre Page , Delete Book Page

• Create, edit, delete books
• Upload cover images (Multer)
• Metadata support: title, author, year, description
• Additional fields: price, quantity
• Filename hashing using crypto
• Full validation with express-validator

• Create, edit, delete genres
• Name + description fields
• Prevent duplicates using DB constraints
• Genre dropdown in book forms

• Search books by title
• Filter books by one or multiple genres
• Sort options:
  • Title (A–Z / Z–A)
  • Year (Oldest / Newest)
  • Price (Low → High / High → Low)

• PostgreSQL hosted on Neon
• Parameterized SQL queries (SQL injection safe)
• Modular queries for books & genres
• Seed script includes:
  • Schema generation
  • Sample genres & books
  • --reset mode
  • Index creation for genres

• Tailwind CSS v4
• Modern, minimal, responsive UI
• Clean EJS templates

• Node.js
• Express 5
• Express Validator
• Multer (image uploads)
• PostgreSQL (Neon)

• EJS
• Tailwind CSS 4
• Vanilla JavaScript

• Nodemon
• Concurrently
• pnpm
• dotenv

chapterhub-inventory/
│
├─ app.js
├─ package.json
├─ nodemon.json
│
├─ db/
│   ├─ seed.js
│   ├─ pool.js
│   ├─ data/
│   │    ├─ books.js
│   │    └─ genres.js
│   └─ queries/
│        ├─ books.js
│        └─ genres.js
│
├─ controllers/
│   ├─ booksController.js
│   └─ genresController.js
│
├─ routes/
│   ├─ booksRouter.js
│   ├─ genresRouter.js
│   └─ indexRouter.js
│
├─ validators/
│   ├─ booksValidators.js
│   └─ genresValidators.js
│
├─ middlewares/
│   ├─ upload.js
│   └─ setLocals.js
│
├─ views/
│
└─ public/

📌 Index:

CREATE INDEX idx_books_genre_id ON books(genre_id);

git clone https://github.com/devxsameer/chapterhub-inventory.git
cd chapterhub-inventory

pnpm install

DATABASE_URL=your_neon_connection_string
PORT=6969

Fresh reset:

pnpm seed:reset

Normal seed:

pnpm seed

pnpm dev

pnpm css:build

pnpm start

Server runs at:

http://localhost:6969

• Uploads stored in: public/uploads/
• Uses Multer disk storage
• Accepts: .jpg, .jpeg, .png, .webp
• Max file size: 5MB
• Unique filenames using crypto.randomBytes

Sameer Ali
Full-stack developer & Odin Project learner.

MIT License — free to modify & share.