I just tested modifying a table in my PostgreSQL db through DBeaver and it seems to have broken the db when looking at the data from the Hasura (Graphql) console. I simply added a column from Dbeav...

I have data in a .csv file that I want to import into my Hasura cluster's PostgreSQL database instance. What's the best way to do this?

I'm trying to add a new project with a connected user assigned to a project but I continue to receive an error 'GraphQL error: field "user_id" not found in type: 'projects_insert_input'' Each proj...

I am currently trying to create an interface wherein a user is able to append additional metadata descriptors to an object while in a modal and need to reflect the results of this append elsewhere ...

A content-type "Product" having the following fields: string title int qty string description double price Is there an API endpoint to retrieve the structure or schema of the "Prod...

I would like to override a the jsonb type for a speficic field in a graphql schema produced by Hasura and run through graphql-code-generator. I have a customList field of type jsonb. Ths is used t...

I am new to graphql hasura and i'm having this issue how to update multiple rows in one table, because usually i update only one row per table. i want to update multiple rows in a dynamic way I h...

Has anyone successfully placed a Hasura GraphQL endpoint, behind an Apollo Federated Gateway? I know Hasura wants to act as the point of federation but I would rather not do that...current thought ...

I am trying to compose a Docker file with a YML file as below. version: '3.6' services: postgres: image: postgres:12 restart: always volumes: - db_data:/var/lib/postgresql/data environment: ...

I want to take a pg_dump of my data from HasuraDB to my local machine. What is the recommended way to do this ?

I have a query like this: query getUsers ($setId: Int) { user(where: { user_sets: { set_id: { _in: [$setId] } } }) { id name status user_sets { set { name } } # more fields... } } Wha...

Example: upload file to server and save resulting path to the database, only authenticated users should be able to upload files How to implement this?

I am using firebase auth and functions for my project. My database api is with a different provider. I need to make some calls to my database from functions as "admin". My server is set up to verif...

I want to limit inserts into a PostgreSQL table department for individual users(business) using a trigger function. Each business should be able to create a maximum of 5 departments. I am trying to...

I have the following Query: query { table1(where: {table2: {id: {}}}) { id } } There is a relationship between table1 and table2 via a foreign key. That is, in table2 I have a column named tab...

I have three models User, Post, Vote I tried to create a role-based authorization where the author (the user who creates a post/blog) can't vote for their own post/blog. To identify users, I use...

We are using Hasura to provide our GraphQL API to consumers. Currently we use Auth0 to authenticate users, but we would like to migrate to Azure AD B2C. A requirement of JWT security with Hasura i...

I'm looking for the way to run Hasura without Docker, but can't find any way to do that - is there any option to achieve that? Have a negative experience with Prisma in Docker, would like to try H...

If i understand correctly, to authorize a query or mutation in hasura using JWT, there are a few requirements that needs to be fulfilled in the request itself, which is: The JWT itself, presente...

In my hasura.io database, I have a booking table, where I store bookings with the following properties: id (autoincrement) from (timestamptz) to (timestamptz) description (text) Now, from the U...

I have created custom sql function in hasura and tracked it. But need to write table name in "RETURNS SETOF <table-name>" (Refer: https://docs.hasura.io/1.0/graphql/manual/schema/custom-funct...

Is it possible in GraphQL or Hasura to group the results by month or year? I'm currently getting the result list back as a flat array, sorted by the date attribute of the model. However, I'd like t...

The docs describe that hasura needs the postgres connection string with the HASURA_GRAPHQL_DATABASE_URL env var. Example: docker run -d -p 8080:8080 \ -e HASURA_GRAPHQL_DATABASE_URL=postgres://u...

i am new to graphql and i am having this issue and don't know how to solve it. for example i have two tables: book and book_author; book has book_id and name book_author has book_author_id, book_...

I'm completely new to web development and have never implemented anything that needs some kind of authentication before - basically, where the user can sign up, log in and log out. I've stumbled a...