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).
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.
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
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.
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
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.
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?
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
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.
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.
Thanks for your comment and opening a door to someone like me who fees like sort of an out-of-place idiot! A bit "techinical" is what I initially thought and almost passed on this deal. Lol.
Dylan,
You are very responsive to questions, that is great and I commend you on that!
Unfortunately for a newbie to much of this, your responses are a bit over my head at this time. However, I THINK your software maybe EXACTLY what I think I am searching for after self-learning about some of your world since COVID began. I am a in awe of what I still need to learn... especially after seeing your deal... but I think that it may be what I need.
That said, many, many Sumolings use Stackby over Airtable. I recommend that you maybe reach out to Rachit @Stackby and get integrated and mention that in your comments. Stackby is awesome and they are integrated also with Integromat and I know G-Sheets was also on their roadmap. I met him at a virtual no-code seminar over the Summer. Seems like a good match and they impressively crank-out the upgrades to their amazing platform.
Anyway, congrats on this launch. I applaud your expertise, but you may want to consider an interpreter for the Appsumo's "other half:", 🤣. Appsumo’s demographics run the gamut, and as others said… there is some loss in translation.
As you can see by the ridiculous amount of deals that I have purchased since I joined Appsumo late last year, I have many needs, I am a serial entrepreneur who is “all in” since COVID to create the tools that I always wanted for my own local businesses (now crushed by quarantines) and to help bridge the gap to many other entrepreneurs and business execs in my database after being a CEO for 20+ years.
FINALLY, my questions:
1) Where to find best “crash course” for learning the basics of what the heck you are showing us here: https://www.usesql.com/demo. Seems like exactly what I need but my head is spinning after watching.
2) Can you consider a verbal/voiceover of tutorial of your same exact demo video and put it up ASAP? Try Vidstep (current active deal here: https://appsumo.com/vidstep/). The floodgates may open for you with this little recommendation on a pretty useful app for your tutorials.
3) After #2 above (which hopefully you can get launched and posted ASAP).... I recommend this active deal: https://appsumo.com/onboardflow/. Seems like another good match for your seemingly ideal app.
Well.... if you take my rec's to heart, I maybe just added to your workload or a weekend project 😂. If you add #2 and #3... I think you will help me and many others who want to give you some supportive cash flow.
I really think your software is what I really am searching for (emphasis on "think").
Good luck on the road ahead.
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
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
I will try and explain the steps I took. I understand that with the current tools/documentation in place that this may be difficult to understand, but I am here to do what I can to help you in the meantime.
The first thing I did was check what data types your columns had been cast to by using this API endpoint https://usesql.com/docs#/Describe/sql_describe_describe_get via this call https://usesql.com/describe?table=https%3A%2F%2Fwww.guruwatch.nl%2Fgurus%2Fdefault.aspx&format=json&key=zJpfI9h8TujjN45cHk1a
At this point my goal was to get the TEXT value of Rendement converted to a number that can be filtered using the greater than 10 predicate you wanted to use. e.g. conveting 3,0% converted to something like 3.0.
Normally I would use CAST(Rendement as decimal), but need a bit more practice with SQL to figure out why that wasn't working. I then resorted to some trial and error in the demo interface. I discovered that an implicit cast to a decimal happens when a string is multiplied by a decimal such as 1.0. This can be seen if you supply the query below to the demo interface (https://www.usesql.com/demo).
SELECT Guru, Rendement*1.0 from "https://www.guruwatch.nl/gurus/default.aspx"
At that point, I knew I could apply the where clause you had wanted to apply to your query.
Once again if this doesn't make sense I am more than willing to continue to follow up with you.
Note: I will just restate here until my post gets pinned that this API uses the SQLite query syntax (https://sqlite.org/lang_select.html). If you want to learn this tutorial looks like a pretty good one https://www.sqlitetutorial.net/. Feel free to practice your queries in the demo interface.
Thanks for the detailed response and the tutorial link.
I was looking for something like that.
I see the potential of UseSQL for marketeers getting relevant content. Just need to discover if I will be capable of using it.
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.
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.
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.
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.
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.
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.
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.
I forgot to help with that last point. The website can be found at https://www.usesql.com.
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.
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.
Thanks for pointing ajoscoa in the right direction! (https://www.usesql.com) would be the link, and we are looking to expand on our documentation so if you have a use case in mind please post it here, and we will work to get that added as a tutorial to the archive.
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.
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
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.
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?
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.
Q: I'll wait for those tutorials on how to connect your tool to my static website before I decide to buy.
Thanks.
dylanroy
May 15, 2024A: 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 UseSQL
yo tambien.
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.
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
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.
dylanroy
May 15, 2024A: 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 UseSQL
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.
Share UseSQL
Q: Any plans for stacking codes?
dylanroy
May 14, 2024A: 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 UseSQL
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
Share UseSQL
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.
dylanroy
May 15, 2024A: 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 UseSQL
Andrew,
Thanks for your comment and opening a door to someone like me who fees like sort of an out-of-place idiot! A bit "techinical" is what I initially thought and almost passed on this deal. Lol.
Dylan,
You are very responsive to questions, that is great and I commend you on that!
Unfortunately for a newbie to much of this, your responses are a bit over my head at this time. However, I THINK your software maybe EXACTLY what I think I am searching for after self-learning about some of your world since COVID began. I am a in awe of what I still need to learn... especially after seeing your deal... but I think that it may be what I need.
That said, many, many Sumolings use Stackby over Airtable. I recommend that you maybe reach out to Rachit @Stackby and get integrated and mention that in your comments. Stackby is awesome and they are integrated also with Integromat and I know G-Sheets was also on their roadmap. I met him at a virtual no-code seminar over the Summer. Seems like a good match and they impressively crank-out the upgrades to their amazing platform.
Anyway, congrats on this launch. I applaud your expertise, but you may want to consider an interpreter for the Appsumo's "other half:", 🤣. Appsumo’s demographics run the gamut, and as others said… there is some loss in translation.
As you can see by the ridiculous amount of deals that I have purchased since I joined Appsumo late last year, I have many needs, I am a serial entrepreneur who is “all in” since COVID to create the tools that I always wanted for my own local businesses (now crushed by quarantines) and to help bridge the gap to many other entrepreneurs and business execs in my database after being a CEO for 20+ years.
FINALLY, my questions:
1) Where to find best “crash course” for learning the basics of what the heck you are showing us here: https://www.usesql.com/demo. Seems like exactly what I need but my head is spinning after watching.
2) Can you consider a verbal/voiceover of tutorial of your same exact demo video and put it up ASAP? Try Vidstep (current active deal here: https://appsumo.com/vidstep/). The floodgates may open for you with this little recommendation on a pretty useful app for your tutorials.
3) After #2 above (which hopefully you can get launched and posted ASAP).... I recommend this active deal: https://appsumo.com/onboardflow/. Seems like another good match for your seemingly ideal app.
Well.... if you take my rec's to heart, I maybe just added to your workload or a weekend project 😂. If you add #2 and #3... I think you will help me and many others who want to give you some supportive cash flow.
I really think your software is what I really am searching for (emphasis on "think").
Good luck on the road ahead.
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?
dylanroy
May 14, 2024A: 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 UseSQL
Hi,
I'm not so home in SQL. But where is the *1.0 coming from?
I tried WHERE Rendement> 10.0
But it should be:
WHERE Rendement*1.0 > 10.0
I will try and explain the steps I took. I understand that with the current tools/documentation in place that this may be difficult to understand, but I am here to do what I can to help you in the meantime.
The first thing I did was check what data types your columns had been cast to by using this API endpoint https://usesql.com/docs#/Describe/sql_describe_describe_get via this call https://usesql.com/describe?table=https%3A%2F%2Fwww.guruwatch.nl%2Fgurus%2Fdefault.aspx&format=json&key=zJpfI9h8TujjN45cHk1a
At this point my goal was to get the TEXT value of Rendement converted to a number that can be filtered using the greater than 10 predicate you wanted to use. e.g. conveting 3,0% converted to something like 3.0.
Normally I would use CAST(Rendement as decimal), but need a bit more practice with SQL to figure out why that wasn't working. I then resorted to some trial and error in the demo interface. I discovered that an implicit cast to a decimal happens when a string is multiplied by a decimal such as 1.0. This can be seen if you supply the query below to the demo interface (https://www.usesql.com/demo).
SELECT Guru, Rendement*1.0 from "https://www.guruwatch.nl/gurus/default.aspx"
At that point, I knew I could apply the where clause you had wanted to apply to your query.
Once again if this doesn't make sense I am more than willing to continue to follow up with you.
Note: I will just restate here until my post gets pinned that this API uses the SQLite query syntax (https://sqlite.org/lang_select.html). If you want to learn this tutorial looks like a pretty good one https://www.sqlitetutorial.net/. Feel free to practice your queries in the demo interface.
Thanks for the detailed response and the tutorial link.
I was looking for something like that.
I see the potential of UseSQL for marketeers getting relevant content. Just need to discover if I will be capable of using it.
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.
dylanroy
May 15, 2024A: 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 UseSQL
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?
dylanroy
May 15, 2024A: 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 UseSQL
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.
dylanroy
May 15, 2024A: 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 UseSQL
Q: How you can share the query result, without exposing the private key?
dylanroy
May 15, 2024A: 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 UseSQL
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!
dylanroy
May 14, 2024A: 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 UseSQL
I forgot to help with that last point. The website can be found at https://www.usesql.com.
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
Share UseSQL
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
Share UseSQL
Q: URL to get more info?
Share UseSQL
https://www.usesql.com/
Thanks for pointing ajoscoa in the right direction! (https://www.usesql.com) would be the link, and we are looking to expand on our documentation so if you have a use case in mind please post it here, and we will work to get that added as a tutorial to the archive.
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.
dylanroy
May 15, 2024A: 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 UseSQL
Q: Can you give us link please?
What is the difference between your product and spreadsimple?
dylanroy
May 15, 2024A: 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 UseSQL
Q: What is your website?
How it works?
dylanroy
May 15, 2024A: 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 UseSQL
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?
dylanroy
May 15, 2024A: 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 UseSQL
Q: What is your website?
dylanroy
May 15, 2024A: Hello,
Our website can be found at https://www.usesql.com.
Thanks,
Dylan
Share UseSQL