SQL Library Manager

A full stack project I built for my portfolio during my studies at Treehouse. In this project, I built a web application that includes pages to list, add, update and delete books. I was given HTML designs and an existing SQLite database. I was required to implement a dynamic website using JavaScript, NodeJS, Express, Pug, SQLite and the SQL ORM Sequelize.

Table of Contents

• Preview
• Quick Start
• Overview
• Built With
• Thanks

Preview

Quick Start

The easiest way to view the app is by clicking here.

Note: To deploy the project to Heroku I had to convert the database from SQLite to PostgreSQL. If I had not done so, the entire SQLite database would have been deleted at least once every 24 hours. You can read more about this issue here. Beyond that, the app works on Heroku just as it works locally.

If you still wish to run this app locally on your machine, you'll have to -

• Download the ZIP file, extract it and open the project folder in your favorite code editor.
• Open the terminal and run the commands npm i and npm start.
• Leave your code editor open and visit localhost:3000 in your browser.

Overview

As mentioned above, I developed this app as part of my studies at Treehouse. I participated in their Techdegree program. In this section you can read about -

• The topics I learned before I started developing the app.
• The requirements I had to meet to complete this project.
• The rating the project received.

What Did I Learn?

Here is what I learned before I started working on the project -

• SQL Basics
• Modifying Data with SQL
• Asynchronous Code in Express
• Using SQL ORMs with NodeJS

I also learned how to use Sequelize ORM specifically with Express.

Project Requirements

You can view the project requirements here.

Rating

There are two possible grades for each Techdegree project - "Meets Expectations" and "Exceeds Expectations".

This project received the "Exceeds Expectations" rating.

See the full project review here.

💯

Built With

• CSS
• JavaScript
• NodeJS
• Express
• Pug
• SQLite
• Sequelize

Thanks

Thanks to Treehouse for providing the starter CSS file for this project (styles.css).

Note: In this project I built all the pages from scratch, based on the mock up files that were given to me.

In addition, a huge thank you to everyone who reviewed the project! 😀