garapadev/postgres-postgis-pgvector repository overview

# PostgreSQL 15 (Recommended)
docker run -d -p 5432:5432 -e POSTGRES_PASSWORD=password garapadev/postgres-postgis-pgvector:15-stable

# PostgreSQL 16 (Latest)
docker run -d -p 5432:5432 -e POSTGRES_PASSWORD=password garapadev/postgres-postgis-pgvector:latest

-- Vector similarity search
CREATE TABLE documents (
    id SERIAL PRIMARY KEY,
    content TEXT,
    embedding VECTOR(1536)
);

SELECT content FROM documents 
ORDER BY embedding <=> '[0.1,0.2,...]'::vector 
LIMIT 5;

-- Spatial queries
CREATE TABLE locations (
    id SERIAL PRIMARY KEY,
    name TEXT,
    geom GEOMETRY(POINT, 4326)
);

SELECT name FROM locations 
WHERE ST_DWithin(geom::geography, ST_MakePoint(-46.6, -23.5)::geography, 1000);

-- Combine spatial + vector search
SELECT name, 
    ST_Distance(geom::geography, point::geography) as distance,
    1 - (embedding <=> query_vector) as similarity
FROM places 
WHERE ST_DWithin(geom::geography, point::geography, 5000)
ORDER BY embedding <=> query_vector
LIMIT 10;

version: '3.8'
services:
  postgres:
    image: garapadev/postgres-postgis-pgvector:15-stable
    environment:
      POSTGRES_PASSWORD: your_password
      POSTGRES_DB: myapp
    ports:
      - "5432:5432"
    volumes:
      - postgres_data:/var/lib/postgresql/data

volumes:
  postgres_data:

-- Check versions
SELECT version();
SELECT PostGIS_Full_Version();
\dx

-- Test PostGIS
SELECT ST_AsText(ST_MakePoint(-46.6333, -23.5505));

-- Test pgvector
SELECT '[1,2,3]'::vector <-> '[4,5,6]'::vector;