TheAvgDev – Tips and tutorials on real world software development problems.

Python Selenium Learning Series for Beginner-Intermediate Developers

Leave a Comment / Uncategorized / By theavgdev

Table of contents 1. Selenium Python Install 2. Selenium Python Web Scraping Tutorial 3. Selenium Python Click Exception Resolution 4. Selenium Python with ChatGPT 1. How to Install Selenium Python into a Virtual Environment (venv) and setup VSCode / ChromeDriver This video tutorial shows how to: With the above steps complete, we are prepared for …

Python Selenium Learning Series for Beginner-Intermediate Developers Read More »

Power BI – Apply/Reuse the same transformation steps to another table

Leave a Comment / Uncategorized / By theavgdev

In the quick tutorial video below, I have 2 CSV (comma-separated values) files with identical formats. I loaded the first CSV file into Power BI, opened the Power Query editor, and applied a bunch of transformations (not important what those steps are). Now, I want to apply the exact same steps to the second CSV …

Power BI – Apply/Reuse the same transformation steps to another table Read More »

Lenovo (Yoga) Slim 7 Pro X (2022)- Personal Experience Review After 100 Days of Use

Leave a Comment / Uncategorized / By theavgdev

After 100 days, I decided to keep the Lenovo Slim 7 Pro X (14ARH7), aka Lenovo (Yoga) Slim 7 Pro X in other regions of the world. I bought it during holiday time (November 2022) and Lenovo allowed returns all the way thru January 2023, so the opportunity to return it was there. However, I …

Lenovo (Yoga) Slim 7 Pro X (2022)- Personal Experience Review After 100 Days of Use Read More »

How I deploy to web host with Git/GitHub in a team of one

Leave a Comment / Team of One / By theavgdev

Hey folks, today I want to show you one way that I use to deploy to my web host. For small low volume websites, I think this method works great. If you are still copying files manually using the browser or FTP, then this might be a better way.

Manage Development Tasks with Jira Kanban Boards in a Team of One

Leave a Comment / Team of One / By theavgdev

Working on a project by myself, sometimes I feel overwhelmed by all the tasks that I need to do when they’re swirling in my head. Using a list is a good way to get those thoughts on paper, quantify the scope of the project, and feel a sense of progression as I complete each one. …

Manage Development Tasks with Jira Kanban Boards in a Team of One Read More »

Capture Intermediate Pages on Browser Redirects

Leave a Comment / Web Development / By theavgdev

You know those sites that flashes a bunch of redirects before getting you to the page that you want? Maybe they’re doing single sign on authentication or something. Well if you ever need to figure what the intermediate pages were, here’s how to capture the redirects. Open Chrome in incognito mode so the page doesn’t …

Capture Intermediate Pages on Browser Redirects Read More »

All the Git You Need for a Team of One | Using 100% VSCode & Github | No Git Commands to Memorize

Leave a Comment / Team of One / By theavgdev

This beginner tutorial uses Git, VSCode, and GitHub to back up our source code, maintain revision history, and manage releases. Git is a powerful source code management tool and there are many different ways to use it, so things can get messy or confusing really quickly. When working on projects where I am a team …

All the Git You Need for a Team of One | Using 100% VSCode & Github | No Git Commands to Memorize Read More »

Easily Maintain Multiple Versions of PHP

Leave a Comment / Web Development / By theavgdev

We’re not using not on WAMP or XAMPP for this one. I find Laragon to be much easier when dealing with multiple versions of PHP. Download Laragon from https://laragon.org/download/ and install it. Out of the box, we get PHP 8.1 and it just works. We can grab a few more versions (7.x and 8.x) from …

Easily Maintain Multiple Versions of PHP Read More »

Web Dev Gotchas: Javascript Changes Not Showing Up

Leave a Comment / Web Development / By theavgdev

This is a problem that every new web developer will run into. You modified your JavaScript file but the changes don’t show up on the browser. So you hit F5 a bunch of times, double-checked that you really saved the file, and still nothing. Looks like your browser randomly decided to use the cached version …

Web Dev Gotchas: Javascript Changes Not Showing Up Read More »

How I Accept Credit Card Payments on My Local Business Website | PHP Stripe Integration Tutorial

Leave a Comment / Uncategorized / By theavgdev

I’d like to share how I use Stripe to process credit card payments for restaurant pick-up orders. After the customers select their items, I send them to Stripe’s payment page to finish checkout. After they complete their payment, Stripe sends them back to my site to confirm the order. In this video, we’ll focus on …

How I Accept Credit Card Payments on My Local Business Website | PHP Stripe Integration Tutorial Read More »