Django CRUD with MySQL example | Django Rest Framework

In this tutorial, we’re gonna create Python 3/Django CRUD with MySQL example that uses Django Rest Framework for building Rest Apis. You’ll know:

  • How to setup Django to connect with MySQL Database
  • How to define Data Models and migrate it to MySQL
  • Way to use Django Rest Framework to process HTTP requests
  • Way to make Django CRUD Operations with MySQL Database

Related Posts:
Django & MongoDB CRUD Rest API | Django Rest Framework
Django & PostgreSQL CRUD example | Django Rest Framework

Fullstack:
Django + Angular
Django + React
Django + React Hooks
Django + Vue.js

Read More

Deploying/Hosting Node.js app on Heroku with MySQL database

Heroku is one of the most popular cloud platform as a service (PaaS). We can use it to deploy and manage our application in simple & convenient way. This tutorial guides you through the steps of deploying Node.js app on Heroku with ClearDB and MySQL database. The deployment will be done using Git and Heroku CLI.

Related Posts:
Build Node.js Rest APIs with Express & MySQL
Node.js Rest APIs example with Express, Sequelize & MySQL
Dockerize Node.js Express and MySQL example – Docker Compose

Read More

Build Node.js Rest APIs with Express & MySQL

Express is one of the most popular web frameworks for Node.js that supports routing, middleware, view system… This tutorial will guide you through the steps of building Node.js Restful CRUD API using Express and interacting with MySQL database.

Before reading the tutorial, please install MySQL in your machine. The installation instructions can be found at Official MySQL installation manual.

Related Posts:
– Typescript: Node.js Typescript Rest API with MySQL example
Node.js Rest APIs example with Express & MySQL (including Sequelize)
Node.js: Upload/Import Excel file data into MySQL Database
Node.js: Upload CSV file data into MySQL Database

Fullstack:
Vue.js + Node.js + Express + MySQL example
Vue.js + Node.js + Express + MongoDB example
Angular 8 + Node.js Express + MySQL example
Angular 10 + Node.js Express + MySQL example
Angular 11 + Node.js Express + MySQL example
Angular 12 + Node.js Express + MySQL example
Angular 13 + Node.js Express + MySQL example
Angular 14 + Node.js Express + MySQL example
Angular 15 + Node.js Express + MySQL example
Angular 16 + Node.js Express + MySQL example
React + Node.js + Express + MySQL example

Security: Node.js – JWT Authentication & Authorization example
Deployment:
Deploying/Hosting Node.js app on Heroku with MySQL database
Dockerize Node.js Express and MySQL example – Docker Compose

Node.js & MySQL Associations:
One-to-Many Relationship example
Many-to-Many Relationship example

Read More

Export MySQL data to CSV file using Node.js

In previous tutorial, we’ve known how to use Node.js to import CSV data into MySQL Database table. Today you’re gonna look at way to do the opposite: Export MySQL data to CSV file. The process has 2 steps:

  • Read MySQL data using mysql module
  • Export MySQL data to CSV file using one of three modules: fast-csv, csv-writer or fs

Rest API: Node.js Download CSV file from MySQL Database example

Read More