Q: I'll wait for those tutorials on how to connect your tool to my static website before I decide to buy.

Thanks.

rich_daddyMar 9, 2021
Founder Team
dylanroy

dylanroy

May 15, 2024

A: Perfect I appreciate it. In the meantime, the integration will likely be something like this. Keep in mind your key will be shown on the client-side code unless you make the request on the server-side. I am not sure if that is an issue for you. Currently, you can create, and rotate the keys at your own convenience, but I will be working to allow for the restriction of domains in the near future, but that's one thing I wanted to call out before you make the decision to purchase. Below is a sample embed I created using a temporary key, and elements from the demo page (https://www.usesql.com/demo).

<script>
fetch('https://usesql.com/sql?query=SELECT%20a.Symbol%2C%20a.Security%2C%20b.Executive%20%0AFROM%20%22https%3A%2F%2Fen.wikipedia.org%2Fwiki%2FList_of_S%2526P_500_companies%22%20a%20%0AJOIN%20%22https%3A%2F%2Fraw.githubusercontent.com%2Fdylanroy%2Fceo-dataset%2Fmain%2Fdata.csv%22%20b%20ON%20a.Security%20%3D%20b.Company&format=html&key=zJpfI9h8TujjN45cHk1a')
.then(response => response.text())
.then(data => document.getElementById('query-builder').innerHTML = data);
</script>

Share
Helpful?
Log in to join the conversation
Posted: Mar 12, 2021

yo tambien.

Founder
Posted: Mar 19, 2021

I built out the tutorial for the static sites here and will work on getting the videos in place once the initial list of tutorials are completed:
Static Site Tutorial
https://usesql.github.io/tutorials/static-sites/README.html

In addition to seeing the progress on the public roadmap I have made my tutorial code, and content public here:
https://github.com/usesql/tutorials

This will be later rolled into proper documentation site, but I wanted to give a sneak preview.

Founder
Posted: Apr 20, 2021

We have started compiling all documentation pages in one destination. This tutorial can be found here as well:
https://docs.usesql.com/tutorials/integrate-with-your-static-site