A GraphQL API created by reflection over a PostgreSQL schema. Formerly PostGraphQL.
Questions tagged [postgraphile]
118 questions
0
votes
1 answer
GraphQL Query Structure to Filter / Aggregate Results from a PostgreSQL Table
I am new to GraphQL and I am struggling to understand how to access / reference a table in the same logical way that I would approach a normal SQL query. I have created a docker container for postgres and I have initialized the database with a…
Torc
- 1,148
- 6
- 20
- 43
0
votes
1 answer
Graphql Creating 2 entries with 1 mutation
I've not encountered this before, but simply 1 mutation will create 2 entries:
scheme.json:
{
"name": "createAdminConfigCategory",
"description": "Creates a single `AdminConfigCategory`.",
"args": [
{
"name":…
Jamie Hutber
- 26,790
- 46
- 179
- 291
0
votes
2 answers
Making relational queries with Postgraphile
I have the following db setup
events
| event_id | event_name |
|----------|------------|
| 1 | Test |
| 2 | World |
awards
| award_id | event_id | award_name |
|----------|----------|-------------|
| 1 | 1 |…
Jamie Hutber
- 26,790
- 46
- 179
- 291
0
votes
0 answers
Getting JSON value instead of JSON object in resultset of a GraphQL many-to-one query
"employeeByChef" - which is a many-to-one relationship from employee to itself - always returns only one value (scalar) by (relational) definition.
In the JSON response of a GraphQL/Postgraphile query however, a JSON object is being returned (e.g.…
Stefan
- 1,036
- 1
- 10
- 14
0
votes
1 answer
How to implement postgraphile in Express.js
I have not found much documentation about integrating postgraphile in express.js, please if someone knows in a detailed way about integrating these technologies, I would be very grateful. Thank you so much
The documentation only gives me this:
If…
0
votes
1 answer
Update a column value in a Postgres table using Graphql mutation
Basic info: using Postgres in the backend and GraphQL in the front end using Postgraphile.
Need: Use a GraphQL mutation to update a row in the Postgres DB.
Code:
Suppose I have a library_account schema which has book table in Postgres which has…
Raj
- 3,637
- 8
- 29
- 52
0
votes
1 answer
How to use GraphQL Enums in a Non-English language? postgraphile
I am using postgraphile (A library that wraps your Postgres database with GraphQL api), and I have some enums in Hebrew.
As written in GraphQL Specification, Enum Values must be Names - which are limited to the ASCII subset with this regexp:…
Korenz
- 166
- 1
- 2
- 10
0
votes
1 answer
408 timeout error with postgraphile on AWS elastic beanstalk
I'm running postgraphile and apollo to get data for my react app. I am using npm concurrently to run the react server and to run postgraph using the CLI including --cors flag. Everything works fine when i run the app locally. When I upload…
Sdarb
- 173
- 1
- 10
0
votes
1 answer
GraphQL "Must provide a query string" graphql-tag react-apollo
I'm using react-apollo and graphql-tag but something seems to fail. The server is running on express & postgraphile.
Am I doing something wrong?
Postman (working):
{
"query": "{\n allPosts(first:10) {\n nodes {\n \tnodeId,\n id,\n …
Dawid
- 585
- 5
- 26
0
votes
1 answer
Can't connect database with postgraphile
I have a database in pgadmin name "mydatabase" and the tablename is "mytable". It runs in http://127.0.0.1:33859/browser/. I was trying to use postgraphile to connect with it. Here is the code
const express = require("express");
const {…
Proteeti Prova
- 1,079
- 4
- 25
- 49
0
votes
1 answer
Access Docker Container from Google Cloud
I'm running Docker containers on a Google Cloud instance using Docker Compose.
Here is the instance:
And here are the containers running:
$ docker-compose up -d db graphql api
Creating mobydq-db ... done
Creating mobydq-graphql ... done
Creating…
Alexis.Rolland
- 5,724
- 6
- 50
- 77
-1
votes
1 answer
PostGraphile subscriptions - what does "topic" refer to?
I'm using PgPubsub and I'm trying to get my head around listen and topic*:"" vis-a-vis what to put there.
For example, let's say I have a component that renders a list of and I want to update the list when a Post is created or…
Kirk Ross
- 6,413
- 13
- 61
- 104
-1
votes
1 answer
Http failure response for xxx 0 Unknown Error
PostGraphile v4.9.2 server listening on port 5001
‣ GraphQL API: http://0.0.0.0:5001/graphql
how can i change http to https. i mean, i want https://0.0.0.0:5001/graphql
because, i am getting error while debugging my ionic capacitor app for…
Mustafa Ülker
- 17
- 5