News for hackers. Stuff that matters.
Re:Applying programming language research ideas to transform... by gandalfgeek on Saturday January 19, 2019 @11:14PM (#18951015)
Google Sheets has a QUERY function which does exactly this.

https://support.google.com/docs/answer/3093343?hl=en

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...)