Search⌘ K
AI Features
Home
Courses
Building a GraphQL Endpoint with Deno

Solution: Postgres and Deno

Explore how to establish a PostgreSQL connection in Deno, define GraphQL types for a Car entity, and implement resolvers with queries and mutations. This lesson guides you through creating a functional GraphQL endpoint backed by PostgreSQL.

We'll cover the following...

To solve this challenge, we need to follow the three steps given below.

Step1: Establishing a Postgres connection

First, we need to establish a Postgres connection and create the required table for the Car entity:

TypeScript 3.3.4
import { Client } from "https://deno.land/x/postgres/mod.ts";
const client = new Client({
  user: "postgres",
  database: "postgres",
  hostname: "localhost",
  port: 5432,
});
await client.connect();
// Create table cars
await client.queryArray("CREATE TABLE Cars(id SERIAL PRIMARY KEY, model varchar(255), registration varchar(255));");

Explanation

  • Lines 3–8: We define the Postgres connection.
  • Line 10: We connect to the Postgres database.
  • Line 13:
...