versatile-data-kit icon indicating copy to clipboard operation
versatile-data-kit copied to clipboard

[SPIKE] Create an example of writing to postgres using LLamaIndex

Open murphp15 opened this issue 1 year ago • 3 comments

What is the feature request? What problem does it solve? For the demo we want to use postgres and llamaindex to write to it. This ticket is to become familiar with how to do this.

murphp15 avatar Feb 21 '24 14:02 murphp15

@duyguHsnHsn already did some research in this area. See her notes in https://github.com/vmware/versatile-data-kit/wiki/VDK-and-LLamaIndex

antoniivanov avatar Feb 21 '24 14:02 antoniivanov

https://docs.llamaindex.ai/en/stable/examples/vector_stores/postgres.html - according to this tutorial, llamaindex can be used to query from but not to ingest to a postgresql db

gabrielgeorgiev1 avatar Feb 26 '24 08:02 gabrielgeorgiev1

https://medium.com/dataherald/how-to-connect-llm-to-sql-database-with-llamaindex-fae0e54de97c - another resource where a sqlalchemy db connection is required as a supplementary object; it seems like this is another opportunity to stress the benefit of having a VDK managed connection when building rag apps

gabrielgeorgiev1 avatar Feb 26 '24 08:02 gabrielgeorgiev1