Stein

Data

spreadsheet backend api

SHOW HN2019

296points
65comments
#102of 2,195 in 2019
Top 5%of 2019 by points

How HN took it

MixedNo clear lean

6 positive, 14 neutral or asking, 3 mixed, 10 critical, out of 33 comments about the project. Thread score -0.13.

Idea: 4 for, 8 againstExecution: 0 for, 1 againstPerformance: 1 for, 0 againstPrivacy: 1 for, 0 againstDocs: 0 for, 1 against

The thread, comment by comment

Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.

positive neutral or mixed critical about another commenter or something else the maker

What HN said

What people liked

  • Useful for quick internal tools and prototypes

    From 2 comments
    • Unless your company uses GSuite, then this can be a great tool to quickly put together small internal tools.
      sbarre on HN
    • This is what I did for a webpage I made about books I read. Just have to add a row to the sheet to update the page. Also I should read more books.…
      mnky9800n on HN

Objections

  • Dependence on Google Sheets API limits and possible discontinuation

    From 3 comments
    • I'm totally expecting from Google to discontinue, restrict or change the API for Google Sheets at one point. It will likely be in the moment when it's hardest for you to timely…
      miopa on HN
    • Nice side project but risky to consider for commercial product. With google restricting access to its API, it is unreliable to use a free product for commercial purposes.
      geeku on HN
    • I think the idea is solid but the reliance on Google (or other provider) might be the weak point. The cloud may be great but still a gamble if you're totally at the whim of a…
      close04 on HN
  • Sheets has weak database features like constraints and rate limits

    From 2 comments
    • At our company, we use an ETL script to suck all our Google sheets into MySQL then we run queries for reporting. It's pretty nice, we'll probably open source it. The worst part…
      fulldecent2 on HN
    • I have been doing this for a year or so using the python libraries. Created lookup calls etc. The only issue in large sheets is sometimes you get time outs. The setup of the…
      anthony_barker on HN

Requests

  • Support for NextCloud/OwnCloud backends

    From 1 comment
    • Looking at the code, it seems tightly coupled to Google's offerings: just for fun, it'd be nice to have it run against NextCloud/OwnCloud. Sure, if you host those, you might as…
      necovek on HN
  • Clarify read/write and row limits

    From 2 comments
    • 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…
      badestrand on HN
    • - 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…
      shivensinha4 on HN

Questions

  • How are updates synced and how are data types handled

    From 2 comments
    • 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…
      badestrand on HN
    • How is the type handling? Everything is converted to JSON over the API, so it's all just text and numbers.
      onion2k on HN
  • What is the performance and are there user caps

    From 2 comments

Alternatives named

  • Sheetsu and Sheety

    From 1 comment
  • Airtable

    From 2 comments
    • How does this compare to Airtable?
      jonny_eh on HN
    • AT is my go to solution for quick database needs for prototyping. very simple to share “auto created” documentation for external devs to connect via its marvelous api. plus 1200…
      lucasverra on HN
  • Tabletop library with Google Form

    From 1 comment
    • You can do this for free today using open source libraries. https://www.levels.fyi/comp.html used to run entirely on a Google Form + Spreadsheet and still backed by one. Submit…
      Zaheer on HN
  • Glide

    From 1 comment

Category, keywords, summaries and labels on this page were made by AI (Thread Reader v2) and not checked by hand. Each point links to the comments it came from.

Add a badge to your READMEShown on HackerShow
[![Shown on HackerShow](https://hackershow.org/badge.svg)](https://hackershow.org/show/20426682)