Create a database command-line utility

Posted on Thu 09 November 2023 in Python

I describe how I used Python and the SQLAlchemy ORM to create tables and relationships in an SQL database and how I created a command-line interface that allows a user to write data to the database, and read it back.


Continue reading

Use SQLAlchemy to write data to a database table

Posted on Mon 16 October 2023 in Python

How to use Python and the SQLAlchemy ORM to create a table in a database, write data to it, and read it back.


Continue reading

Package Python applications with modern tools

Posted on Mon 18 September 2023 in Python

Python packaging has changed over the past few years. In this post, I will update the way my usermapper Python package is structured and use modern tools to re-publish it.


Continue reading

Use environment variables to protect your secrets

Posted on Fri 07 April 2023 in Python

How Python programmers can set and use environment variables to improve their programs' flexibility and security


Continue reading

Learning to use Python Classes by Creating a Game

Posted on Wed 08 February 2023 in Python

Use the Pyxel game framework to create a simple retro-style game that demonstrates object-oriented programming and Python classes.


Continue reading

Use the Rich Library to Display Status Indicators

Posted on Wed 03 March 2021 in Python

This post shares what I learned about the Rich library and about context managers when I added a status indicator to a Python program.


Continue reading

Use pipx to Install a Python Program as a CLI Command

Posted on Sun 14 February 2021 in Python

It is more convenient to run a Python program from the terminal prompt instead of as a Python program in its virtual environment. This post shows you how to use pipx to install Python packages as command-line-programs.


Continue reading

Manage Azure Infrastructure with Python

Posted on Tue 02 February 2021 in Python

I wrote a new Python script that helps me manage my Azure VMs. In this post, I share what I learned about the Azure Python SDK, Azure authorization, and sorting nested lists by key.


Continue reading

Flask Web App Tutorial

Posted on Mon 30 November 2020 in Python

Use Python and the Flask framework to build a web app that re-uses code from an existing command-line application and enables users to run the application on a website, instead of installing and running it locally on their PC.


Continue reading

Video Learning Path for Python Programming

Posted on Mon 30 November 2020 in Python

A set of ten videos I created, along with links to learning resources associated with each video's topic, that work through all the steps required to build a useful network automation Python program and share it with others.


Continue reading

Python: The Minimum You Need to Know

Posted on Tue 01 September 2020 in Python

I explain the absolute minimum amount you need to learn about Python in order to create useful programs. This guide is a very short, but functional, overview of Python programming that takes less than an hour to read.


Continue reading