Ask HN: Using Google Sheets as Database?

4 points·thescribbblr··6 comments

What 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.

I need to use it as a database solution for a small grocery delivery ecommerce service in my area.

Then 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.

Is there any solution to maintain product listing via spreadsheet or something similar.

Elaborate 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. Sheets are not databases. Be prepared to hit one the issues like this.

I need to use it as a database solution for a small grocery delivery ecommerce service in my area.

Reply on news.ycombinator.com