Show HN: Stein – Use Google Sheets as a No-Setup Database

Re:Show HN: Stein – Use Google Sheets as a No-Setup Database by badestrand on Saturday July 13, 2019 @08:48AM (#20427793)

Looks neat! Questions:

- Do updates show immediately (for both directions)?

- What are the limits of read/write queries?

- What are the limits of rows?

- Can I use formulas in the sheet?

- How is the type handling? Does everything get treated as text or are there date and number types?

- Do formatting options for columns (e.g. for number of decimals) survive when I alter things with the API?

[ Parent | on HN ]

Re:Show HN: Stein – Use Google Sheets as a No-Setup Database by shivensinha4 on Sunday July 14, 2019 @01:33AM (#20431834)

- Do updates show immediately (for both directions)?

Yes, changes are apparent immediately.

- What are the limits of read/write queries?

The details are mentioned on https://steinhq.com/pricing.

- What are the limits of rows?

Details available on the pricing page as well. A thing not explicitly mentioned is that you can add any number of rows to a sheet. In append operations, the row limit is not checked.

I'll let you know the other details soon. That's something many have been asking, and I'm deciding what the default behavior should be.

[ Parent | on HN ]

Re:Show HN: Stein – Use Google Sheets as a No-Setup Database by onion2k on Saturday July 13, 2019 @09:52AM (#20428054)

How is the type handling?

Everything is converted to JSON over the API, so it's all just text and numbers.

[ Parent | on HN ]

Re:Show HN: Stein – Use Google Sheets as a No-Setup Database by eagsalazar2 on Saturday July 13, 2019 @10:38AM (#20428253)

All the same questions, would love to hear answers to other questions here...

[ Parent | on HN ]