Show HN: Generate beautiful list sites from your spreadsheets

Re:Show HN: Generate beautiful list sites from your spreadsh... by jon49 on Friday June 08, 2018 @04:40PM (#17269485)

Pretty neat. I'm assuming you cache the results from the google sheet and update them when the google sheet is updated?

Another idea. Would be to have a "under maintenance" flag you could mark in the google sheet and then only the updates would happen on a secondary test site. When you are satisfied with the results you can change the flag to go live.

[ Parent | on HN ]

Re:Show HN: Generate beautiful list sites from your spreadsh... by azarai on Saturday June 09, 2018 @08:02AM (#17272609)

Thanks for the feedback.

The initial version did not cache indeed. On each request, the Google Sheet API was hit. I changed that with today's release and the sheet is cached (shared cache). To update the site, just append ?refresh=true to the URL.

I like your idea of a kind of staging system. Have to think about how to solve that.

[ Parent | on HN ]