Editor’s note: This React and GraphQL CRUD tutorial was last updated on 30 April 2021.
In this tutorial, we’ll show you how to implement simple end-to-end CRUD operations with GraphQL and React. We’ll go over simple examples for reading and mutating data with React Hooks. We’ll also demonstrate how to implement authentication, error handling, caching, and optimistic UI with Apollo Client.
Here’s what we’ll cover:
graphql-server
graphql-client
React is a JavaScript library for building user interfaces. It is designed to aid in the frontend aspect of building applications, including handling the view layer of web and mobile apps.
React is component-based, meaning that the various parts of a React application are broken down into smaller components and then organized inside higher-level components. These higher-level components are where the final structure of the application is defined.
React supports reusable components, so you can create a component and use it multiple times in different parts of our application. This helps reduce bloated code and makes it easier to follow the DRY principle.
GraphQL is a query language for APIs as well as a runtime for fulfilling queries with existing data. In simple terms, GraphQL is a syntax that describes how to ask for data. It’s generally used to load data from a server to a client.
GraphQL reduces the complexity of building APIs by abstracting all requests to a single endpoint. Unlike traditional REST APIs, it is declarative, meaning whatever is requested is returned.
Of course, not all projects require GraphQL — it is merely a tool to consolidate data. It has well-defined schema, so we know for sure we won’t overfetch. But if we already have a stable RESTful API system where we rely on data from a single data source, we don’t need GraphQL.
For instance, let’s assume we are creating a blog for ourselves and we decide to store, retrieve, and communicate to data in a single MongoDB database. In this case, we are not doing anything architecturally complex, and we don’t need GraphQL.
On the other hand, let’s imagine we have a full-fledged product that relies on data from multiple sources (e.g., MongoDB, MySQL, Postgres, and other APIs). In this case, we should use GraphQL.
For example, if we’re designing a portfolio site for ourselves and we want data from social media and GitHub (to show contributions), and we also have our own database to maintain a blog, we can use GraphQL to write the business logic and schema. It will consolidate data as a single source of truth.
Once we have the resolver functions to dispatch the right data to the front end, we will easily be able to manage data within a single source.
When building an API, you want your model to provide four basic functionalities: it should be able to create, read, update, and delete resources. This set of essential operations is commonly referred to as CRUD.
RESTful APIs most commonly utilize HTTP requests. Four of the most common HTTP methods in a REST environment are GET
, POST
, PUT
, and DELETE
, which are the methods by which a developer can create a CRUD system.
graphql-server
In this section, we’ll go over some GraphQL CRUD examples to help you understand how CRUD operations work in a React and GraphQL app.
We are going to spin off a simple GraphQL server using express-graphql
and get it connected to a MySQL database. The source code and the MySQL files are in this repository.
A GraphQL server is built on top of schema and resolvers. As a first step, we build a schema (defining types, queries, mutations, and subscriptions). This schema describes the whole app structure.
Secondly, for the stuff defined in the schema, we’re building respective resolvers to compute and dispatch data. A resolver maps actions with functions; for each query declared in typedef, we create a resolver to return data.
Finally, we complete server settings by defining an endpoint and passing configurations. We initialize /graphql
as the endpoint for our app. To the graphqlHTTP
middleware, we pass the built schema and root resolver.
Along with the schema and root resolver, we’re enabling the GraphiQL playground. GraphiQL is an interactive in-browser GraphQL IDE that helps us play around with the GraphQL queries we build.
var express = require('express'); var graphqlHTTP = require('express-graphql'); var { buildSchema } = require('graphql'); var schema = buildSchema(` type Query { hello: String } `); var root = { hello: () => "World" }; var app = express(); app.use('/graphql', graphqlHTTP({ schema: schema, rootValue: root, graphiql: true, })); app.listen(4000); console.log('Running a GraphQL API server at localhost:4000/graphql');
Once the server is good to go, running the app with node index.js
will start the server on http://localhost:4000/graphql
. We can query for hello and get the string “World” as a response.
I’m going to establish the connection with the MySQL database as shown below:
var mysql = require('mysql'); app.use((req, res, next) => { req.mysqlDb = mysql.createConnection({ host : 'localhost', user : 'root', password : '', database : 'userapp' }); req.mysqlDb.connect(); next(); });
We can connect multiple databases/sources and get them consolidated in the resolvers. I’m connecting to a single MySQL database here. The database dump I’ve used for this article is in the GitHub repository.
We use queries and mutations to read and modify data in data-sources
. In this example, I’ve defined a generic queryDB function to help query the database.
All the SELECT statements (or read operations) to list and view data goes into the type Query
typedef. We have two queries defined here: one to list all the users in the database, and another to view a single user by id.
User
, which represents what we can fetch or expect from the getUsers
query. We then define the getUsers
query to return an array of usersid
as an argument with the getUserInfo
query we have defined. It queries for that particular id in the database and returns the data to the front endNow that we have put together the queries to fetch all records and to view record by ID, when we try to query for users from GraphiQL, it will list an array of users on the screen!
var schema = buildSchema(` type User { id: String name: String job_title: String email: String } type Query { getUsers: [User], getUserInfo(id: Int) : User } `); const queryDB = (req, sql, args) => new Promise((resolve, reject) => { req.mysqlDb.query(sql, args, (err, rows) => { if (err) return reject(err); rows.changedRows || rows.affectedRows || rows.insertId ? resolve(true) : resolve(rows); }); }); var root = { getUsers: (args, req) => queryDB(req, "select * from users").then(data => data), getUserInfo: (args, req) => queryDB(req, "select * from users where id = ?", [args.id]).then(data => data[0]) };
The write operations for the database — CREATE, UPDATE, DELETE — are generally defined under mutations. The mutations are executed in a sequential manner by the GraphQL engine. Queries are executed parallelly.
createUser
, that takes the specified arguments to create data in the MySQL database.updateUserInfo
) and delete (deleteUser
) take id as a param and modify the database.The functions resolve with a boolean to indicate whether the change happened or not.
var schema = buildSchema(` type Mutation { updateUserInfo(id: Int, name: String, email: String, job_title: String): Boolean createUser(name: String, email: String, job_title: String): Boolean deleteUser(id: Int): Boolean } `); var root = { updateUserInfo: (args, req) => queryDB(req, "update users SET ? where id = ?", [args, args.id]).then(data => data), createUser: (args, req) => queryDB(req, "insert into users SET ?", args).then(data => data), deleteUser: (args, req) => queryDB(req, "delete from users where id = ?", [args.id]).then(data => data) };
Now that we have set and sorted the server side of things, let’s try and connect the back end to our React app.
graphql-client
Once we have the server in place, creating client logic to display and mutate data is easy. Apollo Client helps in state management and caching. It is also highly abstracted and quick: all of the logic for retrieving your data, tracking loading and error states, and updating UI is encapsulated by the useQuery
Hook.
graphql-server
I have created a CRA boilerplate and have installed GraphQL, apollo-boost
, and @apollo/react-hooks
. We initialize Apollo Client and get it hooked to React.
import React from 'react'; import ReactDOM from 'react-dom'; import App from './App'; import ApolloClient from 'apollo-boost'; import { ApolloProvider } from '@apollo/react-hooks'; const client = new ApolloClient({ uri: 'http://localhost:4000/graphql' }); ReactDOM.render( <ApolloProvider client={client}> <App /> </ApolloProvider>, document.getElementById('root') );
I have managed all the GraphQL queries in the Queries
folder of my source code. I’m going to request data from the server with the useQuery
Hook, which is built on top of the React Hooks API. It helps in bringing in data into the UI.
GraphQL queries are generally wrapped in the gql
function. gql
helps convert query string into a query document. Here’s how we define queries in our app.
import { gql } from 'apollo-boost'; export const GET_USERS = gql` { getUsers { id, name, job_title, email } } `; export const VIEW_USERS = gql` query ($id: Int){ getUserInfo(id: $id) { id, name, job_title, email } } `; export const ADD_USER = gql` mutation($name: String, $email: String, $job_title: String) { createUser (name: $name, email: $email, job_title: $job_title) } `; export const EDIT_USER = gql` mutation($id: Int, $name: String, $email: String, $job_title: String) { updateUserInfo (id: $id, name: $name, email: $email, job_title: $job_title) } `; export const DELETE_USER = gql` mutation($id: Int) { deleteUser(id: $id) } `
Once ApolloProvider
is set, we can request data from our GraphQL server. We pass the query we are trying to make to the useQuery
Hook, and it will provide the result for us.
I’ve made two queries, with and without arguments, to show how we should be handling queries and mutations in the front end. useQuery
tracks error
and loading
states for us and will be reflected in the associated object. Once the server sends the result, it will be reflected by the data property.
import React from 'react'; import { useQuery } from '@apollo/react-hooks'; import { GET_USERS, VIEW_USERS } from "./Queries"; import { Card, CardBody, CardHeader, CardSubtitle, Spinner } from 'reactstrap'; function App() { const getAllUsers = useQuery(GET_USERS); const userInfo = useQuery(VIEW_USERS, { variables: { id: 1 }}); if (getAllUsers.loading || userInfo.loading) return <Spinner color="dark" />; if (getAllUsers.error || userInfo.error) return <React.Fragment>Error :(</React.Fragment>; return ( <div className="container"> <Card> <CardHeader>Query - Displaying all data</CardHeader> <CardBody> <pre> {JSON.stringify(getAllUsers.data, null, 2)} </pre> </CardBody> </Card> <Card> <CardHeader>Query - Displaying data with args</CardHeader> <CardBody> <CardSubtitle>Viewing a user by id</CardSubtitle> <pre> {JSON.stringify(userInfo.data, null, 2)} </pre> </CardBody> </Card> </div> ) } export default App;
Similar to querying, mutations will use the same useQuery
Hook and will pass data as variables into the query.
const deleteMutation = useQuery(DELETE_USER, { variables: { id: 8 }}); const editMutation = useQuery(EDIT_USER, { variables: { id: 9, name: "Username", email: "email", job_title: "job" }}); const createMutation = useQuery(ADD_USER, { variables: { name: "Username", email: "email", job_title: "job" }});
While GraphQL has some features for debugging requests and responses, making sure GraphQL continues to serve resources to your app in production is where things get tougher. If you’re interested in ensuring requests to the backend or 3rd party services are successful, try LogRocket. https://logrocket.com/signup/
LogRocket is like a DVR for web apps, recording literally everything that happens on your site. Instead of guessing why problems happen, you can aggregate and report on problematic GraphQL requests to quickly understand the root cause.
LogRocket instruments your app to record baseline performance timings such as page load time, time to first byte, and slow network requests as well as logs Redux, NgRx. and Vuex actions/state. Start monitoring for free.
Ta-da! We just did end-to-end CRUD operations with GraphQL. On the client side, reading and mutating data has become very simple after the introduction of React Hooks. Apollo Client also provides provisions for authentication, better error handling, caching, and optimistic UI.
Subscriptions is another interesting concept in GraphQL. With this application as boilerplate, we can keep experimenting with other concepts like these!
Happy coding!
Install LogRocket via npm or script tag. LogRocket.init()
must be called client-side, not
server-side
$ npm i --save logrocket // Code: import LogRocket from 'logrocket'; LogRocket.init('app/id');
// Add to your HTML: <script src="https://cdn.lr-ingest.com/LogRocket.min.js"></script> <script>window.LogRocket && window.LogRocket.init('app/id');</script>
Would you be interested in joining LogRocket's developer community?
Join LogRocket’s Content Advisory Board. You’ll help inform the type of content we create and get access to exclusive meetups, social accreditation, and swag.
Sign up nowSimplify component interaction and dynamic theming in Vue 3 with defineExpose and for better control and flexibility.
Explore how to integrate TypeScript into a Node.js and Express application, leveraging ts-node, nodemon, and TypeScript path aliases.
es-toolkit is a lightweight, efficient JavaScript utility library, ideal as a modern Lodash alternative for smaller bundles.
The use cases for the ResizeObserver API may not be immediately obvious, so let’s take a look at a few practical examples.
9 Replies to "CRUD with React and GraphQL: A complete tutorial with examples"
That’s help me a lot to understanding GraphQL. Thanks so much!
Server stoped after 10-15 sec and Error: Connection lost: The server closed the connection.
What this fix?
const deleteMutation = useQuery(DELETE_USER, { variables: { id: 8 }});
const editMutation = useQuery(EDIT_USER, { variables: { id: 9, name: “Username”, email: “email”, job_title: “job” }});
const createMutation = useQuery(ADD_USER, { variables: { name: “Username”, email: “email”, job_title: “job” }});
These are not working,how to trigger these?
Same Here,If you solved ,plz share
I became so much happier to get understanding of graphql,but confused how to work with subscription based architecture, any idea?
Thank you so much. I remembered I followed this tutorial to try my first GraphQL toy project. You can try using Prisma or Hasura to reduce the code boilerplate. I also build a lightweight lib(it is called graphql-server-crud) to do it. GraphQL is awesome!
Thanks! , now i can understand .. simple but to the point for CRUD!
Plz Share CRUD Operation Complete
That’s really very helpful. Thank you soo much