Patrick's Software Blog

Title of the blog post around a laptop computer being opened in the dark.

SQL Cheatsheet

January 10, 2025 | SQL

Cheatsheet (3 pages) of the SQL commands/statements presented in the Learn SQL with Python tutorial.
Title of the blog post around a laptop computer being opened in the dark.

Learn SQL with Python (Part 3)

January 08, 2025 | SQL

Blog post teaching SQL by using Python. This is Part 3 (Joins and Set Operators) of a 3-part tutorial about SQL.
Title of the blog post around a laptop computer being opened in the dark.

Learn SQL with Python (Part 2)

January 06, 2025 | SQL

Blog post teaching SQL by using Python. This is Part 2 (Filtering, Sorting, and Grouping) of a 3-part tutorial about SQL.
Five books displayed from GoodReads year in review.

My Favorite Books of 2024

December 28, 2024 | Books

Blog post describing my favorite 10 books of 2024.
Title of the blog post around a laptop computer being opened in the dark.

Learn SQL with Python (Part 1)

December 13, 2024 | SQL

Blog post teaching SQL by using Python. This is Part 1 (SQL Fundamentals) of a 3-part tutorial about SQL.
Hand holding a pen and writing notes on a notepad.

How are Requests Processed in Flask?

January 04, 2024 | Flask

Blog post describing how requests are processed in Flask.
Hand holding a pen and writing notes on a notepad.

My Favorite Books of 2023

December 27, 2023 | Books

Blog post describing my favorite 10 books of 2023.
Hand holding a pen and writing notes on a notepad.

My Favorite Productivity Tip - Planning

October 12, 2023 | Flask

Blog post describing how planning is my favorite productivity tip for any software project.
Rocks stacked on top of each other with the Flask logo in the top left corner and the Python logo in the bottom right corner.

My Favorite Python Packages for Building Flask Applications

May 11, 2023 | Flask

Blog post listing my favorite Python packages for building Flask applications.
Desktop Computer on a Desk with the Flask and Frozen-Flask Logos on the Screen and the Netlify Logo on a wall behind the computer.

Generating a Static Site with Flask and Deploying it to Netlify

February 23, 2023 | Flask, Netlify

Blog post that demonstrates how to leverage the JAMstack with Python and Flask. You'll learn how to generate a static site with Flask, via Frozen-Flask, and deploy it to Netlify.
Laptop Computer on a Desk with the Flask Logo on the Laptop Screen

How to Start a Flask Project

February 18, 2023 | Flask

Blog post demonstrating how to start a new Flask project using Python 3, pip, a virtual environment, and the Flask development server.
Desk with the GitLab logo and a GitLab project summary shows badges for code coverage and build status.

Add Badges to a Python Project in GitLab

December 11, 2022 | Flask, GitLab

Blog post demonstrating how to add badges to a Python project in GitLab.
Laptop Computer on a Desk with the Flask Logo on the Laptop Screen and the Render Logo on a Notepad

Deploying a Flask App to Render

October 26, 2022 | Flask, Render

Blog post demonstrating how to deploy a Flask application to Render, including connecting a PostgreSQL database.
Notebook open with the VueJS and Pinia logos on the notebook.

Testing Pinia Data Stores in Vue

September 26, 2022 | Vue, Pinia

Blog post describing how to test Pinia data stores in a Vue application.
White desktop with the VueJS and Vitest logos on the desk.

Guide to Unit Testing Vue Components

July 19, 2022 | Vue, Vite, Vitest

Blog post that serves as a guide to unit testing Vue components using Vitest and Vue Test Utils.
Desktop Computer on a Desk with the Flask and APIFairy Logos on the screen.

Building a Flask API with APIFairy

May 26, 2022 | Flask, APIFairy

Blog post showing how to build an API using Flask and APIFairy, including creating API endpoints, generating documentation, integrating a database, and implementing authentication.
Notebook on a table with the Flask log on the side and a Learning Plan in the notebook listing the Application Context and Request Context.

Deep Dive into Flask's Application and Request Contexts

March 01, 2022 | Flask

Blog post providing a deep-dive exploration into the Application and Request contexts in Flask.
Notebook on a table with the Flask log on the side and a Learning Plan in the notebook listing the Application Context and Request Context.

Understanding the Application and Request Contexts in Flask

December 31, 2021 | Flask

Blog post providing clarity on how the Application and Request contexts work in Flask.
Notebook on a table with the Flask log on the side and a Learning Plan in the notebook listing the Application Context and Request Context.

Testing Flask Applications with Pytest

December 14, 2021 | Flask, pytest

Blog post that serves as a guide to testing Flask applications with pytest.
Notebook on a table with linen cloth with Async in Flask 2 written on the notebook.

Async in Flask 2.x

May 22, 2021 | Flask

Blog post looking at Flask 2.0's new async functionality and how to leverage it in your Flask projects.
Notebook on a table with What is Werkzeug? written on the notebook, plus the logos for Werkzeug and Flask at the bottom of the page.

What is Werkzeug?

April 05, 2021 | Flask, Werkzeug

Blog post explaining what Werkzeug is and how Flask uses it for its core HTTP functionality.
Wooden table with the words Server-Side Sessions in Flask written on it and a notebook with the Flask logo on the table, as well as a cup of coffee.

Server-side Sessions in Flask with Redis

March 03, 2021 | Flask

Blog post looking at how server-side sessions can be utilized in Flask with Flask-Session and Redis.
Wooden table with the words Sessions in Flask written on it and a notebook with the Flask logo on the table, as well as a cup of coffee.

Sessions in Flask

February 09, 2021 | Flask

Blog post looking at how sessions work in Flask.