Re:Show HN: Query Google Sheet data using PostgreSQL clients
by snowstormsun on Tuesday May 31, 2022 @04:03AM
(#31567117)
I use it in one project to store public metadata of podcasts. The CI/CD pipeline downloads the google sheet via the public url, does some custom parsing and uses the data to build a react app. Worked like a charm for this use case, some fiddling required to get the parsing done right, though. And there is no api limit if your data is public. For using it as a live read-only database I am not sure if it's a good idea. Generally google sheets has a decent history of versions which makes recovery to an older version possible.
[ Parent
| on HN ]
There are no comments on this comment yet.