UseSQL Questions

Log in to ask a question
Showing 21 - 40 of 42 questions

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
See detail
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?

Q: I'm curious as to how the HTML output works.

Where do I set the style, in UseSQL end or on my website? I'm looking forward to seeing the tutorial.

rob_santosMar 14, 2021
See detail
Founder Team
dylanroy

dylanroy

May 15, 2024

A: Hey Rob, this will be done using the parent elements from the static website. I have added a short tutorial and some sample code to a short tutorial here:
https://docs.usesql.com/tutorials/integrate-with-your-static-site#step-4-style-your-table-optional

Share
Helpful?

Q: I have been watching this product for a while now, and I am still very interested in buying it and investing money.

If I understand it correctly stacking is now possible? It would be nice to clarify this in a short pined post. It would also be important to know if there is a bonus for 3 or 5 codes for example. It would be a dream if from a certain number of codes unlimited requests could be offered or at least a multiple than if only one or 2 codes are bought. If unlimited is not possible, it would be sales-promoting to introduce a monthly subscription with discount for the extension of the requests for those who need more now or later.
The product is really very interesting and I see a multiple benefit in the most different ideas and uses. It would certainly also be sales-promoting to publish more use cases or demos to simplify the purchase decision for many.

_SebastianB_PLUSApr 2, 2021
See detail
Share
Helpful?

Q: Any plans for stacking codes?

epitomiPLUSMar 6, 2021
See detail
Founder Team
dylanroy

dylanroy

May 14, 2024

A: Hello,

There's been a lot of requests for us to up the request limit for the lifetime plans. This may be a candidate to look into to enable higher request limits for our LTD users. Would this be something you are interested in?

Thanks,

Dylan

Share
Helpful?

Q: Hello Sumo-Lings!

This is Dylan, the creator of UseSQL!

I started creating UseSQL to scratch my own itch really as it’s a lot easier to iterate without the need to spin up a database as I develop products. UseSQL was really initially something that I used for myself but decided to release it to the world to see if there was interest in using this product outside of my needs. This evolution of the project has resulted in gaps in the documentation so if your use case is incomplete or not listed please reach out, and that will help guide building this archive, as at this point this has transitioned from my product to our product.

There are a number of questions and suggestions that commonly get asked so I will continue to add those to the FAQs and my forecasted focus.

Initial Roadmap Items
➡️ Complete a user sandbox to help users develop their queries.
➡️ Complete the tutorials requested here by my customers.
➡️ Add support for code stacking so that the 50k limit can be raised for the LTD.

View more on the public roadmap here: https://github.com/usesql/roadmap/projects/1

Submit your own ideas or vote for others here: https://github.com/usesql/roadmap/issues

FAQs

❓ Where can I find more information about this product?
More information can be found at, https://www.usesql.com, and we even have a demo that may be worth taking a look at here with a few examples you can see results for, https://www.usesql.com/demo.

❓ How can I find more information on how to use this product for my use case?
You can find this information at https://docs.usesql.com/ or if the use case you have isn’t there or incomplete please raise this here or send an email our way.

❓ How is this different from other offerings such as SpreadSimple?
This offering allows users to query more sources than just Google Sheets such as Airtable. It also allows you to use SQL to join multiple sources, and return results like the following example:
https://www.usesql.com/demo

❓ How can I stay up to date on a feature that I am waiting for?
You can either click Notifications or Watch on the top right of our public roadmap or follow our updates on the facebook page here: https://www.usesql.com/facebook

Cheers!
Dylan

dylanroyMar 11, 2021
See detail
Share
Helpful?

Q: Hi Dylan, this might be a really interesting product, but I guess 90%+ people, including myself, are having ...

a problem fully grasp its potential. When I read your headline "Skip Spinning Up A Database Use SQL across your CSVs, Google Sheets, APIs, Airtables, and more!" it's clearly geared toward a highly technical audience. Maybe it is how you intended it, but if you can bring it closer to a broader audience through the presentation of useful applications, as well as friendly UI, I am sure your sales will multiply several times.

Good luck with your launch.

Andrew_RPLUSMar 9, 2021
See detail
Founder Team
dylanroy

dylanroy

May 15, 2024

A: I am taking this advice to heart as I see how I can do this through the quick addition of a SQL Sandbox geared towards a wider audience while ask contributing to the missing tutorials that others have asked for.

E.g. If a user wants to use this product to show a table in their static website using a Google Sheet. The same for more complex examples where a user wants to surface a table from data across a Google Sheet and an Airtable with some calculated values, this value can be surfaced in sample data sources via a single click into an interface such as the demo interface.

Among that action item I can reposition the value proposition for the AppSumo crowd to make it more obvious.

Share
Helpful?

Q: Could you give some information on which queries are possible?

I tried for example the following to get the "Gurus" that have a return that is higher than 10%. But I get an valldiation error. The same if I use order by.

SELECT Guru, Rendement from "https://www.guruwatch.nl/gurus/default.aspx" where Rendement>10

So what SQL queries are possible with UseSQL?

