College project · Sole architecture and implementation · Live deployment · Public source
JRKC Bookstore
An end-to-end bookstore system I selected from professor-provided options and delivered during a five-week Colorado Technical University course.
The course used group assignments, but I completed the architecture, application design, implementation, database, testing, documentation, CI/CD, and Oracle deployment. It was the course's working end-to-end bookstore application rather than a demonstration or concept submission.
Technology
- Next.js
- React
- TypeScript
- PostgreSQL
- Drizzle ORM
- Docker
- Stripe

- Constraint and context
A five-week college assignment required a working bookstore, but the original hosted database became unavailable and the public deployment had to coexist safely with other Docker workloads on one Oracle host.
- Implemented approach
- I replaced the unavailable hosted data dependency with application-owned PostgreSQL and typed Drizzle access
- I containerized the application and database as an isolated Compose project with persistent storage and an explicit Oracle host port
- Engineering decisions and tradeoffs
- I replaced the unavailable paid hosted backend with application-owned authentication and typed Drizzle routes so identity and PostgreSQL access remain under the application's control
- I isolated the bookstore in its own Docker Compose project, private database network, named volume, and explicit Oracle port so it cannot collide with other workloads
- Resulting capability
- I deployed the catalog, account, cart, and bookstore workflows against persistent PostgreSQL data on Oracle Cloud
- I preserved database records across application replacement through a named volume scoped to the bookstore Compose project


