Angular 13 / Bootstrap 5 & CRUD REST API

it's a repo designed to create a Web Application with Angular 13 Frontend - Angular 13.1.1 & Angular CLI 13.1.2 UI prototype - bootstrap 5 Backend - CRUD REST API PostgreSQL See the Live demo, Test the repo with Quick start and for more information Read the step by step Tutorial or read the Getting started

Live Demo

Here is a working live demo : https://angular.ganatan.com/

Lighthouse Audit

Table of contents

• Status
• Quick start
• Front-end
• Back-end
• Author
• Documentation

Front-end : What's included

Dependencies

• Angular : 13.1.1
• Angular CLI : 13.1.2
• Angular Universal : 13.0.1
• Bootstrap : 5.1.3
• Fontawesome : 5.15.4

Features

• Routing
• Lazy Loading
• Server Side Rendering
• Progressive Web App
• Responsive Layout
• Search Engine Optimization (SEO)
• Components
• Services
• Reactive Form
• Template Driven Forms
• Search / Grid / Pagination
• Leaflet

Quick start

# select a repo from github, gitlab or bitbucket

# download the example or clone the repo from github
git clone https://github.com/ganatan/angular-app.git

# download the example or clone the repo from gitlab
git clone https://gitlab.com/ganatan/angular-app.git

# download the example or clone the repo from bitbucket
git clone https://bitbucket.org/ganatan/angular-app.git

# change directory
cd angular-app
cd frontend

# install the repo with npm
npm install

# start the server
npm start

in your browser go to http://localhost:4200

Front-end

Installation

• npm install (installing dependencies)
• npm outdated (verifying dependencies)

Developpement

• npm run start
• in your browser http://localhost:4200

Tests

• npm run lint
• npm run test

Compilation

• npm run build ( without SSR)
• npm run build:ssr ( with SSR)

Production

• npm run serve:ssr
• in your browser http://localhost:4000

Bootstrap UI

• change directory cd ui
• Launch html pages in your browser

Back-end

Back-end : What's included

Tools

• mysql-express-batch (with Node.js)

• mysql-sql (with SQL Scripts)

• postgresql-express-batch (with Node.js)

• postgresql-express-crud (with Node.js and Express)

• postgresql-sql (with SQL Scripts)

Features

• Database Creation
• Domains Creation (only PostgreSQL)
• Tables Creation
• Importing Data
• Exporting Data
• Serving RESTful CRUD API

Database Creation with PostgreSQL

Use the SQL scripts in postgresql-sql

• create-database.sql
• create-domains.sql
• create-tables.sql
• insert-data.sql

Database Creation with MySQL

Use the SQL scripts in mysql-sql

• create-database.sql
• create-tables.sql
• insert-data.sql

Database Creation with Node.js and PostgreSQL

PostgreSQL Password

• Change settings in postgresql-express-batch/app/config
• File config/config.json
• dbUser: "postgres"
• dbPassword: "Trustno1" ! Change the Fox Mulder password by your password

# select the repo
cd postgresql-express-batch

# install the repo with npm
npm install

# create database and import JSON data
npm run create

# For the fun delete All data/export Files
# Export JSON data in data/export
npm run export

# Check the new files (for example movies.json) 

Database Creation with Node.js and MySQL

MySQL Password

• Change settings in mysql-express-batch/app/config
• File config/config.json
• dbUser: "root"
• dbPassword: "Trustno1" ! Change the Fox Mulder password by your password

# select the repo
cd mysql-express-batch

# install the repo with npm
npm install

# create database and import JSON data
npm run create

# For the fun delete All data/export Files
# Export JSON data in data/export
npm run export

# Check the new files (for example movies.json) 

Serving CRUD REST API with Node.js & Express & PostgreSQL

PostgreSQL Password

• Change settings in postgresql-express-crud/app/config
• File config/config.json
• dbUser: "postgres"
• dbPassword: "Trustno1" ! Change the Fox Mulder password by your password

# select the repo
cd postgresql-express-crud

# install the repo with npm
npm install

# Serve CRUD REST API : development mode with nodemon
npm run dev

# Serve CRUD REST API : local mode
npm run start

# Serve CRUD REST API : production mode
npm run prod

# Serve CRUD REST API : production mode with pm2 (process manager)
pm2 start process.config.js --env prod

Tests API & PostgreSQL

• in your browser http://localhost:5004/movies
• in your browser http://localhost:5004/shows
• in your browser http://localhost:5004/continents
• in your browser http://localhost:5004/countries
• in your browser http://localhost:5004/cities

Author

• Updated : 22/05/2021
• Author : danny

Documentation

English Tutorials

• Step by Step - https://www.ganatan.com/tutorials/en

Tutoriels en français

• Etapes par étapes - https://www.ganatan.com/tutorials