This repo contains a LocalStack Extension that facilitates developing ParadeDB-based applications locally.

ParadeDB is an Elasticsearch alternative built on Postgres. It provides full-text search with BM25 scoring, hybrid search combining semantic and keyword search, and real-time analytics capabilities.

After installing the extension, a ParadeDB server instance will become available and can be accessed using standard PostgreSQL clients.

Once the extension is running, you can connect to ParadeDB using any PostgreSQL client with the following default credentials:

• Host: localhost (or the Docker host if running in a container)
• Port: 5432 (mapped from the container)
• Database: mydatabase
• Username: myuser
• Password: mypassword

Example connection using psql:

psql -h localhost -p 5432 -U myuser -d mydatabase

Example connection using Python:

import psycopg2

conn = psycopg2.connect(
    host="localhost",
    port=5432,
    database="mydatabase",
    user="myuser",
    password="mypassword"
)

ParadeDB includes the pg_search extension, for both search and analytics workloads.

Example of BM25 scoring, from the excellent quickstart guide:

CALL paradedb.create_bm25_test_table(
  schema_name => 'public',
  table_name => 'mock_items'
);

CREATE INDEX search_idx ON mock_items
USING bm25 (id, description, category, rating, in_stock, created_at, metadata, weight_range)
WITH (key_field='id');

SELECT description, pdb.score(id)
FROM mock_items
WHERE description ||| 'running shoes' AND rating > 2
ORDER BY score DESC
LIMIT 5;

The following environment variables can be passed to the LocalStack container to configure the extension:

• PARADEDB_POSTGRES_USER: PostgreSQL username (default: myuser)
• PARADEDB_POSTGRES_PASSWORD: PostgreSQL password (default: mypassword)
• PARADEDB_POSTGRES_DB: Default database name (default: mydatabase)

• Docker
• LocalStack Pro (free trial available)
• localstack CLI
• make

This extension can be installed directly from this Github repo via:

localstack extensions install "git+https://github.com/localstack/localstack-extensions.git#egg=localstack-extension-paradedb&subdirectory=paradedb"

Please refer to the docs here for instructions on how to start the extension in developer mode.

• 0.1.0: Initial version of the extension

The code in this repo is available under the Apache 2.0 license.