OpenCMS Database

Built a system that helps to convert a static website into a dynamic one. Created an MVP with a CLI-based interface to demonstrate the working. The main focus was to keep less dependency between frontend and backend.

Considered performance aspects as well while designing the database schema and using MySQL as the database. Used triggers and procedures to enforce the validation of the incoming data and functions to ease the data retrieval queries.