pgadmin4 err

err

(sqlite3.IntegrityError) UNIQUE constraint failed: database.id, database.server
[SQL: INSERT INTO "database" (id, schema_res, server) VALUES (?, ?, ?)]
[parameters: (16384, '', 19)]
(Background on this error at: http://sqlalche.me/e/13/gkpj)

PostGraphile

-------------------------------------------------------

node.js

https://www.digitalocean.com/community/tutorials/how-to-install-node-js-on-ubuntu-20-04-ja

sudo apt update

sudo apt install nodejs

-------------------------------------------------------

npm install -g postgraphile

-------------------------------------------------------

PostgreSQLとPostGraphileでサクッとGraphQLエンドポイントを作成する

https://qiita.com/notakaos/items/2480488f8188f5a71081

-------------------------------------------------------

sudo gedit !/usr/bin/env bash

#!/usr/bin/env bash

pnpx postgraphile \

  --connection postgres:///postgres \

  --watch

-------------------------------------------------------

‣ GraphQL API:         http://localhost:5000/graphql

  ‣ GraphiQL GUI/IDE:    http://localhost:5000/graphiql

  ‣ Postgres connection: postgres://postgres:[SECRET]@localhost/mydb (watching)

  ‣ Postgres schema(s):  public

  ‣ Documentation:       https://graphile.org/postgraphile/introduction/

  ‣ Node.js version:     v10.19.0 on linux x64

  ‣ Join Robert Claypool in supporting PostGraphile development: https://graphile.org/sponsor/

  

  

  

  

  

ubuntu20.04 pgAdmin4

ubuntu20.04にpostgreSQLとpgAdmin

https://postgresweb.com/install-pgadmin4-ubuntu-20-04

---

sudo curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add

sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'

sudo apt install pgadmin4

 sudo /usr/pgadmin4/bin/setup-web.sh

mail

pass

---