Don't Stop Retrievin': Building lightning-fast search in Postgres
Presented by:
![T04n369fu3v u05rpsts127 1bd6d875a510 512](/system/users/avatar/000/098/316/large/T04N369FU3V-U05RPSTS127-1bd6d875a510-512.jpeg)
Neil Hansen
A background in film and music unexpectedly became a life-long passion for writing programs that delight users and live forever in the open-source.
Today, I'm the Founding Engineer at ParadeDB, where I build pg_search
, a full-text search engine for Postgres.
No video of the event yet, sorry!
In this talk, we'll explore the incredible extensibility of PostgreSQL by demonstrating how ParadeDB built advanced full-text search capabilities into the database. Using pg_search
, our open-source Postgres extension, we'll showcase a real-world application: a blazingly fast search interface for MusicBrainz, the open encyclopedia of music.
Key points we'll cover:
- The challenges of implementing efficient search in large datasets
- How ParadeDB leverages and extends Postgres' native functionality
- Building a responsive user interface for searching the MusicBrainz database
- Performance comparisons between traditional Postgres search and ParadeDB-enhanced search
- The broader implications of integrating powerful search directly within your database
This presentation will highlight the potential of keeping your data and search capabilities unified, eliminating the need for complex ETL processes or separate search engines. We'll discuss how this approach can simplify architectures, reduce operational overhead, and open up new possibilities for developers and data teams.
- Date:
- 2024 November 6 17:30 PST
- Duration:
- 20 min
- Room:
- Dev: 422
- Conference:
- Seattle 2024
- Language:
- Track:
- Dev
- Difficulty:
- Easy