{"id":3453,"date":"2022-09-21T19:14:53","date_gmt":"2022-09-21T14:14:53","guid":{"rendered":"https:\/\/www.edopedia.com\/blog\/?p=3453"},"modified":"2022-09-21T19:17:03","modified_gmt":"2022-09-21T14:17:03","slug":"build-reactjs-express-sqlite3-crud-app-using-sequelize-node-js","status":"publish","type":"post","link":"https:\/\/www.edopedia.com\/blog\/build-reactjs-express-sqlite3-crud-app-using-sequelize-node-js\/","title":{"rendered":"Build React.js Express SQLite3 CRUD App Using Sequelize & Node.js"},"content":{"rendered":"\n

CRUD App with React Hooks (+Axios)<\/h2>\n\n\n\n

A simple CRUD (Create, Retrieve, Update, Delete) app with React Hooks (+Axios) consuming a simple Node.js API server (+Sequelize Sqlite).<\/p>\n\n\n\n

\"React.js
React.js Express SQLite3 CRUD App Using Sequelize & Node.js<\/figcaption><\/figure>\n\n\n\n

Install Dependencies<\/h2>\n\n\n\n
npm init -y<\/pre><\/div>\n\n\n\n
npm i express<\/pre><\/div>\n\n\n\n
npm i sequelize<\/pre><\/div>\n\n\n\n
npm i sqlite3<\/pre><\/div>\n\n\n\n
npm i cors<\/pre><\/div>\n\n\n\n
npm i --save-dev sequelize-cli<\/pre><\/div>\n\n\n\n
\n\n\n\n
React.js Express SQLite3 CRUD App Using Sequelize & Node.js<\/h2>\n\n\n\n
index.js<\/h3>\n\n\n\n
const express = require('express');\nconst cors = require('cors');\n\nconst app = express();\nconst PORT = 3333;\n\napp.use(express.urlencoded({ extended: false }));\n\napp.use(cors());\n\napp.use(require('.\/routes'));\n\napp.listen(PORT, () => {\n    console.log(`Server started at: http:\/\/localhost:${PORT}`);\n});<\/pre><\/div>\n\n\n\n
\n\n\n\n
Frontend Dependencies<\/h2>\n\n\n\n
DEPENDENCIES<\/th>LINKS<\/th><\/tr><\/thead>
axios<\/td>link<\/a><\/td><\/tr>
querystring<\/td>link<\/a><\/td><\/tr>
react<\/td>link<\/a><\/td><\/tr>
react-dom<\/td>link<\/a><\/td><\/tr>
react-scripts<\/td>link<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
CSS Style \u2013 (HTML tags on index.html):\u00a0Materialize<\/a><\/p>\n\n\n\n
npm start<\/pre><\/div>\n\n\n\n
Start react app. Port: http:\/\/localhost:3000<\/a><\/p>\n\n\n\n
Backend Dependencies<\/h2>\n\n\n\n
DEPENDENCIES<\/th>LINKS<\/th><\/tr><\/thead>
cors<\/td>link<\/a><\/td><\/tr>
express<\/td>link<\/a><\/td><\/tr>
sequelize<\/td>link<\/a><\/td><\/tr>
sqlite3<\/td>link<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
DEV-DEPENDENCIES<\/th>LINKS<\/th><\/tr><\/thead>
nodemon<\/td>link<\/a><\/td><\/tr>
sequelize-cli<\/td>link<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
npm start<\/pre><\/div>\n\n\n\n
Start API server. Port:\u00a0http:\/\/localhost:3333<\/a><\/p>\n\n\n\n
Database in: database\/database.sqlite<\/p>\n\n\n\n
The database.sqlite already contains some data.<\/p>\n\n\n\n
<\/a>Api routes:<\/h3>\n\n\n\n
VERB<\/th>ROUTE<\/th><\/tr><\/thead>
get<\/td>\/api<\/td><\/tr>
post<\/td>\/api<\/td><\/tr>
put<\/td>\/api\/:id<\/td><\/tr>
delete<\/td>\/api\/:id<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"
CRUD App with React Hooks (+Axios) A simple CRUD (Create, Retrieve, Update, Delete) app with React Hooks (+Axios) consuming a simple Node.js API server (+Sequelize Sqlite). Install Dependencies React.js Express SQLite3 CRUD App Using Sequelize & Node.js index.js Frontend Dependencies DEPENDENCIES LINKS axios link querystring link react link react-dom link react-scripts link CSS Style \u2013 … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":1762,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[112],"tags":[],"class_list":["post-3453","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials"],"yoast_head":"\nBuild React.js Express SQLite3 CRUD App Using Sequelize & Node.js<\/title>\n<meta name=\"description\" content=\"CRUD App with React Hooks (+Axios) A simple CRUD (Create, Retrieve, Update, Delete) app with React Hooks (+Axios) consuming a simple Node.js API server\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.edopedia.com\/blog\/build-reactjs-express-sqlite3-crud-app-using-sequelize-node-js\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Build React.js Express SQLite3 CRUD App Using Sequelize & Node.js\" \/>\n<meta property=\"og:description\" content=\"CRUD App with React Hooks (+Axios) A simple CRUD (Create, Retrieve, Update, Delete) app with React Hooks (+Axios) consuming a simple Node.js API server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.edopedia.com\/blog\/build-reactjs-express-sqlite3-crud-app-using-sequelize-node-js\/\" \/>\n<meta property=\"og:site_name\" content=\"Edopedia\" \/>\n<meta property=\"article:author\" content=\"trulyfurqan\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-21T14:14:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-21T14:17:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.edopedia.com\/blog\/wp-content\/uploads\/2022\/09\/crud_app_react_hooks.jpg\" \/>\n<meta name=\"author\" content=\"Furqan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Furqan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Build React.js Express SQLite3 CRUD App Using Sequelize & Node.js","description":"CRUD App with React Hooks (+Axios) A simple CRUD (Create, Retrieve, Update, Delete) app with React Hooks (+Axios) consuming a simple Node.js API server","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.edopedia.com\/blog\/build-reactjs-express-sqlite3-crud-app-using-sequelize-node-js\/","og_locale":"en_US","og_type":"article","og_title":"Build React.js Express SQLite3 CRUD App Using Sequelize & Node.js","og_description":"CRUD App with React Hooks (+Axios) A simple CRUD (Create, Retrieve, Update, Delete) app with React Hooks (+Axios) consuming a simple Node.js API server","og_url":"https:\/\/www.edopedia.com\/blog\/build-reactjs-express-sqlite3-crud-app-using-sequelize-node-js\/","og_site_name":"Edopedia","article_author":"trulyfurqan","article_published_time":"2022-09-21T14:14:53+00:00","article_modified_time":"2022-09-21T14:17:03+00:00","og_image":[{"url":"https:\/\/www.edopedia.com\/blog\/wp-content\/uploads\/2022\/09\/crud_app_react_hooks.jpg","type":"","width":"","height":""}],"author":"Furqan","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Furqan","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.edopedia.com\/blog\/build-reactjs-express-sqlite3-crud-app-using-sequelize-node-js\/#article","isPartOf":{"@id":"https:\/\/www.edopedia.com\/blog\/build-reactjs-express-sqlite3-crud-app-using-sequelize-node-js\/"},"author":{"name":"Furqan","@id":"https:\/\/www.edopedia.com\/blog\/#\/schema\/person\/3951cb19e3aa56df09e408c98aa02339"},"headline":"Build React.js Express SQLite3 CRUD App Using Sequelize & Node.js","datePublished":"2022-09-21T14:14:53+00:00","dateModified":"2022-09-21T14:17:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.edopedia.com\/blog\/build-reactjs-express-sqlite3-crud-app-using-sequelize-node-js\/"},"wordCount":143,"commentCount":0,"publisher":{"@id":"https:\/\/www.edopedia.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.edopedia.com\/blog\/build-reactjs-express-sqlite3-crud-app-using-sequelize-node-js\/#primaryimage"},"thumbnailUrl":"https:\/\/www.edopedia.com\/blog\/wp-content\/uploads\/2022\/02\/default_featured_image.jpg","articleSection":["Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.edopedia.com\/blog\/build-reactjs-express-sqlite3-crud-app-using-sequelize-node-js\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.edopedia.com\/blog\/build-reactjs-express-sqlite3-crud-app-using-sequelize-node-js\/","url":"https:\/\/www.edopedia.com\/blog\/build-reactjs-express-sqlite3-crud-app-using-sequelize-node-js\/","name":"Build React.js Express SQLite3 CRUD App Using Sequelize & Node.js","isPartOf":{"@id":"https:\/\/www.edopedia.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.edopedia.com\/blog\/build-reactjs-express-sqlite3-crud-app-using-sequelize-node-js\/#primaryimage"},"image":{"@id":"https:\/\/www.edopedia.com\/blog\/build-reactjs-express-sqlite3-crud-app-using-sequelize-node-js\/#primaryimage"},"thumbnailUrl":"https:\/\/www.edopedia.com\/blog\/wp-content\/uploads\/2022\/02\/default_featured_image.jpg","datePublished":"2022-09-21T14:14:53+00:00","dateModified":"2022-09-21T14:17:03+00:00","description":"CRUD App with React Hooks (+Axios) A simple CRUD (Create, Retrieve, Update, Delete) app with React Hooks (+Axios) consuming a simple Node.js API server","breadcrumb":{"@id":"https:\/\/www.edopedia.com\/blog\/build-reactjs-express-sqlite3-crud-app-using-sequelize-node-js\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.edopedia.com\/blog\/build-reactjs-express-sqlite3-crud-app-using-sequelize-node-js\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.edopedia.com\/blog\/build-reactjs-express-sqlite3-crud-app-using-sequelize-node-js\/#primaryimage","url":"https:\/\/www.edopedia.com\/blog\/wp-content\/uploads\/2022\/02\/default_featured_image.jpg","contentUrl":"https:\/\/www.edopedia.com\/blog\/wp-content\/uploads\/2022\/02\/default_featured_image.jpg","width":880,"height":495,"caption":"Default Featured Image"},{"@type":"BreadcrumbList","@id":"https:\/\/www.edopedia.com\/blog\/build-reactjs-express-sqlite3-crud-app-using-sequelize-node-js\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.edopedia.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Build React.js Express SQLite3 CRUD App Using Sequelize & Node.js"}]},{"@type":"WebSite","@id":"https:\/\/www.edopedia.com\/blog\/#website","url":"https:\/\/www.edopedia.com\/blog\/","name":"Edopedia","description":"Coding\/Programming Blog","publisher":{"@id":"https:\/\/www.edopedia.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.edopedia.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.edopedia.com\/blog\/#organization","name":"Edopedia","url":"https:\/\/www.edopedia.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.edopedia.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.edopedia.com\/blog\/wp-content\/uploads\/2017\/10\/edopedia_icon_text_10.jpg","contentUrl":"https:\/\/www.edopedia.com\/blog\/wp-content\/uploads\/2017\/10\/edopedia_icon_text_10.jpg","width":400,"height":100,"caption":"Edopedia"},"image":{"@id":"https:\/\/www.edopedia.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.edopedia.com\/blog\/#\/schema\/person\/3951cb19e3aa56df09e408c98aa02339","name":"Furqan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e5e68aef3ad8f0b83d56f4953c512c8e57bd2e6dc64daec33b5d0495d9058f51?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e5e68aef3ad8f0b83d56f4953c512c8e57bd2e6dc64daec33b5d0495d9058f51?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e5e68aef3ad8f0b83d56f4953c512c8e57bd2e6dc64daec33b5d0495d9058f51?s=96&d=mm&r=g","caption":"Furqan"},"description":"Well. I've been working for the past three years as a web designer and developer. I have successfully created websites for small to medium sized companies as part of my freelance career. During that time I've also completed my bachelor's in Information Technology.","sameAs":["http:\/\/www.edopedia.com\/blog\/","trulyfurqan"],"url":"https:\/\/www.edopedia.com\/blog\/author\/furqan\/"}]}},"_links":{"self":[{"href":"https:\/\/www.edopedia.com\/blog\/wp-json\/wp\/v2\/posts\/3453","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.edopedia.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.edopedia.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.edopedia.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.edopedia.com\/blog\/wp-json\/wp\/v2\/comments?post=3453"}],"version-history":[{"count":2,"href":"https:\/\/www.edopedia.com\/blog\/wp-json\/wp\/v2\/posts\/3453\/revisions"}],"predecessor-version":[{"id":3457,"href":"https:\/\/www.edopedia.com\/blog\/wp-json\/wp\/v2\/posts\/3453\/revisions\/3457"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.edopedia.com\/blog\/wp-json\/wp\/v2\/media\/1762"}],"wp:attachment":[{"href":"https:\/\/www.edopedia.com\/blog\/wp-json\/wp\/v2\/media?parent=3453"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.edopedia.com\/blog\/wp-json\/wp\/v2\/categories?post=3453"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.edopedia.com\/blog\/wp-json\/wp\/v2\/tags?post=3453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}