[GHW Builder's Week] Build a Hybrid Search Engine in Postgres

Event Description

Most apps need search, but keyword search only matches exact words and AI-powered vector search can miss the obvious ones. In this hands-on session, Justin Mitchel builds a search engine that does both inside a single Postgres database, using Tiger Data’s open-source pg_textsearch for keyword ranking and the new pg_vectorsearch (alpha) for semantic search. You’ll leave with working SQL you can drop into your hackathon project, no search or AI experience required.

Livestreams and Mini Events

Throughout GHW, we'll have daily workshops live-streamed on our Twitch to give you the chance to pick up new skills and build something together with the community. In between workshops, we'll run mini-events in the MLH Community Discord for you to join in and meet friends as you take a break from hacking.

Challenges and Points

At GHW: BUILDERS Week we will have plenty of challenges to keep you busy. Challenges will range from social challenges urging you to connect with other members of the community, technical challenges that will expand your coding skills, and design challenges to refine your skills as a creator and artist. Some of these challenges will be completed live on our twitch stream, so you can follow along and complete it with the community. We cannot wait to see all that you learn, build, and share.

Earn experience points for yourself by completing our challenges throughout GHW. Challenges aren’t the only way to earn points. You can also receive a point each time you check in for a live session, so the more you attend, the more points you’ll rack up. They can be as simple as posting on your social media or as advanced as building a project and creating a full demo video for it. We’ll leave it to you to choose which challenges you want to take on. Feel free to work collaboratively with others on these.