Overview

Project Information
Databases (Firebase, MySQL)

Progress

• Building an API With Firebase (Medium - Instructions)
• Build/Deploy Node.js Rest APIs with Express & MySQL on Heroku (bezKoder - Part 1, Part 2)

Project Links

• Github - Code (Firebase) + Code (MySQL)

Useful Links

• General
  • REST vs CRUD
  • Top Free Database Software
  • SQLite vs MySQL vs PostgreSQL: A Comparison Of Relational Database Management Systems [Source 1] [Source 2]
  • Initializing Heroku with Git
  • http://jsonplaceholder.typicode.com/
  • http://jsonplaceholder.typicode.com/posts/1
• Firebase
  • Firebase Quickstarts for Node.js
• MySQL Setup
  • Download MySQL
  • Setup MySQL
  • Create a Database/Table Tutorial

Reflection

Cloud Firestore

GET /api/items

GET /api/items/:id

POST /api/items/:id

PUT /api/items/:id

DELETE /api/items/:id

https://sabinach-mysql.herokuapp.com/

Terminal Example

Terminal Example

GET /api/customers
(local)

POST /api/customers
(local)

GET /api/customers
(heroku)

POST /api/customers
(heroku)

Scratch Notes

• CRUD are database actions. REST are HTTP Request Protocols. Very often overlap, but they are NOT the same thing!
• Both CRUD/REST commands can work on both local and remote servers.
• Firebase and MongoDB are NoSQL databases, while MySQL/PostgreSQL/SQLite are relational databases.
• Firebase (not free), MongoDB (not free), and SQLite (local-only) are NOT available on Heroku.
• I was unable to ultimately deploy Firebase because it cost $$$, but it works locally!
• Interesting that MySQL runs a server locally vs. SQLite which saves an explicit DB file.
• SQL = Structured Query Language, is domain-specific language used in programming and designed for managing data held in a relational database management system
• Steps for deploying MySQL and PostgreSQL are very similar.
• Transferring from localhost to deployed heroku (for MySQL and PostgreSQL) was not as difficult as I thought it would be...

Future Work

• PostgreSQL
• SQLite
• MongoDB