PostgreSQL with Local Small Language Model and In-Database Vectorization | Azure
![PostgreSQL with Local Small Language Model and In-Database Vectorization | Azure PostgreSQL with Local Small Language Model and In-Database Vectorization | Azure](https://static.libsyn.com/p/assets/5/2/9/2/52929525295f485427a2322813b393ee/PostgreSQL_podcast.webp)
Improve search capabilities for your PostgreSQL-backed applications using vector search and embeddings generated in under 10 milliseconds without sending data outside your PostgreSQL instance. Integrate real-time translation, sentiment analysis, and advanced AI functionalities securely within your database environment with Azure Local AI and Azure AI Service. Combine the Azure Local AI extension with the Azure AI extension to maximize the potential of AI-driven features in your applications, such as semantic search and real-time data translation, all while maintaining data security and efficiency.
Joshua Johnson, Principal Technical PM for Azure Database for PostgreSQL, demonstrates how you can reduce latency and ensure predictable performance by running locally deployed models, making it ideal for highly transactional applications.
► QUICK LINKS:
00:00 - Improve search for PostgreSQL
01:21 - Increased speed
02:47 - Plain text descriptive query
03:20 - Improve search results
04:57 - Semantic search with vector embeddings
06:10 - Test it out
06:41 - Azure local AI extension with Azure AI Service
07:39 - Wrap up
► Link References
Check out our previous episode on Azure AI extension at https://aka.ms/PGAIMechanics
Get started with Azure Database for PostgreSQL - Flexible Server at https://aka.ms/postgresql
To stay current with all the updates, check out our blog at https://aka.ms/azurepostgresblog
► Unfamiliar with Microsoft Mechanics?
As Microsoft's official video series for IT, you can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft.
• Subscribe to our YouTube: https://www.youtube.com/c/MicrosoftMechanicsSeries
• Talk with other IT Pros, join us on the Microsoft Tech Community: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog
• Watch or listen from anywhere, subscribe to our podcast: https://microsoftmechanics.libsyn.com/podcast
► Keep getting this insider knowledge, join us on social:
• Follow us on Twitter: https://twitter.com/MSFTMechanics
• Share knowledge on LinkedIn: https://www.linkedin.com/company/microsoft-mechanics/
• Enjoy us on Instagram: https://www.instagram.com/msftmechanics/
• Loosen up with us on TikTok: https://www.tiktok.com/@msftmechanics
Published on:
Learn more![Microsoft Mechanics Podcast Microsoft Mechanics Podcast](https://ssl-static.libsyn.com/p/assets/a/2/c/8/a2c88acc220e584927a2322813b393ee/MM-Logo-Gradient.png)
Made for tech enthusiasts and IT professionals. Expanded coverage of your favorite technologies across Microsoft; including Office, Azure, Windows and Data Platforms. We'll even bring you broader topics such as device innovation with Surface, machine learning, and predictive analytics.
Related posts
{How to} Create Azure Communication Services for Dynamics 365 Customer Service Omnichannel
Hello Everyone,Today I am going to show how to subscribe to Azure Communication Services on Azure Portal.Let's get's started.Let's say you hav...
Upgrade to Azure Synapse runtimes for Apache Spark 3.4 & previous runtimes deprecation
It is important to stay ahead of the curve and keep services up to date. That's why we encourage all Azure Synapse customers with Apache ...
Using Keycloak with Azure AD to integrate AKS Cluster authentication process
Introduction Integrating Azure Kubernetes Service (AKS) with Keycloak through Azure Active Directory (Azure AD) as an intermediary lev...
Dev Proxy v0.19 with simulating LLM APIs and new Azure API Center integrations
We're excited to share the launch of Dev Proxy v0.19 to help you to build robust apps connected to APIs. The post Dev Proxy v0.19 with simulat...
Convert speech to text using Azure Speech service in Power Automate Flow
Azure provides Speech Services that let developers add advanced speech features to achieve complex functionality, including Speech-to-Text. Wi...
Azure API Center: Centralizing API Management for Enhanced Discovery and Governance
Have you ever thought about having a single place to manage all your APIs? It could make it easier to find and control your services. ...
Azure SDK Release (June 2024)
The Azure SDKs release every month. This post includes the month's highlights and release notes. The post Azure SDK Release (June 2024) appear...