Re:Applying programming language research ideas to transform...
by samanator on Sunday January 20, 2019 @01:53AM
(#18951576)
This works for one offs. But performance is non-existent when you try to mock up google sheets as a database. I'm in the process of switching a company from google sheets + google sheets query to postgres. Loading one of their google sheets takes around 60 seconds. If they move around one of their 'id' columns it takes 5-10 minutes for everything to recalculate (also keep in mind that google offloads the computations onto the user's CPU...)
https://support.google.com/docs/answer/3093343?hl=en