A small homelab blog
In my previous posts I’ve laid out: Now its time to start interacting with my database using SQLAlchemy. For this project I primarily referenced FastAPI’s excellent guide on working with SQL. Their guide provides an excellent walk-through and has served as my reference point for both SQLAlchemy and FastAPI projects. If you’re struggling with either, […]
Before we dive into migrating my old database, I thought it would be important to show how I yank MAC addresses from one of my network devices. My current home wireless setup uses a router with DD-WRT installed on it. Yanking MAC addresses from my router is real easy with python by using the netmiko […]
While I laid out four quick steps in my project, the truth is that steps are never that linear. Instead my project has been conducted in small incremental steps that often jump between creating SqlAlchemy functions and using FastAPI for validation. One thing I wanted to document during this project, was module dependencies. I did […]
As mentioned in my previous post, TinyDB eventually presented the same problem that hosting a CSV file did for my project: it became large and unwieldy. TinyDB works by creating a json file that I could then query by searching for the most recent datetime or specific datetime to get a list of mac addresses […]
Since setting up my home lab five years ago, I’ve loved to track lots of data points about my network. This all initially started with huge CSV files that I would rotate either yearly or monthly and display with a graphing tool called dygraphs. As I continued to learn, I slowly introduced projects on my […]
2023 was a pretty vicious year for my reading goals…Moving and figuring out a new job will do that to you though. Here’s a photo of the 24 books I read in 2023: Choosing favorites is always hard…But here’s a quick few I really enjoyed:
2022 was the first year that I decided to save all the books I’ve read so that I could reflect on what I read. In total I read 38 books. I tried very hard this year to rotate between IT related books, leadership/ management, and novels. Here’s a photo of my 2022 stack: Here’s a […]
In studying for Cisco’s 350-901 DEVCOR Exam, I wanted to make sure I got some hands on practice with some of the objectives. Topic 3.1’s, objectives is: Construct API requests to implement chatops with Webex Teams API. I decided to look into creating a bot that would notify me about certain things going on around […]
If you host services at home, an ISP can ruin your day by suddenly changing your home IP address. Luckily, many DNS providers allow you to automatically update your records with them via an offering known as Dynamic DNS. My DNS provider, Google Domains, supports either a client or API option and offers instructions here. […]
Prior to putting a website online I could see that my firewall logs were filled with blocks from scanners attempting to hit my WAN IP via telnet, ssh, http, rdp, etc. However, once I opened up my firewall for http and https, I realized I had another brute force problem on my hands: scanners were […]
