当前位置：首页 > article >正文

docker安装postgres扩展age以及使用nodejs连接

article 2024/10/26 1:16:42

官网: https://age.apache.org/age-manual/master/advanced/plpgsql.html

GitHub: https://github.com/apache/age/blob/master/README.md

docker pull apache/age

docker run
–name myPostgresDb
-p 5455:5432
-e POSTGRES_USER=postgresUser
-e POSTGRES_PASSWORD=postgresPW
-e POSTGRES_DB=postgresDB
-d
apache/age

LOAD ‘age’;

SET search_path = ag_catalog, “$user”, public; # 简化查询，设置用户public，后面对该用户进行授权

grant usage on schema ag_catelog to db_user(public) # 授权用户 public

新开一个窗口

docker exec -it age psql -d postgresDB -U PostgresUser

ln -s /usr/lib/postgresql/16/lib/age.so /usr/lib/postgresql/16/lib/plugins/age.so # 创建符号链接，允许非超级用户加载age库

这里替换为你自己的版本，以及mkdir一下plugins目录

使用age的nodejs-sdk连接，没有npm包。整个下载下来copy到项目中，可以link，也可以直接引入。

pnpm install pg config debug

config/default.json

{
  "age":{
      "user": "postgresUser",
      "host": "127.0.0.1",
      "database": "postgresDB",
      "password": "postgresPW",
      "port": "5455"
  }
}

import pg from 'pg'
import config from "config"
import debug from 'debug'
import { setAGETypes } from '../nodejs-pg-age/dist/index.js'
const { types, Client } = pg
const dbConfig = config['age']

function createDebug(moduleName) {
  return debug('age').extend(moduleName);
}

async function main () {
  const debug = createDebug('main')
  const client = new Client(dbConfig)
  await client.connect()
  await setAGETypes(client, types)
  let ret = await client.query(`SELECT * 
FROM cypher('graph_name', $$
    MATCH (a:label), (b:label)
    WHERE a.property = 'Node A' AND b.property = 'Node B'
    CREATE (a)-[e:RELTYPE {property:a.property + '<->' + b.property}]->(b)
    RETURN e
$$) as (e agtype);`)
    if (ret?.rowCount > 0) {
      debug(ret.rows);
    }
}

main()
  .then((data) => console.log(data))
  .catch(err => console.error(err))

{
	"name": "age-crud",
	"version": "1.0.0",
	"description": "",
	"main": "./src/index.js",
	"author": "hjj",
	"license": "ISC",
	"type": "module",
	"scripts": {
		"start": "DEBUG=age:* DEBUG_DEPTH=5 node ./src/index.js"
	},
	"dependencies": {
		"config": "^3.3.12",
		"debug": "^4.3.7",
		"pg": "^8.12.0"
	}
}