loizenjava | Mobile & Web Programming Tutorials

Upload and Read Excel File in Node.js

Tutorial “Upload and Read Excel File in Node.js – Express RestAPI Upload/Import Download/Export Multiple Excel files”

In the tutorial, I will introduce how to build a Nodejs/Express RestAPIs application to upload/import and download/extract data from multiple Excel files to MySQL or PostgreSQL database by:

Express is used to build Nodejs RestApis
Multer is used to upload/download Excel files
Sequelize ORM is used to manipulate data with MySQL/PostgreSQL
Exceljs is used to save data objects to Excel file
Read-excel-file is used to parse Excel file to data objects

Continue reading “Upload and Read Excel File in Node.js”

Django Angular PostgreSQL CRUD Example

Django is a Python-based free and open-source web framework that follows the model-template-view architectural pattern. Angular is a TypeScript-based open-source web application framework led by the Angular Team at Google. In the tutorial, I introduce how to build a “Django Python Angular PostgreSQL CRUD RestAPI Example” with Fullstack Projects providing POST/GET/PUT/DELETE requests using Django Rest Framework and PostgreSQL database with step by step coding examples:

– I draw a fullstack overview Diagram Architecture from Angular Frontend to PostgreSQL database through Django RestAPI backend.
– Develop Django CRUD RestAPIs with the supporting of Django Rest Framework.
– Implement Angular CRUD application with the Angular Httpclient to do CRUD request (Post/Get/Put/Delete) to Django Backend APIs.
– I create a testsuite with a number of integrative testcases with CRUD RestAPI requests from Angular HttpClient to do CRUD requests to Django RestAPIs Server and save/retrieve data to PostgreSQL database.

Continue reading “Django Angular PostgreSQL CRUD Example”

Django Angular 11 PostgreSQL CRUD Example

Django is a Python-based free and open-source web framework that follows the model-template-view architectural pattern. Angular 11 is a TypeScript-based open-source web application framework led by the Angular Team at Google. In the tutorial, I introduce how to build a “Django Python Angular 11 PostgreSQL CRUD RestAPI Example” with Fullstack Projects providing POST/GET/PUT/DELETE requests using Django Rest Framework and PostgreSQL database with step by step coding examples:

– I draw a fullstack overview Diagram Architecture from Angular 11 Frontend to PostgreSQL database through Django RestAPI backend.
– Develop Django CRUD RestAPIs with the supporting of Django Rest Framework.
– Implement Angular 11 CRUD application with the Angular 11 Httpclient to do CRUD request (Post/Get/Put/Delete) to Django Backend APIs.
– I create a testsuite with a number of integrative testcases with CRUD RestAPI requests from Angular 11 HttpClient to do CRUD requests to Django RestAPIs Server and save/retrieve data to PostgreSQL database.

Continue reading “Django Angular 11 PostgreSQL CRUD Example”

Angular Node.js PostgreSQL Crud Example

Tutorial: “Angular Node.js PostgreSQL Crud Example – using Express and Sequelize ORM”

In the tutorial, I introduce how to build an Angular Node.js PostgreSQL CRUD Example RestAPIs Fullstack Project with the help of Express Web Framework and Sequelize ORM for POST/GET/PUT/DELETE requests with step by step coding examples.

Continue reading “Angular Node.js PostgreSQL Crud Example”

Angular 11 Node.js PostgreSQL Crud Example

Tutorial: “Angular 11 Node.js PostgreSQL Crud Example – using Express and Sequelize ORM”

In the tutorial, I introduce how to build an Angular 11 Node.js PostgreSQL Crud Example RestAPIs Fullstack Project with the help of Express Web Framework and Sequelize ORM for POST/GET/PUT/DELETE requests with step by step coding examples.

Continue reading “Angular 11 Node.js PostgreSQL Crud Example”