Show HN: Query Google Sheet data using PostgreSQL clients

You can query a Sheet with Clickhouse out of the box. Obviously doesn&#x27;t<p><pre><code> with sheet as ( select \* from url(&#x27;https:&#x2F;&#x2F;docs.google.com&#x2F;spreadsheets&#x2F;d&#x2F;1XGCy0tYU5YcEouO09_ErZIyqjA-VJ4pidLZmMmJkEdk&#x2F;gviz&#x2F;tq?tqx=out:csv&amp;sheet=Sheet1&amp;range=A:C&#x27;, CSVWithNames) ) select \* from sheet </code></pre> <a href="https:&#x2F;&#x2F;luabase.notion.site&#x2F;Query-a-Google-Sheet-905da4e981ba493eb0292a9a765af317" rel="nofollow">https:&#x2F;&#x2F;luabase.notion.site&#x2F;Query-a-Google-Sheet-905da4e981b...</a>

I use roapi to power my “book list” on my static site. I have it running on an always-on Replit repl. Try it here:<p><a href="https:&#x2F;&#x2F;charlieharrington.com&#x2F;library&#x2F;" rel="nofollow">https:&#x2F;&#x2F;charlieharrington.com&#x2F;library&#x2F;</a><p>Click the “I’m feeling lazy” button if you just want to see some example queries.<p>I also wrote a tutorial, as well, if you’d like to try out roapi yourself:<p><a href="https:&#x2F;&#x2F;charlieharrington.com&#x2F;sql-powered-reading-list&#x2F;" rel="nofollow">https:&#x2F;&#x2F;charlieharrington.com&#x2F;sql-powered-reading-list&#x2F;</a>

I spent years using Excel but I mostly use Google Sheets now. The cloud integration just feels much more effortless compared to Microsoft’s Office products ported to cloud. I’ve seen departments using GS as a system of record for quickly setting up master data like budgets and forecasts. I wish it had database connectivity the way Excel has ODBC.

Steampipe [1] is an open source Postgres Foreign Data Wrapper with 73 plugins [2] including Google Sheets support [3]. A lot of our users use it to connect custom metadata with other systems - e.g. join ownership info in Google Sheets with tags on AWS resources. Notes: I&#x27;m a lead on the project, it&#x27;s focused on read only.<p>1 - <a href="https:&#x2F;&#x2F;steampipe.io" rel="nofollow">https:&#x2F;&#x2F;steampipe.io</a> 2 - <a href="https:&#x2F;&#x2F;hub.steampipe.io&#x2F;plugins" rel="nofollow">https:&#x2F;&#x2F;hub.steampipe.io&#x2F;plugins</a> 3 - <a href="https:&#x2F;&#x2F;hub.steampipe.io&#x2F;plugins&#x2F;turbot&#x2F;googlesheets" rel="nofollow">https:&#x2F;&#x2F;hub.steampipe.io&#x2F;plugins&#x2F;turbot&#x2F;googlesheets</a>

Last time I tried to do the moral equivalent of this (not using SQL, just some custom python), I ran afoul of the rate limits really quickly.<p>Does this client do something smart to mitigate that, have the limits been relaxed, or is it still a problem?

I have thought about using google sheets as the database for projects many times.<p>The great thing about it is that you get a very versatile admin UI for free. The downsides however are rate limits and the fact that I can&#x27;t think of any way to build in some sort of safety that would prevent people from accidentally deleting a bunch of data with a mouse click. I would love to hear if anyone has real life experience with the approach.

This is cool; from reading the descriptions I presume this doesn&#x27;t support writing - is there any intention to do so?

Using this with materialized views could be very useful!