Tag: postgresql
-
no such column exists for PostgreSQL db in Hasura (Graphql) console when adding column via DBeaver
6 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 Dbeaver. In Hasura I get an error "no such column exists". Anyone have any idea why or how…
-
Remote Node.JS Developer opening – ClearBridge Technology Group – Remote
ClearBridge Technology Group Remote Depends on Experience Contract: W2, Independent Skills GraphQL Node . JS PostgreSQL Job Description Our client, a large advertising firm, is looking to hire 2 Senior Backend developers for a 5 month remote contracts supporting multiple projects. The developers will be responsible for the development of core and critical features for…
-
Golang Developer – Cigniti Technologies Inc – Plano, TX
Cigniti Technologies Inc Plano, TX $60 – $65 Accepts corp to corp applications, Contract: Independent, W2, 12 Month(s) Skills GoLang GraphQL PostgreSQL unit testing Multi – Threading Amazon Web Services gorilla Job Description Job Title: Golang Developer Duration: 12+ months contract Location: Plano, TX (DAY 1 ONSITE) In-person Interview is a must Job…
-
hasura-v2.xx gives graphql-engine-1 exited with code 1 on `hasura metadata track …`
0 I’m trying to get started with Hasura. So here is my docker-compose.yml file: version: "3.6" services: postgres: image: postgres:15 restart: always volumes: – db_data:/var/lib/postgresql/data environment: POSTGRES_PASSWORD: postgrespassword graphql-engine: build: context: . dockerfile: DockerfileHasura # command: /bin/sh -c ‘hasura metadata track –all-tables –all-relationships –schema public –endpoint https://graphql-engine:8080 && exec graphql-engine serve’ command: /bin/sh -c ‘exec…
-
GraphQLError: Query root type must be provided
37 I’m using NestJS, TypeORM and GraphQL for my backend API. I’m getting the following error: GraphQLError [Object]: Query root type must be provided. at SchemaValidationContext.reportError (/home/wise-introvert/Container/Projects/the-notebook/app/server/node_modules/graphql/type/validate.js:88:19) at validateRootTypes (/home/wise-introvert/Container/Projects/the-notebook/app/server/node_modules/graphql/type/validate.js:107:13) at validateSchema (/home/wise-introvert/Container/Projects/the-notebook/app/server/node_modules/graphql/type/validate.js:52:3) at graphqlImpl (/home/wise-introvert/Container/Projects/the-notebook/app/server/node_modules/graphql/graphql.js:79:62) at /home/wise-introvert/Container/Projects/the-notebook/app/server/node_modules/graphql/graphql.js:28:59 at new Promise (<anonymous>) at Object.graphql (/home/wise-introvert/Container/Projects/the-notebook/app/server/node_modules/graphql/graphql.js:26:10) at GraphQLSchemaFactory.<anonymous> (/home/wise-introvert/Container/Projects/the-notebook/app/server/node_modules/@nestjs/graphql/dist/schema-builder/graphql-schema.factory.js:49:52) at Generator.next (<anonymous>) at /home/wise-introvert/Container/Projects/the-notebook/app/server/node_modules/tslib/tslib.js:114:75 This is…
-
Is it bad to add your postgres connection directly in your graphql resolver?
0 If I wanted to use the lower level Postgres package from NPM called pg inside my Apollo server so I don’t have to use an ORM. Is it considered bad practice to pass the connection into the resolver directly? Example: // ./db/index.ts import { Pool } from ‘pg’ const pool = new Pool({ user:…
-
How to do counts in batch for graphql data loader?
0 I’m implementing a Graphql resolver for complex datatype. I try to use a data loader to avoid N+1 problem. I have a datatype with a counter. Therefore, in one graphql query I need to perform user counting multiple times for defferent types. Currently, I’m trying to combine multiple COUNT(*) queries within one SQL query.…
-
React Native lead with Postgres exp – New York Technology Partners – Remote
New York Technology Partners Remote Depends on Experience Contract: Independent, W2 Skills React Native GraphQL Json AP Reactnative Postgres PostgreSQL Job Description Required skills: Reactjs, Nodejs, Postgres, Next js, Java, JavaScript, Jenkins, Git, Microservices, SSO, security, Postgres, GraphQL/Json API, Excellent Debugging skill. React Native, GraphQL/Json AP Description:- Deliver Innovative technology solutions to complex…
-
How to query a date/time field using pothos with prisma and postgresql
0 I’ve got my pothos set up using Prisma and postgresql. I’m trying to expose the createdAt and updatedAt fields from prisma in my builder: Prisma schema: model Course { id Int @id @unique @default(autoincrement()) createdAt DateTime @default(now()) updatedAt DateTime @updatedAt // removed fields for brevity. } My builder: builder.prismaObject(‘Course’, { fields: (t) => ({…
-
Does it make sence to use data loader for multiple counts?
0 I’m implementing a Graphql resolver for complex datatype. I try to use a data loader to avoid N+1 problem. I have a datatype with a counter. Therefore, in one graphql query I need to perform user counting multiple times for defferent types. Currently, I’m trying to combine multiple COUNT(*) queries within one SQL query.…