Don't sleep on Google Sheets for backend infra!
For analytics on Timestamps usage I log directly into a Google Sheet😂
And this actually works great! Minimal infra, structured, fast (no querying GBs of server logs), and I can manually touch up the data (needed for the user column).
Don't sleep on Google Sheets for backend infra🤪
Trending on Indie Hackers
Haha, agreed! I just launched Opsgrid, which uses Google Sheets for free server monitoring data retention. It's stretching things a bit - I can store about a year's worth of per-minute metrics at a width of 10 columns - but so far it's been working fairly well.
Cool to hear!
Google Sheets are awesome as an interface. Which is why so many things are poping up around using Google sheets as a core component. Sheets to Site/Api/Ecom page etc etc
I use Google sheets for a project
The only complaint I have is that the API sometimes of not reachable
Does google offer an option to expose sheet data through an api or do you use a third party service specifically for that?
There’s an Api, and you should be able to find a lib for your language
I was actually thinking of using Sheets for a small side project! Wanted to modernize this hard-to-navigate directory of real estate tech companies (https://www.cretech.com/directory/company?page=1&sortField=company_name&sortBy=true&companyids=&searchFields=0) by scraping the contents and using Airtable as a simple database for my own directory, would you recommend Sheets instead?
@AndrewKamphey? Would you recommend Airtable 😜
I would recommend trying sheets.
Can't comment on Airtable, but sheets has worked well for me, though I'm not exactly using it as a database. I have heard of others using it as a simple db though (including Patrick Mckenzie).
Yeah, it's nice for some use cases - but be aware of the limits.