Demo of Azure AI & pgvector with Azure Database for PostgreSQL

Estimated read time 2 min read

Post Content

​ Demo of Azure AI being used with Azure Database for PostgreSQL and pgvector. Based on a demo given by Claire Giordano on the keynote stage at PASS Data Community Summit, this video showcases how you can improve the relevance of search results on a recipe website by using Azure OpenAI. Specifically the demo shows how you can use the new azure_ai (Preview) extension along with the open source pgvector extension and the Azure Database for PostgreSQL managed service to deliver semantic search results—as compared to search results you could obtain in the past via pattern matching with the LIKE clause in Postgres, or via Postgres full text search.

The demo also shows how azure_ai gives you an integration between Azure Database for PostgreSQL and the Azure AI Language service, so you can do things like sentiment analysis, language detection, and PII redaction.

In combination with the Azure Database for PostgreSQL service and pgvector, the new azure_ai extension to Postgres gives you the capability to build entirely new classes of applications—entirely in Postgres.

► Video bookmarks:
⏩ 00:00 Introduction of demo
⏩ 00:25 How things worked before with LIKE
⏩ 01:09 What about full text search?
⏩ 01:45 New azure_ai extension to Postgres
⏩ 03:52 Sentiment analysis & Azure AI Language service
⏩ 04:28 Language detection
⏩ 04:47 PII redaction
⏩ 05:15 Conclusion: azure_ai & pgvector with PostgreSQL

✅ Blog post: Introducing the azure_ai extension to Azure Database for PostgreSQL: https://aka.ms/blog-azure-ai
? Docs: Azure AI extension for Azure Database for PostgreSQL – Flexible Server: https://aka.ms/docs-azure-ai-postgres
? Docs: Release notes for Azure Database for PostgreSQL – Flexible Server: https://aka.ms/docs-flex-postgres-release-notes
✅ Follow @AzureDBPostgres on X/Twitter to stay connected: https://twitter.com/AzureDBPostgres

#PostgreSQL #AzureAI #Microsoft   Read More Microsoft Developer 

You May Also Like

More From Author

+ There are no comments

Add yours