DEV Community: windy

Working with Google Cloud Storage for ASP.NET Core 6 Applications

windy — Mon, 10 Oct 2022 19:32:26 +0000

I made a detailed video tutorial Working with Google Cloud Storage for ASP.NET Core 6 Applications, and article, where you will learn how to work with Google Cloud Storage for ASP.NET Core 6 Web applications. This is the real time demonstration of performing file based CRUD operations directly on to the Google Cloud Storage. You can follow along with this tutorial if you have a GCP account. It's free to sign up and you will get $300 Credit if you sign up with your credit card.

Contents of this tutorial include
Part 1 - GCP Setup

Introduction
Login to GCP
Create a Project
Crate a Bucket
Create a Service Account
Create & Download key for Service Account

Part 2 - Create and Set up ASP.NET Core 6 MVC with EF Core project

Create ASP.NET Core 6 MVC Razor Project in Visual Studio
Update appsettings.json
Create GCS Config Options class
Register GCS Config Options class in services
Add Nuget - Google.Cloud.Storage.V1

Part 3 - Implement Cloud Storage Service to work upload, delete and read files from GCP Cloud Storage

Create a Cloud Storage Service
Implement Upload File Async for Google Cloud Storage
Implement Delete File Async for Google Cloud Storage
Implement Get Signed Url Async for Google Cloud Storage
Register Cloud Storage Service as singleton

Part 4 - Implement MVC application to handle file uploads on GCP Cloud Storage

Add a model with IFormFile field
Add a Controller
Manage Nuget packages - Add NpgSQL, Remove MSSQL
UseNpgSql in Program.cs & Update Connection String
Add Migrations
Update Database
Update Shared Layout Navigation to show Animals menu
Styling Home Page with Animals Poster

Part 4.1 - Implement MVC for Create View with File Upload functionality to Cloud Storage

Create Razor View with File Upload
Update Controller to depend on Cloud Storage Service
Implement Create Action to invoke Upload File to Cloud Storage
Test a file upload & Verify in Cloud Storage Bucket

Part 4.2 - Implement MVC for Details View with Show file from Signed URL of a file in Cloud Storage

Details Razor View with Image rendered from Signed URL
Implement Details Action to get Signed URL from Cloud Storage
Edit Razor View with File Upload

Part 4.3 - Implement MVC for Edit View with File Delete & Upload (replace) functionality to Cloud Storage

Implement Edit Action to Replace file in Cloud Storage
Test Edit Animal & Verify replace file in Cloud Storage Bucket
Delete Razor View with Image rendered from Signed URL

Part 4.4 - Implement MVC for Delete View with File Delete functionality from Cloud Storage

Implement Delete Action to remove file in Cloud Storage Bucket
Verify Delete Animal removes file from Cloud Storage Bucket
Play with the file CRUD operations on GCP
Showing List of Animals along with Photos in Index Razor View
Implement Index Action to get list of Signed URLs from GCS

Host FastAPI application on Ubuntu Virtual Machine

windy — Thu, 31 Dec 2020 11:33:15 +0000

Step by step video tutorial on deploying FastAPI app on Ubuntu 18 VM. FastAPI app performs Async CRUD operations on PostgreSQL. It is hosted on Gunicorn as a systemd and exposed as a reverse proxy to the outside world through Caddy 2 Web Server.

Also check out this detailed article that includes end to end steps for FastAPI deployment on Ubuntu along with the steps to troubleshoot at every phase of deployment.

FastAPI + PostgreSQL + Async REST Endpoints + Azure Deployment

windy — Sat, 11 Jul 2020 08:01:09 +0000

I wrote articles and made videos that demonstrates Implementing Async CRUD REST APIs using Python based FastAPI framework. And added detailed notes about deploying FastAPI on Azure with Full Source code available on GitHub. You may find the links here

Video: Implementing Async REST APIs in Python using FastAPI with PostgreSQL CRUD

Articles:
Implementing Async REST APIs in FastAPI with PostgreSQL CRUD

Deploy FastAPI on Azure App Service

FastAPI on GCP App Engine

windy — Tue, 19 May 2020 18:05:27 +0000

I made a 20 min video (link at the bottom) that demonstrates how to deploy a simple FastAPI app to App Engine on Google Cloud Platform.
This tutorial can be followed along to practice on your own provided that you have a billing enabled GCP account.
This tutorials covers very basic details like

