vanna VS ibis

vanna-ai is a pretty cool project that combines AI with database knowledge. SQLAI seems to be a small German company which specializes in this area. I will start exploring these in my free time.

Vanna is a Python framework that allows the training of an RAG model with queries, DDL, and documentation from a database.

I’m trying to solve for this with my project and (at least based on what people say in Discord), it’s working really well for them:

https://github.com/vanna-ai/vanna

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/vanna/blob/main/src/vanna/base/b...

We're going to be adding a generic logging function soon and fairly soon what you're talking about could just be a custom logger.

Website: https://vanna.ai

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

I really don't understand the appeal of dbt vs a proper programming language. The templating approach leads to massive spaghetti. I look forward to trying out something like Ibis [0]

0: https://ibis-project.org/

ibis – portable Python dataframe library

The main benefit is that you get a Python (or R, Julia or Rust) interpreter. So you can evaluate code. A good example of the value of this is the Ibis docs which use Quarto: https://ibis-project.org/

Ive found polars quite intuitive, though for python, I lean more towards [ibis](https://ibis-project.org/). The interface is nearly identical, but ibis has the benefit if building sql queries before pulling any actual data (like dbplyr) — whereas polars requires the data to be in-memory (at least for rdb’s, though correct me if Im wrong)

this to me seems like a good argument for only using ibis, but Im happy to be convinced otherwise

Please add Ibis Birdbrain https://ibis-project.github.io/ibis-birdbrain/ to the list. Birdbrain is an AI-powered data bot, built on Ibis and Marvin, supporting more than 18 database backends.

See https://github.com/ibis-project/ibis and https://ibis-project.org for more details.