Laura Coronel

SQL Library Manager

In this project I have been tasked with creating an application for a fictional library to help them manage their collection of books. Given HTML designs and an existing SQLite database I implemented a dynamic website using JavaScript, Node.js, Express, Pug, SQLite and the SQL ORM Sequelize. I built a web application that includes pages to: list, add, update, and delete books in the SQLite database. The database contained validation to ensure the data provided by the user is consistent and useful.

The biggest challenge I faced was implementing search and pagination with a database. It required a good bit of investigation but finally found my answers after digging through the Sequelize documentation.

Image of Project #8Image of Project #8Image of Project #8Image of Project #8