I'm lazy

Get started with ParadeDB extensions

2023-10-12

Introduction

I got really interested in the ParadeDB project. It brings into the PostgreSQL world the power of the BM25 algorithm as implemented by Tantivy. I've created a Docker image to experiment with the toolchain used.

What's included?

• A Dockerfile
• A docker-compose.yaml file

Instructions

• Run git clone git@github.com:vtripolitakis/paradedb-docker.git
• Go to the paradedb-docker folder
• Run docker compose up -d
• Open a connection to the PostgreSQL using the psql command (password is postgres): psql -U postgres -h localhost
• Create the following extensions inside PostgreSQL

CREATE EXTENSION pg_bm25;
CREATE EXTENSION vector;
CREATE EXTENSION search;

What I can do next?

• Read the great documentation of the extensions used:
  • pg_bm25 from ParadeDB
  • pg_search from ParadeDB
  • pgvector

have fun!