Blog

> Firebase + MySQL

December 14, 2020

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

Useful Links

Reflection

Firebase

Cloud Firestore

GET /api/items

GET /api/items/:id

POST /api/items/:id

PUT /api/items/:id

DELETE /api/items/:id

MySQL

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