DEV Community

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

Collapse
 
bhupesh profile image
Bhupesh Varshney 👾

Nice 👌 idea
But wouldn't it be difficult when you want to create some complex relationship like foreign keys and etc
🤔🤔

Collapse
 
stephsmithio profile image
Steph Smith

I definitely think there are cases where you can't utilize Google Sheets as a DB, but I think it's good for MVPs and collaborative projects where multiple people need access to view/change the data easily. 🙂

Collapse
 
devpato profile image
Pato

uhmm interesting. I don't really think that happens in a real app production app. Not everyone should be touching the database, specially if you only have one version and can't give roles to it which I believe that the case for Google Sheets. If you want to use a database just to view/change data might as well use a normal sql database and use app to view it in a table grid form like MySQL workbench does. This app will give you a similar feeling to Google Sheets via displaying the data in a grid.