Magic UI
Back to all articles
Headless

Hasura拓展记录

Hasura拓展记录

Hasura拓展记录

如何横向拓展

docs: guide on horizontal scaling & auto-scaling · Issue #1183 · hasura/graphql-engine
Guide on horizontally scaling Hasura, setting up auto-scale and benchmarking how fast auto-scale works on a substrate like GKE.
GitHub · hasura

创建自定义function

CREATE FUNCTION npmvs.lucky_packages(num int)
RETURNS SETOF npmvs.package AS $$
  select * from npmvs.package order by random() limit num
$$ LANGUAGE sql STABLE;

字段无法删除的可能

  • 在权限中配置了该字段

本地调试服务器

docker run --name some-postgres -d -p 5432:5432 -e POSTGRES_PASSWORD=mysecretpassword -d postgres
docker run -d -p 8080:8080 --name hasura-server \
  -e HASURA_GRAPHQL_DATABASE_URL="postgres://postgres:mysecretpassword@192.168.215.2:5432/postgres" \
  -e HASURA_GRAPHQL_ENABLE_CONSOLE=true \
  -e HASURA_GRAPHQL_DEV_MODE=true \
  -e HASURA_GRAPHQL_LOG_LEVEL=debug \
  -e HASURA_GRAPHQL_ADMIN_SECRET=pbWht7xAbLkLV2cT \
  hasura/graphql-engine:v2.42.0