A GraphQL API created by reflection over a PostgreSQL schema. Formerly PostGraphQL.
Questions tagged [postgraphile]
118 questions
1
vote
1 answer
Retain trailing 's' for table in Postgraphile
Is there a way to disable the 'remove-the-plural-s' feature in Postgraphile?
I have a table OS in my database and am using the very awesome Postgraphile library to create a GraphQL interface for free. Everything is great, but Postgraphile is…
slushy
- 3,277
- 1
- 18
- 24
1
vote
1 answer
GraphQL - Cannot update a table row
Say I have a table Person with attributes id and name. The GraphQL server is all setup by Postgraphile and working as I can query and create new entry. However, I could not update it. Scratching my head over and over again and I am still unable to…
Da_Pz
- 698
- 5
- 13
0
votes
1 answer
Accessing Postgraphile (as a library) with Apollo client from the same server
I have postgraphile running on an express server (as a library)
export const postGraphileServer = () => {
return postgraphile(process.env.DB_DSN, 'public', options);
};
Express:
app.use(postGraphileServer());
Using the codegen introspection…
Greg
- 284
- 6
- 23
0
votes
1 answer
Or filtering with PostGraphile not working
I am trying to search multiple fields in one query with the use of the OR and filter.
query SearchQuery($searchTerm: String) {
allArtists(
filter: {surname: {includesInsensitive: $searchTerm}, or: {firstname: {includesInsensitive: …
Jamie Hutber
- 26,790
- 46
- 179
- 291
0
votes
0 answers
Using strings rather than Enums doesn't work with postgraphile
I am trying to sort some of my results but using a string the sortby is ignored.
query ($limit: Int!, $categoryId: Int) {
allAwards(first: $limit, orderBy: "DATE_DESC") {
edges {
{
"errors": [
{
"message": "Enum \"AwardsOrderBy\"…
Jamie Hutber
- 26,790
- 46
- 179
- 291
0
votes
1 answer
Postgraphile StatusCode: 405, ReasonPhrase: 'Method Not Allowed
I use Postgraphile locally and it work very well.
I want to send a HttpClient post requset in my Application, but it does not work and I get this error:
StatusCode: 405, ReasonPhrase: 'Method Not Allowed
hier is my code:
using (HttpClient…
Mohammad Almasi
- 400
- 6
- 19
0
votes
1 answer
Read-Only Postgraphile-CLI API
I am currently implementing a public API for a Open Data Platform with Postgraphile creating the needed API for me. The API should be completly public, with no authentification whatsoever and because of that the API should only implement read-only…
Grigorios
- 3
- 4
0
votes
0 answers
Cannot connect to local host in Postgres
Trying to run PostGraphile locally, but whenever I run psql "postgres:///", it queries me for a password for a user, I enter the password, and it says it's wrong, though I know I entered it correctly.
psql: error: connection to server at "localhost"…
plutomonk
- 1
- 2
0
votes
0 answers
Filter the connected list in Postgraphile
how can i set up filtering on top level in postgraphile i have such graphql query but if i filter data on bottom level i get a lot of unnecessary information and totalCount is not counted correctly. Can you tell me how to set up filtering in topTest…
Chistyakov
- 1
- 1
0
votes
1 answer
Configure postgraphile to support succinct nested mutations
I have come to postgraphile yesterday from a couple of years with Hasura. I was stunned at what PG does out of the box. My main sense of loss is around the GQL api that PG offers, relative to Hasura. If I have Customer with a foreign key to an…
Mike Hogan
- 9,933
- 9
- 41
- 71
0
votes
0 answers
How to achieve multitenancy with postgraphile in NodeJS
I have separate databases for different customers in our project, I want to connect with a specific database on the bases of tenantID (which is already known to me). I have achieved this in Java (spring boot) after going through this…
Deepak Yadav
- 1
- 1
0
votes
2 answers
Pass pgSetting req parameter in Postgraphile Query using graphiql
Hello I am new to postgraphile, I would like to test adding a new attribute user.email to pgSettings on every request. I don't want to use jwt for now.
Here is my .postgraphilerc.js
module.exports = {
options: {
connection:…
Pierre Louis
- 308
- 2
- 11
0
votes
1 answer
Apollo-Client - Error: Could not identify object
Client - React, Apollo-Client, codegen
Server - Postgraphile
The app view list of file objects.
Users can add new file.
I wrote a Query for getting the file objects from the server.
And a Mutation for adding new file.
they both works.
what Im trying…
Itay Tur
- 683
- 1
- 15
- 40
0
votes
1 answer
How to connect self hosted PostgreSQL on AWS EKS to AWS AppSync with auto schema generation and hot reload?
I have research it for several days but could not find a definitive answer for it.
My use case is I have a PostgreSQL database hosted on AWS EKS and I want to expose it using GraphQL, which generally leads to AWS AppSync.
I understand that AppSync…
Sivvie Lim
- 784
- 2
- 14
- 43
0
votes
1 answer
How to use a permanent filter in a List component using and or operator
I'm building a food panel, in which there are some products. Everything was fine until I tried to split the products in postal codes so other users with different postal codes wont see the products not related with their postal code.
Every product…
