Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Advancing Drug Search with PostgreSQL and Azure AI | POSETTE 2024

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
249 views 10 months ago #AI #PostgreSQL #PosetteConf
Video of a conference talk about advancing drug search with PostgreSQL and Azure AI presented by Taras Kloba at POSETTE: An Event for Postgres 2024. Advancing Search with PostgreSQL and Azure AI" is a session that details how PostgreSQL's features and Azure AI Services can be effectively used to significantly enhance the search functionality in any application. In this session, we'll share insights on how we used PostgreSQL to facilitate precise searches across multiple fields in our mobile application. The techniques include using LIKE and ILIKE operators and integrating a trigram-based search to handle potential misspellings, thereby increasing the search accuracy. We'll also discuss how the azure_ai extension on PostgreSQL databases in Azure and Azure AI Services were utilized to create vectors from user input, a feature beneficial when users wish to find specific items based on text prompts. While our application's case study involves a d …...more
...more
Advancing Drug Search with PostgreSQL and Azure AI | POSETTE 2024
6Likes
249Views
Jun 132024
Video of a conference talk about advancing drug search with PostgreSQL and Azure AI presented by Taras Kloba at POSETTE: An Event for Postgres 2024. Advancing Search with PostgreSQL and Azure AI" is a session that details how PostgreSQL's features and Azure AI Services can be effectively used to significantly enhance the search functionality in any application. In this session, we'll share insights on how we used PostgreSQL to facilitate precise searches across multiple fields in our mobile application. The techniques include using LIKE and ILIKE operators and integrating a trigram-based search to handle potential misspellings, thereby increasing the search accuracy. We'll also discuss how the azure_ai extension on PostgreSQL databases in Azure and Azure AI Services were utilized to create vectors from user input, a feature beneficial when users wish to find specific items based on text prompts. While our application's case study involves a drug search, the techniques and principles shared in this session can be adapted to improve search functionality in a wide range of applications. Join us to learn how PostgreSQL and Azure AI can be harnessed to enhance your application's search capability. Taras is a Senior Partner Solutions Architect, Data & AI at Microsoft, with 14+ years in IT, banking, and cybersecurity. He is a certified Microsoft trainer, a Microsoft MVP in Data Platform (PostgreSQL), and holds certifications from Google, Amazon, and SEI. Recognized as Ukraine's Best Software Architect in 2019, he founded the PostgreSQL Ukraine community and regularly speak at IT events. His team won the TIDE NATO Hackathon 2023 and National Defense Hackathon 2022. Beyond work, Taras consults on military IT projects and volunteer towards Ukraine's victory. Chapters: 00:00 - Intro 01:02 - TIDE NATO Hackathon challenge 03:01 - Advisors & Problem Definition 10:26 - Technical Specifications 25:22 - Multi-layered approach 26:41 - Link to demo 27:58 - Contact info 📕 Everything you need to know about POSETTE: An Event for Postgres 2024 can be found at: https://aka.ms/posette ✅ Learn more: Watch more POSETTE talks: https://aka.ms/posette-playlist-2024 📌 Let’s connect: X – @PosetteConf https://x.com/PosetteConf Mastodon - @posetteconf https://mastodon.social/@posetteconf Threads – @posetteconf https://www.threads.net/@posetteconf 🔔 Subscribe to the POSETTE News: https://aka.ms/posette-subscribe #PosetteConf #PostgreSQL #AI Presenters: Taras Kloba, Senior Partner Solutions Architect, Data & AI at Microsoft Connect: Taras Kloba:   / klioba  ,   / kloba  

Follow along using the transcript.

Microsoft Developer

588K subscribers