DEV Community

Discussion on: Using Google Sheets as a Database: 3 Ways to Connect the API to Node.js

Collapse
 
devpato profile image
Pato

I remember when I was in college for my Software Engineer class we had to create a Ebay replica and you will get extra points if you used Google Sheets as a DB. We were the only team that did, which it was awesome but Google Sheets was to extremely slow :( but hey! it was fun to learn.

Also I have been several years in the industry and I have never heard of anyone using Google Sheets as a database in a production application. Could you provide me some example of companies or apps that use it in production? I want to do research on how they did it and why, would be super interesting to see if I can apply it to a future project :)

A few questions:
Is there a reason why you are mixing var and const?
Is there a reason why you are mixing fat arrow function vs normal function?

Thanks so much for the post. Keep the good work!

Collapse
 
stephsmithio profile image
Steph Smith

I don't think many production applications use it as a database to be honest. I'm sure there are, but I'm not familiar with which ones!

One thing I've been thinking about is actually using Google Sheets as a database, but then running cron jobs to "save" the info into a more traditional database, to improve with speed.

As for your questions, I really shouldn't be mixing the functions and var/const. I typically write normal functions, so anything you see that's a normal function was probably code written by me. In a few cases, the arrow functions were probably the snippet code copied from Google's API docs. :)