[PROMO] QUERYX allows you to use sql queries in sheets.

[Alex]

Hi!

I'm working on the add-on QUERYX.

QUERYX allows you to use SQL queries in Sheets.

• The product webpage https://queryx.contributor.pw/
• Test without join the testing group #link The sheet's separator is ';'

Best, Alex.

[Yasir Karam]

What extra features than native GSheet SQL?

https://www.benlcollins.com/spreadsheets/google-sheets-query-sql/

Yasir Karam about.me/karamyasir

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/dfc5a616-a4ab-4b9f-b3f8-07b7f9de54ac%40googlegroups.com.

[Alex]

On Friday, November 1, 2019 at 12:47:23 PM UTC+3, Yasir Karam wrote:

What extra features than native GSheet SQL?

Hi!

Thanks for the question!

It's not a pseudo-SQL language like the QUERY. It's a full SQL implementation of a JS SQL Database. You can try the next directives/statements/functions : FROM, UNION, HAVING, DISTINCT, JOIN, TOP, GREATEST etc. 

[Yasir Karam]

I tried XQuery, its quite easy, with great UI's and good performance, although almost all Google Query featured SQL are there too like joins, tables, indices, ..etc. 

https://cloud.google.com/spanner/docs/query-syntax

BTW, XQuery/XPath which had the same name with XQuery Add-on are also available with G Sheet

https://www.youtube.com/watch?v=pwZ44kAeiOo

Cheers,

Yasir Karam about.me/karamyasir

--

You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/ee743616-9f4c-449b-b662-e2bd85d49bf4%40googlegroups.com.

[Dimu Designs]

How well does it perform against relatively large data-sets? For example, say you want to do a LEFT JOIN between two 10 column by 10,000 row grids; how long would that take to execute? Would it run into any issues with Apps Script's execution quotas?

[Arjun duraisamy]

Hi All,

Can anyone tell me whether can we do script for below scenario.

If i give orange as user input ,it should extract  all orange related rows(name,value, description)  please see fig. and paste it in a different sheet ,as am new to script am facing some difficulty.

Thanks and grateful for any suggestions.

On Fri, 1 Nov, 2019, 5:42 PM Dimu Designs, <dimud...@gmail.com> wrote:

How well does it perform against relatively large data-sets? For example, say you want to do a LEFT JOIN between two 10 column by 10.000 row grids; how long would that take to execute? Would it run into any issues with Apps Script's execution quotas?

On Friday, November 1, 2019 at 3:53:41 AM UTC-4, Alex wrote:

Hi!

I'm working on the add-on QUERYX.

QUERYX allows you to use SQL queries in Sheets.

• The product webpage https://queryx.contributor.pw/
• Test without join the testing group #link The sheet's separator is ';'

Best, Alex.

--

You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/09d97fc5-8dc2-48ce-ad6d-b78588e3181a%40googlegroups.com.

[Alex]

On Friday, November 1, 2019 at 3:12:20 PM UTC+3, Dimu Designs wrote:

How well does it perform against relatively large data-sets? For example, say you want to do a LEFT JOIN between two 10 column by 10,000 row grids; how long would that take to execute? Would it run into any issues with Apps Script's execution quotas?

Hi!

That is my question now!

It works very fast for relatively small data-sets. For the example the code selects common records from two large tables (10k rows JOIN 7k rows) https://github.com/contributorpw/alasqlgs#example-01

At now I'm using https://github.com/contributorpw/alasqlgs as a library. And I am thinking of moving part of the code or all the code into one project.

[Alex]

Yes, It's simple.

Please create a new theme or write me private he...@contributor.pw. I value this project at $20-50 net.

[Arjun duraisamy]

Thanks Alex for your response..I will try and update..

--

You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/88b8de91-349f-47ad-b7ba-5dd05d43e896%40googlegroups.com.