EZnlMar 8, 2021
See detail
Founder Team
dylanroy

dylanroy

May 14, 2024

A: Hello EZnl,

You should be able to use the full SQL syntax offered by a database provider such as SQLite. I updated the query to work as I think you intended by having the where clause cast the Rendement value to a FLOAT. Still not sure if this is the most correct way to do it, but feel free to use SQLite's documentation in the meantime to see what you can do.

SELECT Guru, Rendement from "https://www.guruwatch.nl/gurus/default.aspx"
WHERE Rendement*1.0 > 10.0

Thanks,

Dylan

Share
Helpful?

Q: I am very interested in this product.

Unfortunately, I do not have the possibility to assess my needs. For this reason, I hope that there will soon be a possibility to buy several codes and combine them. Please forgive my lack of expertise. The following questions arise for me:
1. are the data additionally stored somewhere? Or are they only available in the source and the destination? If the data is cached, how will it be secured?
2. how is the consumption calculated and can this be seen on the website? An example for understanding would be very nice.
3. if the data changes in the source, is it possible to automatically update the target display of the data? If so, can the interval be set and how is this calculated on the requests?
As I said I will like to buy several codes as I see a lot of potential but at the moment I feel the amount of requests is too little.

_SebastianB_PLUSMar 9, 2021
See detail
Founder Team
dylanroy

dylanroy

May 15, 2024

A: Hey Sebastian! I will do my best to get these answered below:

1. are the data additionally stored somewhere? Or are they only available in the source and the destination? If the data is cached, how will it be secured?

The data is stored in memory for the life of the query so should only be available at the source, and destination. While in transit it is encrypted using HTTPS/TLS.

2. how is the consumption calculated and can this be seen on the website? An example for understanding would be very nice.

Right now we have a soft limit so we don't cut off access for going over the limit initially. Eventually, the limits will be made available in the dashboard, and the API. Once visible the request limit will be more strictly enforced. The user will either have the option to have a payment method on file to pay for additional results.

3. if the data changes in the source, is it possible to automatically update the target display of the data? If so, can the interval be set and how is this calculated on the requests?

Right now nothing is cached so if the data changes in the source the target display data will be updated when the page is refreshed. There are plans to add caching in the future, but currently, the target data will always be the latest unless you use a caching mechanism on your end such as CloudFlare.

As I said I would like to buy several codes as I see a lot of potential but at the moment I feel the amount of requests is too little.

Yeah, I am working with AppSumo to support this. I am almost done streamlining the redeeming of these stacked codes, and then just need the deal posted to be updated to reflect this.

Thanks for your interest. Feel free to continue to follow up, and I will do my best to help.

Share
Helpful?

Q: I was looking at your docs but most of them are incomplete: https://docs.

usesql.com/

How would you go about exposing the data of a spreadsheet and connecting it to a static website that I own?

rich_daddyMar 7, 2021
See detail
Founder Team
dylanroy

dylanroy

May 15, 2024

A: Hi MG,

This has been the most frequently asked question, and for good reason. I am planning on wrapping up that tutorial first and will respond in this thread to see if that helps answer your question.

Thanks,

Dylan

Share
Helpful?

Q: In the generated html output, can we show links?

I'm trying to figure out if we can output links as well and if we can cache the output so we won't use queries every time.
Do you know if Cloudflare Pages can use Cloudflare cache? This way, we can cache the answer on the EDGE.

TekbassadorPLUSMar 7, 2021
See detail
Founder Team
dylanroy

dylanroy

May 15, 2024

A: For the generated output you currently cannot display links as representing that in SQL that worked for all of the output formats is difficult to surface in a user-friendly format via an API request. For existing use cases that required this, the JSON response was used, and a table was constructed from that response.

If you have a recommendation on how that would look in an API request feel free to recommend it as I am currently using everyone's feedback here to inform the next 3-month roadmap.

Share
Helpful?

Q: How you can share the query result, without exposing the private key?

TekbassadorPLUSMar 8, 2021
See detail
Founder Team
dylanroy

dylanroy

May 15, 2024

A: The retrieval would have to be from the server-side if you don't want to expose those keys at the moment. It may be valuable for the introduction of whitelisting certain domains on a key or account level if this is desired. Just like with your caching recommendation this has been something that I think is worth adding to the more immediate roadmap.

Share
Helpful?

Q: Interesting.

- The requests/month are kind of low.
- we can use this on multiple domains, right?
- I can't find your website.

Thank you!

TekbassadorPLUSMar 6, 2021
See detail
Founder Team
dylanroy

dylanroy

May 14, 2024

A: Hello,

Yeah, you can use this API wherever you please. So there isn't any limit on domains.

There's been a few requests on upping the request limit for this plan. If it makes sense on our end this likely will be updated, and all plans will be grandfathered in.

Thanks,

Dylan

Share
Helpful?

Q: Hello Sumo-Lings!

This is Dylan, the creator of UseSQL!

