Ravindra Devrani

To work with backend (which is created in node js, sqlite and prisma) you need to follow this post.

💻 Source code of frontend app

💻 Source code of this fullstack app

To create a react app you need to execute this command in terminal:

npm create vite@latest

It asks few things:

• Project name: frontend

Note: Choose a meaninful name. Since it is part of my fullstack app, one directory is backend, so another one is going to be named frontend.

REST Apis are session less. You can not maintain the authentication session for the whole application. For that purpose, JSON web token (JWT) comes in play. How it works:

• User hits the login or authenticate endpoint with valid credentials.
• In response, if user is authenticated, user get’s a access-token (JWT) , which contains the user’s info like username and role.
• You need to pass JWT in Authorization header with every protected endpoint.
• With this, the server knows a valid and authenticated user is accessing the resource.
• JWT has a expiry date, it does not live forever.
• Also need to note that, JWT is not saved in database.

You can also check react frontend for this app.

TODO app is the most common way to understand basic crud (create, read, update and delete) feature of the language or framework or a ui library. But I prefer plain CRUD with form and table. In this way one can learn to use form along with validation also to display them in a table. It is a good way to learn CRUD for data driven appications like admin-panel for entries.

So….What is:

• React hook form: It is a popular light library to create and manage forms. It is very performative and comes with built-in validation support.

• **Zod **: It is a schema validation library that lets you define the shape of your data and validate it at runtime. It makes easier to do validation.

Create a react app with JS or TS whatever you prefer. After that install these packages in a react app:

• I am using mssql server in docker container.

• I am using vscode extension named SQL Server (mssql) by microsoft. This extension gives you the feature of creating and exporting the backup

• Connect to the database. It should look like this:

• Create a backup by using that extension.

Note: I have saved backup inside the folder /var/opt/mssql/data/

• To find the exact name:

docker exec <container_name> ls /var/opt/mssql/data/*.bak

• Copy backup from docker to host machine:

docker cp <container_name>:/var/opt/mssql/data/your_backup.bak ~/Documents/your_backup.bak

When you work with a team, everyone has their own preferences like double-quotes vs. single-quotes, trailing semicolon or not. If you want to decide a common code format that automatically applied. There are several ways which also comes with angular 21, like prettier. But you need to run the command for that every time. It is a nice feature. But you can also format code on file save. For that you need to follow these two steps.

Today we are going explore some popular learning techniques briefly. Yes… this post is not a regular technical blog post of this blog. But it might be helpful you are a “learner” (every programmer is a life long learner). I have described various techniques. Few of them fits very well in learning programming, deepen the concepts and research - while few are best suited for memorizing concepts for exams. Lets learn about each of them.

Aspnet core identity provides an UI to registration, login, manage users, password, external authentication (google, twitter, facebook etc). In simple words, We can say it is an authentication and authorization feature in just few lines of commands and code. It is a nice feature, if you don’t want to use other managed authentication providers like Azure Entra Id / Okta Auth0 etc.

Visual studio provides an UI way to enable identity. Which is very straightforward, but using CLI can be a little bit tricky. It is not always the case you are using visual studio (specially if you are using mac or linux). I use linux also. That is the whole reason to write this article.

In this tutorial, we are going to make dotnet core web api application and perform all the CRUD (create, read, update and delete). I have tried to keep it simple and avoided any complexities like repository pattern.

💻Source code

Tech and tools used

• Dotnet 10
• MySql 8+ (in docker container. Click here, if you want to create a MySql container in docker)
• Entity Framework Core (ORM)
• .NET CLI and VS Code (alternate Visual Studio 2025)

Creating a project

Execute these commands in a sequence.

In this tutorial, we are going to make dotnet core web api application and perform all the CRUD (create, read, update and delete). I have tried to keep it simple and avoided any complexities like repository pattern.

💻Source code

Tech and tools used

• Dotnet 10
• MySql 8+ (in docker container. Click here, if you want to create a MySql container in docker)
• Dapper (ORM)
• .NET CLI and VS Code (alternate Visual Studio 2025)

Create database

Let’s start with creating a database and a table. You need to execute this script.