Tech Stack
Technologies Used
- Express-based REST API with JSON responses.
- PostgreSQL tables for tasks, notes, and tags.
- Input validation and error handling middleware.
- Deployed behind Nginx on an Ubuntu VPS.
Description
I wanted a small, focused project where I could practise building a REST API and writing SQL by hand. This backend lets me create, update, and search tasks and notes with simple filters and tags, and serves as a reusable backend for side projects. It’s intentionally modest in scope but covers routing, validation, migrations, and deployment.
Project Info
What I Implemented
- Designed a small PostgreSQL schema for tasks, notes, tags, and relationships between them.
- Implemented CRUD endpoints in Express with route-level validation and structured error responses.
- Added basic filtering (by status, tag, and search term) and pagination to keep responses predictable.
- Built a minimal HTML/JS admin page for quickly adding and reviewing entries without external tools.
- Containerised or deployed the API to the same Ubuntu VPS used for my portfolio, behind Nginx with HTTPS.
Screenshots / Examples
This area is reserved for example API responses, schema diagrams, or screenshots of the small admin UI backed by this API.