Creating a project in GCP,
Accessing the Cloud shell,
Clone the repository on to Cloud Shell VM,
Do a Sanity hosting of the FastAPI on Cloud Shell VM and explain about worker processes
Create an App Engine
Deploy FastAPI on to App Engine
Check Logs of App Engine
Clean up and Shutdown Project once practiced the tutorial.

Some notes about billing

I have performed this deployment and shutdown the project after I'm done with deployment and learning a couple of months ago. So no bill has been generated for me. I do not even have credits active at the time of performing this tutorial.

Link for tutorial

Deploy FastAPI Python app to Google Cloud Platform on App Engine

Add your project located on PC to GitHub, A detailed How To Article

windy — Tue, 04 Feb 2020 10:54:26 +0000

This detailed tutorial http://bit.ly/2UoEXLe will walk you through adding an existing project to GitHub.

Following is the Quick Cheat Sheet to add existing repository to git has step by step approach to add and push an existing code base to a new GitHub repository.

echo "# my-first-repo-on-github" >> README.md
git init
# Create New repository on GitHub
# git remote add origin url
git remote add origin https://github.com/your-awesome-username/name-of-your-repository.git
git remote -v
git pull origin master
git add .
git commit -m 'init'
git push origin master

FastAPI + Heroku + Gunicorn + Uvicorn

windy — Mon, 27 Jan 2020 12:36:04 +0000

In the mentioned video tutorial, a sample hello world REST API will be deployed to Heroku that was implemented with python based FastAPI. FastAPI is a framewrok to build robust APIs with autogenerated swagger documentation for its endpoints.
The video tutorial concentrates on deploying the FastAPI app without using docker to Heroku http://bit.ly/3aO1g35

In case you are interested in a detailed walkthrough on how to create FastAPI and deploy it to Heroku, you may want to refer to this article http://bit.ly/2RD68jM

Hosting WordPress on Azure App Service (Linux)

windy — Tue, 24 Dec 2019 12:57:35 +0000

In this tutorial http://bit.ly/2PMmWDV, we will see how to host a WordPress CMS on Azure App Service Linux Plan. The tutorial also discusses about troubleshooting various issues with SSL Config and setting up your WordPress for different loads of traffic.

Following Topics are covered in detail in the video tutorial:
1 Create App Service (Linux)
2 Create MySQL Database Server
3 Access Secure Shell (SSH)
4 Deploy WordPress
5 Connect Azure Database for MySQL from MySQL WorkBench
6 Create a Database for WordPress Application
7 Configure WordPress Installation
8 Scale Up/Down App Service Plan
9 Configure SSL for WordPress on Azure (Important Step)

How to Configure ASP.NET Core 3.1 AngularJS SPA and Identity Server 4 Authentication with PostgreSQL DB

windy — Sun, 15 Dec 2019 15:10:30 +0000

In this tutorial we will see how to configure an ASP.NET Core 3.1 web application with AngularJS SPA as front end and PostgreSQL as database with Secure User membership implementation using Identity Server 4.

