Best way to integrate weaviate and postgresql?

Hello. I didn’t see any tutorial on how to best integrate weaviate and PostgreSQL.

Suppose I want to store text chunks in PostgreSQL and vectors in Weaviate - is there any good way to integrate both so I can work with both data stores seamlessly?

Thanks!

Hi, I am not aware of any tutorials like that specifically.

What are some of the main questions you have?

Generally, it occurs to me that one way you could do it is to store the Weaviate object ID as Postgres, and perhaps the equivalent primary key in Weaviate. And use them to look each other up. I say this because the only unique field in Weaviate is the UUID - and unique in a sense of per-class and tenant basis.

If you have any specific questions we can try to help with those, too.