Azure-Samples / rag-postgres-openai-python

A RAG app to ask questions about rows in a database table. Deployable on Azure Container Apps with PostgreSQL Flexible Server.
MIT License
262 stars 131 forks source link

Multitenant setup #134

Open adrianruchti opened 2 weeks ago

adrianruchti commented 2 weeks ago

Hi @pamelafox Thank you for this great guide on how to build this RAG chat app using pgvector.

Turn App into Multitenant App using one or several databases for each customer

Do you have any recommendation on multitenancy for this app? Wold you use one database for several customers if turning this app into a SaaS App? how would you connect to different databases for different tenants? What is Microsoft best practice?

MAC OS, container apps, postgresql db, storage account

Azure Container Apps for use in a multitenant scenario. Preferably a explanation for the connection to a Postgresql db and a additional storage account.