Show HN: Stein – Use Google Sheets as a No-Setup Database • Hacker News Board

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

#1

Post by shivensinha4 » Sat, Jul 13, 2019, 5:45 AM UTC

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

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

#2

Post by jonny_eh » Sat, Jul 13, 2019, 6:32 AM UTC

How does this compare to Airtable?

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

#3

Post by Zaheer » Sat, Jul 13, 2019, 6:48 AM UTC

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 form: https://stackoverflow.com/a/37743080

Get data from sheet: https://github.com/jsoma/tabletop

Happy to answer any questions.

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

#4

Post by lucasverra » Sat, Jul 13, 2019, 6:59 AM UTC

jonny_eh wrote: post #2

How does this compare to Airtable?

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 row free (infinite tables) is good to start

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

#5

Post by shivensinha4 » Sat, Jul 13, 2019, 7:01 AM UTC

Zaheer wrote: post #3

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 form: https://stackoverflow.com/a/37743080 Get data from sheet: https://github.com/jsoma/tabletop Happy to answer any questions.

Stein is completely open-source itself, and the documentation includes instructions for self-hosting. It consolidates all such features in a single API.

Find it at https://github.com/SteinHQ/Stein

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

#6

Post by _Codemonkeyism » Sat, Jul 13, 2019, 7:10 AM UTC

What is the performance of this?

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

#7

Post by Zaheer » Sat, Jul 13, 2019, 7:12 AM UTC

shivensinha4 wrote: post #5

Zaheer wrote: post #3

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 form: https://stackoverflow.com/a/37743080 Get data from sheet: https://github.com/jsoma/tabletop Happy to answer any questions.

Stein is completely open-source itself, and the documentation includes instructions for self-hosting. It consolidates all such features in a single API. Find it at https://github.com/SteinHQ/Stein

One benefit of approach I mentioned is that there's nothing to host. All just client-side code. Although I do see the use for hosting: latency for loading data from Google Sheets isn't great and adding a cache helped in my case.

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

#8

Post by aznpwnzor » Sat, Jul 13, 2019, 7:38 AM UTC

ah like glideapp.io but more cross platform!

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

#9

Post by EmilStenstrom » Sat, Jul 13, 2019, 7:39 AM UTC

_Codemonkeyism wrote: post #6

What is the performance of this?

Data seems to be mirrored to a mongoDB instance on the server where it's served. So my guess is that performance is great.

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

#10

Post by leot » Sat, Jul 13, 2019, 8:24 AM UTC

This is exactly the approach we're using for hackerpet (hackerpet.com)