from Hacker News

Show HN: Use SQL Across Your Google Sheets, APIs, Airtables, and More

by dkroy on 2/25/21, 5:47 PM with 2 comments

• by dkroy on 2/25/21, 5:47 PM

  Hello my fellow HNers, this is the creator here. After continuing to write boilerplate code to connect multiple data sources together I finally decided to take a more platform-driven approach and came up with a way that I could continue to add more integrations in a scalable way. This API is the result of that effort.

  Let me know what you think. I am by no means a copywriting expert so can add videos, and better explanations, but added a demo section here if you want to play around with it: https://www.usesql.com/demo

• by justsomeuser on 2/26/21, 2:40 PM

  Hey Dylan, looks interesting.

  A few questions:

  - What SQL dialect is being used?

  - Does a query execution download all the data from the remote source, and does it cache it for the next run?

  - How do indexes and sub selects work?

  - How does data protection work, does all data pass through your server?