A window into the Full-Stack World

In this blog, I explore the world of full-stack web development. Here you will find everything I learned in over a decade on the job, from niche bug fixes, how-to's on mobile app development and API configuration questions to info about the life of a web developer.

For front-end developers I will be outlining common configurations and quirks you may find when working with JavaScript, Angular, React, Flutter and Ionic/Capacitor.js.

These days I most commonly work on the back-end using Node.Js, C#/.NET and SQL or MongoDB. After building several indie apps currently sold in the major stores, I can share quite a few tidbits to make your life easier.

Follow me on Twitter @Mick_Patterson_ for updates and thoughts on life.

As featured on tech-blogs.dev

What is a Foreign Key?

What is a Foreign Key?

01 May, 2023

Foreign Keys are a necessity in any relational database. They help connect distinct data tables together by creating a tightly-bound reference between the tables.

Extend The Azure Functions Execution Timeout Value

Extend The Azure Functions Execution Timeout Value

13 September, 2022

The default maximum execution time of an individual Azure Function is 5 minutes. Sometimes, there will be a need to have a function that takes longer than that to execute. There are arguments that any function that takes that long should have the architecture changed to delegate the workload differently, however, if you need just a little bit more time, there is a way to enable this without having to re-architect the function.

Create a NodeJs REST API

Create a NodeJs REST API

18 August, 2022

REST APIs are a key building block of the Internet as we know it, along with being an essential component of any full-stack web application by providing a bridge between our users and our database. Luckily, an API can be built using many different technologies and languages. If you're a web developer with Javascript knowledge, using NodeJs to build an API is a no-brainer.

Add Auto-Increment to a Column in SQL Server

Add Auto-Increment to a Column in SQL Server

25 February, 2022

Knowing how to add auto-incrementing to a numeric column in SQL Server is a skill all database admins should have. It is an exceptionally common use case, whether it be on the Primary Key column of your table, or you need a column to identify insert order or similar.

How to Create a SQL Server Index

How to Create a SQL Server Index

21 February, 2022

Adding indexes to your SQL Server tables is something that you will do plenty of times throughout your career, either as a full-stack developer or as a specialist database admin. Fortunately, adding indexes to tables in your database is a pretty simple task.

How to Set the Timezone of an Azure Function App

How to Set the Timezone of an Azure Function App

18 February, 2022

By default, the timezone of an Azure Function app is UTC/GMT +0 or Greenwich Mean Time. This is great if that is your timezone or the timezone you want your application functions to run in, but for most of us, we need to either adjust all our schedules to fit that timezone or we need to change the timezone.

What is a SQL Index?

What is a SQL Index?

04 January, 2022

SQL databases are fundamentally pretty simple. Data is organised into tables and the tables have columns that connect each other together. The key for a SQL database is to be performant. Sometimes, queries can be extremely slow to return the filtered down dataset that our app is looking for. This is where SQL indexes come in.

The Complete Guide to HTML Input Types

The Complete Guide to HTML Input Types

11 November, 2021

The humble HTML input tag is actually an extremely useful and powerful HTML tag. Not only are they used for constructing forms, but they allow for all sorts of additional functionality to be added to your page.

Remove Duplicate Entries From a Javascript Array

Remove Duplicate Entries From a Javascript Array

04 November, 2021

Arrays are one of the most common data structures you will use in Javascript. They create lists for displaying to users that can be simple or contain complex data objects. Creating lists that have clean information in them is vital for a good user experience. One way to do this is to make sure you are not displaying the same information multiple times.

Connecting to a SQL Server Database via NodeJs

Connecting to a SQL Server Database via NodeJs

01 November, 2021

Every full-stack application in production today probably connects to a database of some variety, whether that be a NoSQL database like MongoDB, a MySQL database like MariaDB, a SQL Server database like those provided by Azure or any other variety. This means that knowing how to wire up a stable connection to these databases from your NodeJs API is a critical skill.

Remove the White Screen Before the Splash Screen in a Flutter App

Remove the White Screen Before the Splash Screen in a Flutter App

21 October, 2021

By default, iOS and Android show a native loading screen before the splash screen of a Flutter app is displayed. This default screen is completely white, which means your app will have a white "flash" before showing your custom splash screen with your app's chosen colours and logo, making for a bad user experience. It is currently not possible to remove this native screen, but we can customise it to make it less intrusive.

HTTP Methods Explained for Frontend Developers

HTTP Methods Explained for Frontend Developers

23 September, 2021

Frontend developers will inevitably need to make HTTP requests frequently when building out the client side of a full stack app. Having a solid understanding of these methods and how to build the requests is essential in being a top shelf frontend developer.

How to use Environment Variables in NodeJs with Express and Dotenv

How to use Environment Variables in NodeJs with Express and Dotenv

22 September, 2021

Environment variables in NodeJs are essential for setting configuration options as well as storing important values securely. The environment variables allow you to store API keys and other configuration secrets independently from your main codebase and separate from your git repository so they never get checked in anywhere. Being able to configure and consume these variables is essential in creating solid, production-ready NodeJs APIs for all applications.

How to calculate the number of days between two dates in javascript?

How to calculate the number of days between two dates in javascript?

20 September, 2021

Date manipulation and calculations are core to a huge amount of enterprise business logic. Being a wizard at using dates and turning them into simple values to run your logic on is critical. Knowing how to calculate the number of days between two dates is an essential piece of logic to have in your utility belt. This post will explain clearly how the math works as well as creating a simple utility function that can be used anywhere.

API Versioning with NodeJs and Express

API Versioning with NodeJs and Express

30 August, 2021

Setting up an API with NodeJs and Express is a topic that is well covered and documented. But what happens when your API requirements expand beyond having a simple CRUD offering? API versioning can help with this. Anytime you see an API url with /v1/ in it, the API is using an internal versioning setup. In this post we'll cover one simple way to configure this with NodeJs and Express.

Sorting an Array of JavaScript Objects in a Specific Order

Sorting an Array of JavaScript Objects in a Specific Order

17 July, 2021

Sorting an Array of JavaScript Objects in a Specific Order is a use case that comes up quite frequently when building UI layouts to meet client specifications. Unfortunately, it is more challenging than a standard array sort and requires additional setup work.