dawsonlp/postgres-batteries-inc repository overview

docker run -d \
  --name postgres \
  -e POSTGRES_PASSWORD=mysecretpassword \
  -e POSTGRES_DB=mydb \
  -p 5432:5432 \
  dawsonlp/postgres-batteries-inc:latest

-- Vector similarity search
SELECT * FROM sample_vectors ORDER BY embedding <=> query_vector LIMIT 10;

-- Spatial query (find within 1km)
SELECT * FROM sample_locations
WHERE ST_DWithin(point, ST_MakePoint(-122.42, 37.77)::geography, 1000);

-- Graph query (Cypher)
SELECT * FROM cypher('sample_graph', $$
  CREATE (a:Person {name: 'Alice'})-[:KNOWS]->(b:Person {name: 'Bob'})
  RETURN a, b
$$) AS (a agtype, b agtype);

-- Full-text search
SELECT * FROM sample_documents
WHERE search_vector @@ plainto_tsquery('english', 'search terms');

-- Shortest path routing
SELECT * FROM pgr_dijkstra(
  'SELECT id, source, target, cost FROM sample_roads',
  start_id, end_id
);