zainhoda

8 ms·

31.
by zainhoda 3y ago
This is a good idea. I think what you'd want to do is override the generate_sql function and store the question with the "related" metadata and the generated sql somewhere: https://github.com/vanna-ai/van
32.
by zainhoda 3y ago
Author of the package here. It was originally because it's both a name and a finance term because I was originally using this to query a financial database. https://www.thebalancemoney.com/vanna-explanation-of-the-opt..
33.
by zainhoda 3y ago
Author of the package here. I would be open to alternative suggestions on terminology! The problem is that our typical user has never encountered RAG before.
34.
by zainhoda 3y ago
Author of the package here. That's pretty much what this package does just with optimization around what context gets sent to the LLM about the database: https://github.com/vanna-ai/vanna/blob/main/s
35.
Show HN: Python package for generating accurate SQL via LLMs using RAG(github.com)
7 points by zainhoda 3y ago|0 comments
36.
by zainhoda 3y ago
Awesome! I've been looking for almost exactly this. The only issue is that I'm not totally comfortable installing a Mac app to try it out. I'd be happy to try it out as a web app first. When you snooze it for >=1 day, does
37.
by zainhoda 3y ago
Wow, this is super cool! From the code it seems like the speech to text and text to speech are using the browser’s built-in features. I always forget those capabilities even exist!
38.
by zainhoda 3y ago
That information is just regurgitated from the New Yorker article not from this new interview with Toner.
39.
by zainhoda 3y ago
Oh man, I would love to compare notes. I pivoted in the reverse direction from: https://github.com/pycob/pyvibe To https://github.com/vanna-ai/vanna
40.
by zainhoda 3y ago
> All in all, it felt more like a loose collection of unfinished PhD theses than an actual programming language. Yeah, to me Haskell is the experimental forefront of programming language theory and the most developed concepts get incorpo
41.
by zainhoda 3y ago
Nice! I’m going to try it out and possibly integrate it into my Python package: https://vanna.ai
42.
by zainhoda 3y ago
We tested Bard (aka Bison in GCP) for generating SQL. It has worse generalization capabilities than even GPT-3.5 but actually does as well at GPT-4 when given contextually relevant examples selected from a large corpus of examples. https:&
43.
by zainhoda 3y ago
I like small form factor so I use iPhone 12 mini and before that was the original iPhone SE. Sadly the small form factor seems to be going away so I’m not really sure what my next phone will be.
44.
by zainhoda 3y ago
Very interesting! I’ve been thinking along similar lines for data stories using vanna.ai — if you’re reading a research report or blog post that has charts, you could theoretically dig deeper into it in the same way that you continue your b
45.
by zainhoda 3y ago
There isn't technically a limit on the storage side but it's generally better if you keep documentation to a manageable length. You call vn.train(sql=...) on each individual SQL statement that you have. What'll happen under t
46.
by zainhoda 3y ago
It probably could but it would require adjusting the prompt. You’d have to override the generate_prompt function and tell it that you’re using a variant of SQL and describe the differences.
47.
by zainhoda 3y ago
Thanks for the link! I'll check it out. In the meantime, this post we wrote might be interesting for you: https://vanna.ai/blog/ai-sql-accuracy.html
48.
by zainhoda 3y ago
API key is optional -- that's only if you want to use the hosted vector database. When running locally, no Vanna API key is necessary. Instead, you can put in an OpenAI API key as shown here: https://vanna.ai/docs/
49.
by zainhoda 3y ago
We use "train" in a colloquial sense because you're right -- it's RAG. We've tried to think about a different term but "train" seems to be the one that most data analysts resonate with.
50.
Show HN: Vanna AI – Open-sourced text-to-SQL in Python(vanna.ai)
33 points by zainhoda 3y ago|12 comments
51.
by zainhoda 3y ago
I like this! I think I’ll use it for my AI product. It actually really quickly answers a lot of customer questions that we have to address via FAQs currently.
52.
by zainhoda 3y ago
Nice job! We're building something relatively similar at Vanna AI: https://vanna.ai/
53.
by zainhoda 3y ago
Thanks! You can see the 3 static examples in this notebook here: https://github.com/vanna-ai/research/blob/main/notebooks/tra... The set of larger SQL queries includes the initial static set but is
54.
by zainhoda 3y ago
I'm in a similar boat. I've got ADEL50LYL1. It would be good to know what the risk level is.
55.
by zainhoda 3y ago
In addition to the minisplit cost, there's also the cost of the electrical work. Anyone can plug in a dehumidifier into an outlet but drilling a hole into the wall, running the linesets and communication wires for a minisplit is beyond
56.
Show HN: How to use LLMs to generate accurate SQL for real-world data(github.com)
21 points by zainhoda 3y ago|3 comments
57.
by zainhoda 3y ago
Vanna: A Python package to generate SQL using LLMs Package: https://github.com/vanna-ai/vanna A paper we're just finished: https://github.com/vanna-ai/vanna/blob/main/papers&#x2
58.
by zainhoda 3y ago
This is a great start! Is there any way I can style the components myself? If so, I'd use it
59.
by zainhoda 3y ago
I found Chroma to be really slow. I recently switched to pgvector and I'm really happy with it. This is an example of using pgvector that might be relevant for your use case: SELECT d.id, d.doc, 1 - (embedding <=> (SELECT embeddi
60.
by zainhoda 3y ago
Reminds me of the time that my mom ordered shoes off of some random FB ad. Her credit card was charged and we waited a few weeks. Tried to go back to the site to see what the order status was and the site didn't exist anymore! We assum

More ›