You can follow along with this video tutorial here (http://bit.ly/2EkotL5) as it is step by step detail providied you have following PreRequisites satisfied.

PreRequisites:
Visual Studio 2019 (Community/Professional/Enterprise Edition) v16.4.0 or higher
PostgreSQL Database Server installed. Version 11 or Higher
How to install PostgreSQL on Windows PC http://bit.ly/2LYxk9z
A browser preferrably Chrome, Firefox or IE 11 or higher
PgAdmin to access PostgreSQL Server Database
Windows 10 PC

Install PostgerSQL

Install PostgerSQL on your PC or access remote PostgerSQL db.
To install PostgerSQL on your Windows 10 PC, check out the link in the description below that details on how to install and configure PostgerSQL 11 on your Windows 10 PC.
Once the installation is done, Open pgAdmin
Once the setup is completely done a database with asp.net core3.1 membership authentication related schema will appear here.

Update Visual Studio 2019 with .NET Core 3.1

To get latest .NET Core 3.1, for that open Visual Studio Installer and update the installer itself if it prompts for an update and then update your Visual Studio to have .NET Core 3.1.
Now Click on update your Visual Studio to the version 16.3.10. You can do this on community edition too and ensure you have .Net Core 3.1 version installed which got released in December 2019

What Next ?

Now lets create an ASP.NET Core 3.1 application that will talk to this PostgerSQL database.
We will configure the creation of the ASP.NET Core application to have Authentication at the Individual User Accounts.
And then we generate migration scripts that will dump the authentication related tables in to the database.

Create ASP.NET Core 3.1 Angular application with Individual User Accounts

Now launch the Microsoft Visual Studio 2019 IDE. From the Get Started section, select the option to Create a new project.
Look for and select the ASP.NET Core Web Application and click on Next to proceed
Give Project name and location of your choice.
For example, name the project ASPNET-Core3-1-Angular-PostgreSQL-Identity-Server and click Create.
In the Create a new ASP.NET Core web application step, choose Angular template. Because we want our application to have an Angular based front-end. You may also choose React.js, Web Application to has ASP.NET razor Pages or Web Application (Model-View-Controller).
Now in the right pane click on Change hyperlink under Authentication label to configure our application to have Individual User Accounts and click on OK.
Now click on Create.
Now this template configuration will generate all the code related to Authentication that involves Migration Schema that will generate tables for users, roles, claims, logins etc.,
The template also has angular screens automagically generated for Register, Login, Forgot Password, Login Menu.
This scaffolded template eases the developer to focus on the application functionality rather than setting the user authentication from the scratch.

Delete Migrations directory

As the default database this template is configured to work with is MSSQL, we want to change this to work with PostgerSQL.
For that, delete the Migrations directory which has MSSQL related migration schema that is located under the Data directory.

Update Connection string to point to PostgreSQL Database

Also update the default connection string present in appsettings.json to point to the local or remote PostgerSQL database. For local PostgerSQL server, the connection string goes like
Server=localhost;Port=5432;Database=aspnetmembership;User Id=postgres;Password=mysupersecret!

Update Dependencies

Remove Microsoft.EntityFrameworkCore.SqlServer

Now remove the reference to Microsoft.EntityFrameworkCore.SqlServer which is located under Dependencies -> Packages
As we want to configure our application to target PostgerSQL instead of MSSQL.
In the solution explorer, navigate to Dependencies -> Packages right-click on Microsft.EntityFrameworkCore.SqlServer and remove.
Now install PostgerSQL package for EntityFrameworkCore.
To do that right click on the project ASPNET-Core3-1-Angular-PostgreSQL-Identity-Server in the solution explorer and click on Manage NuGet Packages...
This will open up a window to manage the Nuget packages for our project.

Now navigate to Browse menu, search for Npgsql.EntityFrameworkCore.PostgreSQL and from the version selector choose the latest stable version 3.1.0 and Install
Click on OK for the Preview Changes prompt.

Ensure that all the dependent packages are having version compatiability with .NET Core 3.1

Update Startup.cs

Now open Startup.cs file and locate ConfigureServices method.
Find and replace UseSqlServer with UseNpgsql in order to point our DbContext to our PostgerSQL database.
Also set the lamba expression options.SignIn.RequireConfirmedAccount to false. This will disable the requirement to the registered users to confirm their email before they could login. This setting is suitable for development purposes only. And do not forget to enable it to true once you have email server configured for the customer facing applications.

Update malformed .csproj file

Now open the .csproj file of ASPNET-Core3-1-Angular-PostgreSQL-Identity-Server and ensure the execution commands are properly written. If you see repeated double hypens like npm run build -- --prod and npm run build:ssr -- --prod change it to npm run build --prod and for ssr npm run build:ssr --prod

install angular cli

Now install angular cli. For that in the search box at the top of IDE type developer command prompt and open it.
It will open up a command prompt window with current directory defaulted to project's root directory.
Now set the current directory to ClientApp with the command

cd ClientApp

and then run the command

npm install --save-dev @angular/cli@latest

This will install latest version of angular cli and saves it as dev dependency in the package.json located in ClientApp directory.
This operation will take a while.

Add-Migration scripts

Now we will generate PostgerSQL based migrations schema.
Open the Package Manager Console by navigating to
Tools -> Nuget Package Manager -> Package Manager Console
Type in the command

add-migration PostgreSQLIdentitySchema

This will generate Migrations directory adjacent to Data directory.
Migrations directory will have two c-sharp files named datetimestamp_migrationname.cs to create identity schema
and ApplicationDbContextModelSnapshot.cs that has the snapshot of the models that get migrated with this schema.

Update-Database

Now that we have migration schema with asp.net core 3.1 Authentication aut-generated for PostgerSQL, lets create our new database aspnetmembership to have the tables created related to authentication.
For that run the command

update-database

This command will create a database named aspnetmembership which is configured in the connection string located in appsettings.json
Based on the auto-generated schema located in Migrations directory, the asp.net core 3.1 membership tables will be created in the aspnetmembership database.
To view the new database created, go to pgAdmin refresh the Databases node that is present under Servers -> PostgerSQL 11
You will find newly created aspnetmembership database.
Look for the tables node present under Schemas node of the aspnetmembership database.

Build the solution

Now in Visual Studio go to build menu and click on the Build Solution. This process will take a while as we are building the solution for the first time.
For the first time all the dependent packages for the front-end angular app will be downloaded in the node modules directory and then the entire solution will be built.

Run the application

Click on the dropdown next to Run button and select your favorite browser from which you want to launch the web app. Lets proceed with chrome.
Now click on the IIS Express and wait for the application to open in default browser configured for your PC.
You can notice the Default home page with navigation menu having links for Register and Login pages.

Access non-authenticated page

The Counter navigation menu item is a non-authenticated page. Lets click on it to access it.

Access authenticated page

The Fetch Data navigation menu item is an authenticated page. As we have not yet registered, clicking on Fetch data menu will redirect the page to login.
In order for users to login, they must be registered.

Register

So navigate to registeration page and provide email, password and then provide confirm password.
Click on Register. Next click on login.
As we disabled email confirmation for registered users, clicking on login will automatically redirect us to the authenticated app.
Now that we are authenticated, click on Fetch data and you will be shown the default dummy weather data which is an authenticated page.

Manage Profile

Notice the email in the navigation menu, click on it to customize your profile, change email, password and also an option to download all the personal data.

Logout

Click on Logout and you will see the navigation menu shows Register and Login links.

Check registered users in database.

Now in order to check the registered users in the PostgerSQL database,go back to pgAdmin and
expand the nodes aspnetmembership -> Schemas -> Tables right-click on AspNetUsers table and select the option View/Edit Data.
You will notice the user entry with the details we registered with.

Creating ASP.NET Core 3.0 React SPA with Entity Framework Core Identity Server for MySQL Database in 20 Minutes

windy — Sat, 07 Dec 2019 21:06:24 +0000

This tutorial uses .net core version 3.0 The web app has react as front end, MySQL as Database layer where the asp.net membership related schema will be migrated to.

Pre-Requisites:
Microsoft Visual Studio 2019 Community Edition

.net core 3 https://dotnet.microsoft.com/download/dotnet-core

MySQL Tools for Visutal Studio https://dev.mysql.com/downloads/windows/visualstudio/

mysql-for-visualstudio-1.2.9.msi (https://dev.mysql.com/downloads/windows/visualstudio/)

Configurating ASP.NET Membership web app for MySQL
Step 1:
Delete Migrations Directory under the Data Directory

Step 2:
Uninstall the package Microsoft.EntityFrameworkCore.SQLServer Install the package Pomelo.EntityFrameworkCore.MySql

Step 3:
Create db in MySql

CREATE SCHEMA reactmembership;

Step 4:
Update value of DefaultConnection in appsettings.json to

server=localhost;port=3306;database=reactmembership;user=root;password=p@$$w0Rd;CharSet=utf8

Step 5:
In Startup.cs file update ConfigureServices method to replace UseSqlServer with UseMySql

Step 6:
Tools -~ Nuget Package Manager -~ Package Manager Console

In Visual Studio, use the Package Manager Console to scaffold a new migration and apply it to the database:

Add-Migration [migration name]
Update-Database

Full Code on Github Repo : http://bit.ly/2LWgacA
Video Tutorial : http://bit.ly/2rfxVN1

Federated Learning Interview Questions

windy — Sat, 07 Sep 2019 14:44:29 +0000

Federated Machine Learning is finding its way to emerge and rule the future of Machine Learning with the usage of internet enabled devices like laptops, smart phones, tablets and voice assistants growing at an exponential rate. Understand more about Federated Machine Learning in the form of Q&A here http://bit.ly/2KGoUna

Calculating the Best SIP Date with Highest Returns

windy — Thu, 15 Nov 2018 01:04:25 +0000

This is a simple analysis to find out which SIP date had yielded highest returns for Parag Parikh Long Term Equity Fund – Direct Plan – Growth. The standard SIP dates considered are 1st, 5th, 10th, 15th, 20th and 25th of calendar month. The following analysis is illustrated using python programming language. Read more http://bit.ly/2FlcobV

How to Invest in Direct Mutual Funds through AMC

windy — Thu, 11 Oct 2018 00:30:58 +0000

Investing in Direct mutual funds save a lot of money over the period of years in contrast to investing in regular mutual funds. Many people tend to buy mutual funds through brokers just because there are many third-party services available in the market attracting potential investors.

The post How to Invest in Direct Mutual Funds through AMC appeared first on MF Republic.