Full Stack
Dublin Pub Inventory
A personal project to manage a complete inventory of Dublin pubs, including drinks and events, with secure admin authentication for destructive actions.
Overview
About the project
Dublin Pub Inventory is a full-stack project designed to practise backend and frontend development. Users can browse, search, create, and delete records of pubs, drinks, and events, with admin authentication required for destructive actions.
The project combines database relationships, server-rendered views, and practical CRUD operations around realistic inventory data.
What it includes
Key features
- Manage pubs, drinks, events, and categories with relational PostgreSQL data
- Use RESTful CRUD routes for creating, updating, viewing, and deleting records
- Search inventory records quickly
- Protect destructive actions with admin authentication
- Render dynamic pages with EJS
- Populate the app with realistic Dublin pub seed data
Stack
Technologies used
- Node.js
- Express
- PostgreSQL
- EJS
- CSS
Process
Decision Log
Practising full-stack CRUD with real entities
The project uses pubs, drinks and events as realistic data models to practise relational full-stack development.
Server-rendered views with EJS
EJS was used to generate dynamic pages while keeping the stack simpler and focused on backend fundamentals.
Admin protection for sensitive actions
Authentication was added to secure destructive operations like deleting records.
Database-driven organisation
PostgreSQL relationships and seed data make the application more structured and closer to a real inventory system.
Continue exploring
More Projects
Project
Full-Stack House Organizer Application
Housemates is a full-stack web application designed to help people organise, manage and access everything in a shared house.
Project
Next.js Full-Stack Blog
A full-stack blog built with Next.js. Users can read, like, save, and comment on posts, and signed-up users can create, edit, or delete their own posts.
Project
The Solar System 2
An interactive project displaying information about celestial bodies in the solar system. Fully developed from scratch with a custom API and interactive animations.