4 ms·
Ask HN: Using Google Sheets as Database?
- gls2ro 6y agoWhat are your use cases for this? Who/What will consume it? I did not used Google Sheet as Database and I dont see it as a good option for connecting to it via a programming language when taking into consideration any RDBMS or NoSQL if that is needed. I recommend either PostgreSQL or MongoDB or Cassandra.
- thescribbblr 6y agoI need to use it as a database solution for a small grocery delivery ecommerce service in my area.
- gls2ro 6y agoThen my recommendation is to use a relational database. You will want to have relations between your concepts like: An Account has multiple shopping Carts. Some Shopping Carts will transform in Orders. Both Carts and Shopping Carts will have many items/products. ... So you will need to have one to many or many to many relations. It is easier to do it with relational database in my own opinion. I prefer to use PostgreSQL. It is easy to install and works great for majority of cases. But you can also use MySQL. It will get the job done. Both are well supported in most programming languages. I
- thescribbblr 6y agoIs there any solution to maintain product listing via spreadsheet or something similar.
- ishcheklein 6y agoElaborate on the use case? Why Google Sheets specifically, not some online simple DB with a rest API? It reminded me this - https://www.bbc.com/news/technology-54423988 https://www.bbc.com/news/technology-54423988. Sheets are not databases. Be prepared to hit one the issues like this.
- thescribbblr 6y agoI need to use it as a database solution for a small grocery delivery ecommerce service in my area.