I started creating UseSQL to scratch my own itch really as it’s a lot easier to iterate without the need to spin up a database as I develop products. UseSQL was really initially something that I used for myself but decided to release it to the world to see if there was interest in using this product outside of my needs. This evolution of the project has resulted in gaps in our documentation so if your use case is incomplete or not listed please reach out, and that will help guide building this archive, as at this point this has transitioned from my product to our product.

There are a number of questions and suggestions that commonly get asked so I will continue to add those to the FAQs and my forecasted focus.

Current Focus
➡️ Complete the tutorials requested here by my customers.
➡️ Look into expanding the request limits that benefit existing and new users. (As this is a LTD this will most likely make sense through allowing code stacking.)
➡️ Review requested features, and publish a public roadmap
➡️ Add some information about the team that built the product.

FAQs

❓ Where can I find more information about this product?
More information can be found at, https://www.usesql.com, and we even have a demo that may be worth taking a look at here, https://www.usesql.com/demo.

❓ How can I find more information on how to use this product for my use case?
You can find this information at https://docs.usesql.com/ or if the use case you have isn’t there or incomplete please raise this here or send an email our way.

You can reach me at dylan@usesql.com

Cheers!
Dylan

dylanroyMar 8, 2021
See detail
Share
Helpful?

Q: Hello Sumo-Lings!

This is Dylan, the creator of UseSQL!

I started creating UseSQL to scratch my own itch really as it’s a lot easier to iterate without the need to spin up a database as I develop products. UseSQL was really initially something that I used for myself but decided to release it to the world to see if there was interest in using this product outside of my needs. This evolution of the project has resulted in gaps in our documentation so if your use case is incomplete or not listed please reach out, and that will help guide building this archive, as at this point this has transitioned from my product to our product.

There are a number of questions and suggestions that commonly get asked so I will continue to add those to the FAQs and my forecasted focus.

Current Focus
➡️ Complete the tutorials requested here by my customers.
➡️ Look into expanding the request limits that benefit existing and new users. (As this is a LTD this will most likely make sense through allowing code stacking.)
➡️ Review requested features, and publish a public roadmap
➡️ Add some information about the team that built the product.

FAQs

❓ Where can I find more information about this product?
More information can be found at, https://www.usesql.com, and we even have a demo that may be worth taking a look at here, https://www.usesql.com/demo.

❓ How can I find more information on how to use this product for my use case?
You can find this information at https://docs.usesql.com/ or if the use case you have isn’t there or incomplete please raise this here or send an email our way.

You can reach me at dylan@usesql.com

Cheers!
Dylan

dylanroyMar 8, 2021
See detail
Share
Helpful?

Q: URL to get more info?

ajoscoaMar 6, 2021
See detail
Share
Helpful?

Q: I feel like it would be nice to have some sort of caching.

Maybe we can specify a ttl for a cached answer to our request at the api key level and we should be able to define the ttl/api key request.

TekbassadorPLUSMar 7, 2021
See detail
Founder Team
dylanroy

dylanroy

May 15, 2024

A: This is a really good idea. Another use suggested that we create a public roadmap. I think this warrants a space on that roadmap.

Share
Helpful?

Q: Can you give us link please?

What is the difference between your product and spreadsimple?

ValentinLPLUSMar 6, 2021
See detail
Founder Team
dylanroy

dylanroy

May 15, 2024

A: Hello,

I appreciate your interest. Our website can be found at https://www.usesql.com/. After looking at the other website I notice that the other product works for Google Sheets to embed the results in web pages.

UseSQL allows you to do the same, but for a number of additional sources using SQL. Beyond allowing for additional sources with UseSQL you can query across multiple Google Sheets, and surface those results in the page you would like to display them.

There is a demo on our website so that you can try this out for yourself if you want as well:
https://www.usesql.com/demo

Thanks,

Dylan

Share
Helpful?

Q: What is your website?

How it works?

worktargetMar 6, 2021
See detail
Founder Team
dylanroy

dylanroy

May 15, 2024

A: Hello,

Our website can be found at https://www.usesql.com/ and we have some tutorials that can be found linked off from the header. We are still in the process of completing these. If you have a use case in mind please let me know, and I can ensure that we write something up for you as well.

Thanks,

Dylan

Share
Helpful?

Q: Wow, this is very interesting.

But where to find more information about the team who is behind this fantastic product. Do you have website and also some real examples of how your existing customer deal with the database?

Konstantin_KCPLUSMar 5, 2021
See detail
Founder Team
dylanroy

dylanroy

May 15, 2024

A: Hi Konstantin,

I think this is something that is missing. I will be writing up a pinned post here, and I also think it's worth its own about page on the website.

The plan to cover customer use cases will be through completing the tutorials that we have in our docs pages linked from our website at https://www.usesql.com.

Thanks,

Dylan

Share
Helpful?

Q: What is your website?

unknown_userMar 6, 2021
See detail
Founder Team
dylanroy

dylanroy

May 15, 2024

A: Hello,

Our website can be found at https://www.usesql.com.

Thanks,

Dylan

Share
Helpful?