Course Introduction

Introduction

Introduction to GraphQL

Using Hasura to Generate GraphQL APIs and Protect Data

How to Create a Comments Database Table and Set Permissions

Storing comments with Hasura

Setting Up Next.js Blog Starter and Understanding Its Structure

Fetching Blog Comments from a Database with a Custom React Hook

A Brief Tutorial on Building the UI for a Blog Comments Section

How to Use GraphQL to Add Comment Features to a Frontend App

Implementing a comments system

An Overview of Optimistic Updates for React Hooks

Adding Pagination to a Comments Section with Hasura and React

Extending the comments system functionality

How to Publish a Custom React Hook as an NPM Library

Coding a Comments Section that Requires Manual Content Approval

Bonus

Summary

react

next.js

### The newline Guide to Full Stack Comments with Hasura and React

Build and implement a comprehensive commenting system for your website using Hasura and React.  We’ll use the commenting feature to teach technology concepts like Hasura with appropriate authorization, optimistic updates for a more responsive UI, pagination, and publication of library in NPM.

### Why this course

Many developers would like to add a comments section to their website or blog for users to post comments or hold discussions. While it's possible to use existing hosted solutions such as Disqus or Facebook Comments, they often charge a fee and impose their UI leaving little to no control for modifications or customization. 

Another option is to build your own from scratch — which is what we'll do in this course. We’ll use Hasura, which generates GraphQL API from a database so that the backend part is as easy and the least time-consuming as possible. Along the way, we’re going to learn about databases, GraphQL, building UI components with React and TypeScript, and more.
By the end of this course, you’ll have a commenting system added to a website we’ve called, Why comments?, with all comments stored by Hasura. We'll also publish the fetching and adding comments logic as a library to NPM.

This course focuses on building a commenting widget, however, the skills you’ll acquire will allow you to build any fullstack widget you can think up for your application.  You’ll be able to contribute to fullstack React, GraphQL, and Hasura projects at work, in open source, or your own projects. You'll discover that this stack not only eliminates the need for having large teams of backend developers, but it lets your projects move faster.

### Your Instructors

Hi, I'm Aleksandra, and I'm your instructor for this course. I’m the former tech lead of Hasura console and lead maintainer of Bliz.js. This course combines my knowledge in a few areas such as TypeScript, React, Hasura, GraphQL, and general application development.

Build and implement a comprehensive commenting system for your website using Hasura and React.  We’ll use the commenting feature to teach technology concepts like Hasura with appropriate authorization, optimistic updates for a more responsive UI, pagination, and publication of library in NPM.

The newline Guide to Full Stack Comments with Hasura and React

Implementing pagination and optimistic updates

Importance of tests, and how to test React components

In previous lessons, we covered GraphQL basics, and we learned about Hasura. We
also created a new Hasura project and played a bit with its functionalities. In
this lesson, we're going back to implementing the commenting systems. We will
use the project created in the previous lesson and create the 

This is an example comment form to help us visualize what data we need to store
in the database. It has two inputs to get information from a user and a submit
button:

Let's look at the comment form and list down what columns we need in the

These two columns are the data from the form, and that could be enough. However,
we may need a bit more:

Now, let's go back to our Hasura project and go to the 

 page.
We're going to fill the form with the information about columns.

We need to provide column names and column types. For columns 

, which allows storing strings
of any length.

---
title: How to Create a Comments Database Table and Set Permissions
isPublicLesson: false
description:
  In this lesson, we'll create a comments table and learn a bit about databases
  along the way.
useMdx: true
privateVideoUrl: https://fullstack.wistia.com/medias/td8z99j17w
---

import { Svg } from '~/components/Svg';

import { SampleForm } from '~/components/SampleForm';

In previous lessons, we covered GraphQL basics, and we learned about Hasura. We
also created a new Hasura project and played a bit with its functionalities. In
this lesson, we're going back to implementing the commenting systems. We will
use the project created in the previous lesson and create the `comments` table
there.

### Table's content

This is an example comment form to help us visualize what data we need to store
in the database. It has two inputs to get information from a user and a submit
button:

<Svg>
  <SampleForm />
</Svg>

Let's look at the comment form and list down what columns we need in the
`comments` table.

-   `author` — comment's author identifier. It could be a name, email, or
    username, however a user would like to introduce themselves. We could go more
    granular here and create separate columns like name, surname, and email, but a
    single author column is good enough!
-   `content` — comment's message.

These two columns are the data from the form, and that could be enough. However,
we may need a bit more:

-   `created_at` — date when the comment was added. It will be important for us to
    sort the comments by the posting date. The value can be sent from the frontend
    application or generated by the database.
-   `topic` — identifier of a post or another content that was commented on.
    Imagine that you have a blog, and users can add comments to each blog post.
    You'd need a way to identify which comments belong to a particular post. By
    storing the topic id, the comment is assigned with a particular resource
    (e.g., blogpost). An example of a topic could be: `my post about cats`.

### Creating the table in Hasura Console

Now, let's go back to our Hasura project and go to the **Create Table** page.
We're going to fill the form with the information about columns.

We need to provide column names and column types. For columns `author`,
`content` and `topic`, we'll go with type `text`, which allows storing strings
of any length.

![](https://d2uusema5elisf.cloudfront.net/courses/newline-guide-to-fullstack-comments-with-hasura-and-react/module_01/lesson_01.03/public/assets/text-columns.png)

In this lesson, we'll create a comments table and learn a bit about databases along the way.

Learn

The newline Guide to Building Your First GraphQL Server with Node and TypeScript

Teach

Amelia Wattenberger

Author of Fullstack D3

Community

The newline Guide to Full Stack Comments with Hasura and React

Module 1: Introduction

Introduction:

Start Here

Introduction: (3:03)

Course Introduction

Module 2: Storing comments with Hasura

Lesson 1: (9:21)

Introduction to GraphQL

Lesson 2: (10:35)

Using Hasura to Generate GraphQL APIs and Protect Data

Lesson 3: (6:03)

How to Create a Comments Database Table and Set Permissions

Module 3: Implementing a comments system

Lesson 1: (4:56)

Setting Up Next.js Blog Starter and Understanding Its Structure

Lesson 2: (9:32)

Fetching Blog Comments from a Database with a Custom React Hook

Lesson 3: (5:43)

A Brief Tutorial on Building the UI for a Blog Comments Section

Lesson 4: (3:51)

How to Use GraphQL to Add Comment Features to a Frontend App

Module 4: Extending the comments system functionality

Lesson 1: (3:16)

An Overview of Optimistic Updates for React Hooks

Lesson 2: (4:18)

Adding Pagination to a Comments Section with Hasura and React

Module 5: Bonus

Lesson 1: (3:55)

How to Publish a Custom React Hook as an NPM Library

Lesson 2: (2:52)

Coding a Comments Section that Requires Manual Content Approval

Module 6: Summary

Lesson 1: (2:35)

Summary

How to Create a Comments Database Table and Set Permissions