Episode
Semantic search with Django, PostgreSQL, & pgvector
with Paolo Melchiorre
Video of a conference talk about semantic search with Django, PostgreSQL, and pgvector presented by Paolo Melchiorre at POSETTE: An Event for Postgres 2024. Artificial intelligence is now a required functionality in many fields, and we often find ourselves needing to add to existing projects.
The first problem to face is that of having to store the vectors, there are vector databases ready to use, but they also introduce new problems, fortunately pgvector allows us to continue to exploit PostgreSQL for this purpose.
In this talk we will see how to add semantic search functionality to an existing Python-based web project, in particular Django, with data storage on PostgreSQL.
Paolo is a longtime Python backend developer who contributes to the Django project and gives talks at tech conferences.
He has been a GNU/Linux user for over 20 years, and he uses and promotes Free Software.
Paolo graduated in Software Engineering and is an alumnus of the University of Bologna, Italy.
He has been working in the web for 15 years and is now the CTO of 20tab, a pythonic software company, for which he works remotely.
Chapters
- 00:00 - Intro
- 01:17 - Django
- 02:19 - Flask, FastAPI, etc
- 04:06 - Django - Code
- 09:47 - Django - Administration
- 14:26 - Semantic Search and Vector Databases
- 16:37 - pgvector
Recommended resources
Related episodes
Connect
- Twitter/X – @PosetteConf
- Mastodon - @posetteconf
- Threads – @posetteconf
- Subscribe to the POSETTE News
- Paolo Melchiorre | Twitter/X: @pauloxnet | LinkedIn: /in/paolomelchiorre/ | Mastodon: @paulox
Video of a conference talk about semantic search with Django, PostgreSQL, and pgvector presented by Paolo Melchiorre at POSETTE: An Event for Postgres 2024. Artificial intelligence is now a required functionality in many fields, and we often find ourselves needing to add to existing projects.
The first problem to face is that of having to store the vectors, there are vector databases ready to use, but they also introduce new problems, fortunately pgvector allows us to continue to exploit PostgreSQL for this purpose.
In this talk we will see how to add semantic search functionality to an existing Python-based web project, in particular Django, with data storage on PostgreSQL.
Paolo is a longtime Python backend developer who contributes to the Django project and gives talks at tech conferences.
He has been a GNU/Linux user for over 20 years, and he uses and promotes Free Software.
Paolo graduated in Software Engineering and is an alumnus of the University of Bologna, Italy.
He has been working in the web for 15 years and is now the CTO of 20tab, a pythonic software company, for which he works remotely.
Chapters
- 00:00 - Intro
- 01:17 - Django
- 02:19 - Flask, FastAPI, etc
- 04:06 - Django - Code
- 09:47 - Django - Administration
- 14:26 - Semantic Search and Vector Databases
- 16:37 - pgvector
Recommended resources
Related episodes
Connect
- Twitter/X – @PosetteConf
- Mastodon - @posetteconf
- Threads – @posetteconf
- Subscribe to the POSETTE News
- Paolo Melchiorre | Twitter/X: @pauloxnet | LinkedIn: /in/paolomelchiorre/ | Mastodon: @paulox
Have feedback? Submit an issue here.