A small homelab blog
Now that I have a functioning app, I’d like put a reverse proxy on it so that I can limit what addresses can reach it and put an SSL certificate in front of it. To do this I’ll be using NGINX and Let’s Encrypt. Lets Encrypt offers several ways to obtain a certificate for your […]
Now that I’ve got a functioning app, my final step in my original plan is to create a container of it. I referenced several sites but ultimately started with FastAPI’s Build a Docker Image for FastAPI.The page helped me get started, but since it was a pretty basic example, I had to make adjustments to […]
When you begin exploring APIs to work with, you’ll find that many come with outstanding documentation and offer live examples. One of the things that made FastAPI so intriguing to me is that they offer this right out of the box. In the previous post, I showed how to make several API endpoints and you […]
Now that we have the ability to interact with our database, its time to explore how we can use our API to interact with the queries we made. In this post, I’ll show how to pull a list of the mac addresses currently on my network, followed by pulling information about a specific mac address. […]
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:
