A small homelab blog
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, […]
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 […]
