Stack Overflow
Stack Overflow

Questions tagged [hasura]

Hasura is an open-source tool that provides instant realtime GraphQL APIs and webhook event triggers on Postgres.

Hasura

Hasura provides a scalable and performant GraphQL API out of the box. It can run up to 1mio concurrent subscriptions, scaling vertically & horizontally seamlessly. It comes with a comprehensive permission system that allows you to enforce fine-grained access control. Authentication can be integrated using webhooks or JWT. Hasura also allows you to extend your GraphQL API with business logic through remote schemas (other GraphQL servers), actions (REST APIs) or even custom functions in Postgres. Event triggers make it possible to trigger business logic that is running in serverless functions.

Hasura runs in a Docker container and can be deployed to any cloud provider that runs Docker, or it can be run locally. Use Hasura migrations to migrate from your development environment to production, as well as for version control.

Tech stack

  • The Hasura server which serves the GraphQL API is written in #Haskell. It takes declarative configuration.
  • The Hasura console allows you to configure the Hasura server, manage your Postgres database and test your APIs. It's built with #React.
  • The Hasura CLI that is used for the CI/CD and migration workflows is written in #Go.

Useful links

Initial release

3rd July 2018.

729 questions
0
votes
2 answers

Creating Many-To-Many Relationships in Hasura

I was trying to add a many-to-many relationship through a join table on a somewhat more complex set of models, so I tried dumbing it down when it wouldn't work into something with just two properties, and still can't get it to work. Documentation I…
Preston Rodeniser
  • 150
  • 1
  • 11
0
votes
2 answers

Hasura object permission based authorization

I am trying to set a "Row Select" permissions on Hasura. I have a (simplified for brevity) Data Model like below User id: UserID App id: AppID App Permissions user_id: User ID app_id: App ID permissions: [ ENUM: Admin, View, Owner ] Feed app_id:…
Abhishek
  • 2,543
  • 4
  • 34
  • 46
0
votes
2 answers

Issue configuring JWT secret with claims_map in Hasura Docker compose

I am trying to set claims_map in HASURA_GRAPHQL_JWT_SECRET in my docker compose file using the below config HASURA_GRAPHQL_JWT_SECRET:…
Rolwin Crasta
  • 4,219
  • 3
  • 35
  • 45
0
votes
1 answer

PostgreSQL Hasura Computed field operator does not exist: bigint = text

I'm trying to make a reservation function for a computed field in Hasura (PostgreSQL). The code I'm trying to make gets the game_length from the table rooms and returns a timestamp with the game_length + start_time. However, I am new to functions in…
Logan Rios
  • 87
  • 10
0
votes
1 answer

How to ORDER BY an unaggregated column in subquery?

I'm trying to create a function in Hasura that queries the posts near a user. I got that working but I would also like to order the posts. I get a Postgres error that says: "postgres-error : column "b.Volume" must appear in the GROUP BY clause or…
T. Tim
  • 43
  • 6
0
votes
1 answer

Apollo ios codegen generates optional values

I'm trying with all the latest version of apollo-ios but i'd like to solve this one lingering problem: I keep getting optional values (see image below). Here's what I've explored (but still can't find whyyy) When I created the table, Nullable is…
Vina
  • 920
  • 1
  • 9
  • 12
0
votes
1 answer

Hasura aggregation in related tables

I was evaluating Hasura GraphQL engine + Postgres on Heroku and have run into a situation. I have 2 simple tables as shown below; Employees Payrolls Employees table and Payrolls have a foreign key employees.ID -> payrolls.employee_id Employees…
Deepak Champatiray
  • 121
  • 5
0
votes
1 answer

Is there a limit in Hasura for aggregation queries?

Hi everyone I was in a bit of conflict today on wether to use graphQL or not. The situation is I am working on a really large database and at this point I was wondering if there's a limit to consider in aggregation queries (where you get the count)…
jose fernandez
  • 41
  • 1
  • 6
0
votes
1 answer

Hasura - Postgres database table auto increment PK problem

I have a quite a interesting problem regarding table primary key when inserting new rows to Postgres DB using Hasura. In a short summary this is what happened: There was old backend for the app that I am currently developing which used MySql…
Borisa Krstic
  • 58
  • 4
0
votes
1 answer

Hasura 2.0, is there a way to use wildcards?

Hello everyone I am having some issues with the way I used to query my data before updating to Hasura 2.0 (I am currently on Beta 1), so Before 2.0 if you sent a null value to a query it would act as a wildcard * , now that I updated to 2.0 all…
jose fernandez
  • 41
  • 1
  • 6
0
votes
0 answers

Large number causing potential overflow in Hasura

I'm using Hasura to connect to my Postgres database and I'm trialling a few queries using the Hasura console and I've noticed when I query for my id column which is stored as a 64-bit integer the number is coming through incomplete almost. For…
SkinnyBetas
  • 461
  • 1
  • 5
  • 27
0
votes
1 answer

Check if userhandle exists in sql database using hasura

I am trying to check if a userhandle already exists in the database as part of registration process of my users (the userhandle has to be unique). I am using Hasura and trying to write a custom SQL function that should return a boolean (true or…
Svarto
  • 603
  • 2
  • 8
  • 20
0
votes
2 answers

How to run hasura console on a different port when using docker

I am writing this question because I couldn't find a way to change the default Hasura console port when using Hasura docker image. The page I'm referring is this There is no variable defined to change the Hasura default console port in the above…
Dulara Malindu
  • 1,477
  • 4
  • 18
  • 37
0
votes
2 answers

Find duplicate entries in a column in PostgreSQL graphql hasura?

How do i find the Duplicate Values in One Column in PostgreSQL GraphQL Hasura. i know there is a Groupby in SQL but do i do in this case?
Agam Sahu
  • 13
  • 4
0
votes
1 answer

How to set Update_column to Object level in hasura Upsert mutation

how we can set seperate update_columns list for each object inside the array object while using on_conflct upsert? eg: i have a table called User and it have fields like id,name and age Requirement: in the upsert action i need to upsert a list of…
Sarath Baiju
  • 226
  • 2
  • 9
1 2 3
…
48 49