Semantic Search with Supabase and OpenAI

In this video, I'll show how you can build a semantic search with Supabase and OpenAI. AI explosion is everywhere and there are fancy products built with AI. This semantic search application is a simple yet very powerful. It's cost effective, easy to manage and start.
- timestamps -
00:00 - Intro
00:34 - Application Walkthrough
04:49 - How System Works Behind the Scene
07:11 - Project Setup
11:24 - Creating Vector Database in Supabase
12:48 - Inserting Data into Database
13:58 - Creating Embedding for Query
15:34 - Creating Search Function in Supabase
20:28 - Building Search Page
22:35 - How to Improve?
Source Code: github.com/batuhanbilginn/sem...
Learn more: makr.dev
#supabase #typescript #development #developer #openai #ai

[@robinbeaudru6892]

Your work is so underrated, thank a lot !

[@makrdev]

Thanks!

[@darenbaker4569]

Great video wish it was longer. Your a rising star.

[@makrdev]

Thank you for your support Daren 🤗

[@MyGeorge1964]

This is great use of AI - I like it! More please... Thank you.

[@makrdev]

I’m glad you like it. Will definitely create more on this topic. Stay tuned 🤞

[@AnthonySistilli]

Great tutorial man.

[@MilMike]

Cool project. You explained it really good.

[@makrdev]

Thank you! I’m glad you liked it 🤜

[@igmyung2535]

This is awesome!!!!!!

[@automioai]

Makr, I was following you steep by steep to create the supabase table, btw when trying toi add the vector type column I do not get the vector option, I already activate the pluggin as you said but Im inable to at least see the vector option, any idea of what is oging on ?, I already refresh and do all the common stuff. ( this kind of issues are the hardest to manage because you dont have al leats an error 🤣)

[@makrdev]

There is a sql script in makr.ai to create vector column. Try this one 🤞

[@igmyung2535]

how to search on multiple table?

[@wizzl8513]

I don't get "vector" showing up as selectable type after activating vector extension. Did you create the type manually?

[@makrdev]

You need to enable vector column for ‘public’ schema.

[@wizzl8513]

@@makrdev Yes that worked, thanks

[@igmyung2535]

where did you use index that u made in 19:45?

[@makrdev]

Postgress use that index in order to query faster under the hood.

[@ehteshamsiddiqui5210]

I tried doing the same with 7000+ records but results are inaccurate

[@tawahiri6681]

Hi there, I have a channel myself but in a different language. You did a good video but I think you get lost in your thoughts. At least, sometimes. Try to have a script, you can use GPT for that. Your video has amazing content, but it's not getting what you deserve. I wish you all the best. 😊 Cya

[@makrdev]

Hey Tawahiri, thank you for your feedback. It’s a definitely constructive one. Could you elaborate on the “getting lost on thoughts”? It would be great to get hundred percent of your feedback for me :)

[@tawahiri6681]

@@makrdev totally. I'll explain in details with examples. Give me a few hours. 😊

[@makrdev]

@@tawahiri6681 You are so kind and helpful 🤗 I look forward to hearing from you.