darthveitcher/postdata repository overview

⁠PostData

PostgreSQL as a Data Science all-in-one service.

⁠Features:

• PostgreSQL base
  • Pgpool-II for clustering
• Spatial capabilities for GIS via PostGIS extension⁠
• Vector storage and search via PGVector extension⁠
• Graph database via Age extension⁠

⁠Quickstart

Set the usual Postgres environment variables such as:

• POSTGRES_DB
• POSTGRES_USER
• POSTGRES_PASSWORD

The image will initialise the extensions at runtime, automatically grant the POSTGRES_USER the ability to use the graph catalog, and extend the search_path to include it (so you can just write SELECT create_graph('new_graph'); as opposed to needing to prefix the cypher commands with the schema ag_catalog).

⁠Example

docker run --rm -p 5432:5432 -e POSTGRES_PASSWORD=this1sntSecure darthveitcher/postdata

Connect now with your password, the default user (postgres) and the default database (postgres) and run some example commands.

-- Create a new graph
SELECT * FROM create_graph('new_graph');

>>> graph "new_graph" has been created

-- Create and return a new person
SELECT * 
FROM cypher('new_graph', $$
    CREATE (a {name: 'Andres'})
    RETURN a
$$) as (a agtype);

{"id": 281474976710657, "label": "", "properties": {"name": "Andres"}}::vertex