You can query a Sheet with Clickhouse out of the box. Obviously doesn't<p><pre><code> with sheet as (
select \*
from
url('https://docs.google.com/spreadsheets/d/1XGCy0tYU5YcEouO09_ErZIyqjA-VJ4pidLZmMmJkEdk/gviz/tq?tqx=out:csv&sheet=Sheet1&range=A:C', CSVWithNames)
)
select \* from sheet
</code></pre>
<a href="https://luabase.notion.site/Query-a-Google-Sheet-905da4e981ba493eb0292a9a765af317" rel="nofollow">https://luabase.notion.site/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://charlieharrington.com/library/" rel="nofollow">https://charlieharrington.com/library/</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://charlieharrington.com/sql-powered-reading-list/" rel="nofollow">https://charlieharrington.com/sql-powered-reading-list/</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'm a lead on the project, it's focused on read only.<p>1 - <a href="https://steampipe.io" rel="nofollow">https://steampipe.io</a>
2 - <a href="https://hub.steampipe.io/plugins" rel="nofollow">https://hub.steampipe.io/plugins</a>
3 - <a href="https://hub.steampipe.io/plugins/turbot/googlesheets" rel="nofollow">https://hub.steampipe.io/plugins/turbot/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'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.