HNHacker News
TopNewBestAskShowJobs

tarasyarema

143 karma · joined November 29, 2018

https://github.com/tarasyarema
submissionscomments
tarasyarema··on Collaborative, agent to agent scenarios
After the release yesterday, I think it's an interesting move from Google, and specially the sample code they have in the repo.

Seems like a natural move after the MCP release, and I'm curious to see how many A2A new tools will appear in the next weeks, has anyone already started working on a Python library to implement the A2A interface?

They say that MCP can be used in conjunction, but I'm not sure if this actually makes the type of interaction move from the MCP (tool) level to the agent level.

Also, the auto-discovery with the well-known/agent.json I think it's something that is missing on the MCP world (?).

What do you think about it?

tarasyarema··on Ask HN: How much are you spending on AI?
Interesting, I do agree that finding actual value is not "trivial" for genai. In our case we found a specific use case that actually helps our purpose, so we use it there.

Also, how I always try to think about it is: do not expected accuracy to be 100%, it's not deterministic, and find a way for the user to actually use it as a helper / time reducer than an actually core solution.

tarasyarema··on Show HN: Query Your Sheets with SheetSQL
Totally, In fact I think it would be nice to have a sort of interactive example based on one of your sheets, definitely! Thanks for the feedback.
tarasyarema··on Show HN: Query Your Sheets with SheetSQL
Probably you could do something similar, the thing is that duckdb is much more lightweight. But at the same time if you end up having billions of data points BQ is there to scale for sure jaja
tarasyarema··on Show HN: Query Your Sheets with SheetSQL
Ah, I see, could you try now? The quota should be fixed, my bad there, had a bug.

Now about the query, DuckDB works in the following way, the query you sent should be written like

> SELECT * from <table> where "Status" = 'Complete';

Now this is because the `"` is used for the table and column names, and the `'` is used for raw string. See more here https://duckdb.org/docs/sql/introduction#querying-a-table which might be a bit different from other SQL database engines.

And finally, regarding the autocomplete, it indeeds tries to autocomplete in a too verbose way, which is something I'll try to improve.

Thanks for reaching out, and hopefully this can help you try it out!

tarasyarema··on Show HN: Query Your Sheets with SheetSQL
No, it's done dynamically over the data, no loading nor anything. In fact it's streaming the queries with the power of DuckDB :D
tarasyarema··on Show HN: Query Your Sheets with SheetSQL
Is this something that can be done without being in Google? And it would not be free in the end right? As BQ is not free in the end either...
tarasyarema··on Show HN: Query Your Sheets with SheetSQL
Could you email me maybe some of the issues you encountered so I could help and find a good way to add the docs in the page?
tarasyarema··on Show HN: Query Your Sheets with SheetSQL
I guess this is more focused on Google sheets and the limitations of it, i.e. people that do not operate with Excel files basically
tarasyarema··on Show HN: Query Your Sheets with SheetSQL
Indeed the tool is great, and the performance is amazing in the browser. I believe DuckDB has a ton of potential!

The same query in SheetSQL

https://ibb.co/dDdZ0vC

tarasyarema··on Show HN: Query Your Sheets with SheetSQL
Yeah, that is actually super nice, the potential DuckDB offers to operate with data in such an easy way. With a bit of tuning on the auth side it's that easy indeed.

I think it is a pain point for some people, and it's great to see other teams working on similar products and being based on the same tech.

tarasyarema··on Show HN: Query Your Sheets with SheetSQL
Oh wow, I did not know about this, thanks for adding. Curious, do you handle live updates of the data upstream, it would refetch the data each time?
tarasyarema··on Show HN: Query Your Sheets with SheetSQL
:D Actually completely accidental, as I'm using the chakra ui for the frontend part
tarasyarema··on Show HN: Query Your Sheets with SheetSQL
Indeed, you can run queries in a sheet, but

1. It's writing a query in a single row cell which is hard from a UX perspective 2. SheetSQL offers you a way to cross join sheets as if those where tables, even between worksheets, which is something that is not supported natively 3. Full DuckDB SQL support, so you can use advanced functions like PIVOT or window functions

tarasyarema··on Show HN: Query Your Sheets with SheetSQL
Thanks! First time deploying a project like this on my own, so nervous to see how the users use it, or if they do it at all jeje
tarasyarema··on Show HN: Query Your Sheets with SheetSQL
Will keep the site posted on this, but definetly is one of the things that worries me the most as of now.

Thanks for the comment!!

tarasyarema··on Show HN: Query Your Sheets with SheetSQL
It is indeed an option, I guess the problem with this is that its static and and you need to re-create the tables each time.

For someone more techie probably could work, as you could dump the data to sqlite and then query it. But if you want to have it dynamically and from sheets in real-time probably it would be harder to handle this way.

tarasyarema··on Show HN: Query Your Sheets with SheetSQL
I have the GCP sheet basic read quota limit, which is something I need to investigate if I can make it higher.

Also, in theory right now once you use a sheet once it will cache the version so that subsequent queries are faster, and in theory if you change the sheet it will check for that and use the live data if it got updated in the meantime.

Nevertheless, it might take a minute or so sometimes.

tarasyarema··on Show HN: Query Your Sheets with SheetSQL
Yeah actually I'm thinking on making an extension that you could use from the sheet page. Do you think that would make sense?
tarasyarema··on Show HN: Query Your Sheets with SheetSQL
If someone want to try the PRO version here's a promo code to use it for free the first month "PGRAHAM" it's limited to the first 50 uses :D
tarasyarema··on Show HN: Query Your Sheets with SheetSQL
Nice, actually I think the best target for this would be people that poweruse sheets and have some SQL knowledge. I see teams that eventually would develop tools or use data lakes etc instead of sheets, but as a first tool to quickly operate over the initial startup sheet drama I think it could be powerful :D
tarasyarema··on Show HN: Query Your Sheets with SheetSQL
Note tho, that vertically merged cells I think should not be an issue probably, but would need to QA jaja
tarasyarema··on Show HN: Query Your Sheets with SheetSQL
As I replied to @hashhar, the header thing it's indeed an issue that I need to figure out, as there are some sheets that have weird structures and it would be nice to find an easy UXsy way to preview the sheet data and say "select from this range" or "these are the headers".
tarasyarema··on Show HN: Query Your Sheets with SheetSQL
Oh, that's actually cool and thanks for the reference.

It's using a temporary cache that re-uses the latest data from the sheet (checking if it was updated) so that's why the subsequent queries should be much faster than the initial one.

Now about the headers, it's indeed an issue that I need to figure out, as there are some sheets that have weird structures and it would be nice to find an easy UXsy way to preview the sheet data and say "select from this range" or "these are the headers".

tarasyarema··on Show HN: Query Your Sheets with SheetSQL
Could you reach out to taras@sheetsql.io with a screenshot or something, so I could have a look at what could be going on?
tarasyarema··on Show HN: Query Your Sheets with SheetSQL
That is an interesting thing you are raising here. I think right now the point of the paid plan is the scheduled queries, which are the more compute expensive, that's why the pricing like this.

Now, I do believe that I may just increase the free allowance, and maybe if I see people that want to power use normal queries and have maybe a few scheduled ones have an mid tier plan (or even on demand) that allows more queries and a few schedules.

And eventually move the PRO to be a really PRO plan.

tarasyarema··on Show HN: Trace, track your job applications with ease
Nice project, wondering what is the difference with other tools like huntr.co? Did you found that there's no one that is trying to solve this?
tarasyarema··on Show HN: I made a no-bullshit image host
I love ur tone jajajaj Won’t subscrive tho, but I love you!
← PreviousPage 4 of 4