December 2024 – Photo of the Month
Draco is one photogenic boy, no doubt.
Python Nerdery: Natural Language to SQL Bird Call Queries
Sitting at my desk with a fresh coffee, I had an idea: build a web app that lets you ask questions about the Haikubox bird data in plain English and get plain answers back. Built the whole thing using Ollama to handle the natural language → SQL conversion, then execute the query and craft a response. Used GPT o1 Preview for most of the Python. Knocked it out in just 3/4 of a coffee cup.
Shop Server Rack – Tower 2
Always trying to improve organization and make things tidy. Moved all of the network and server hardware in my shop to a studio rack I was no longer using. Formally, Tower 2. Top to Bottom AI Docker Server i7-12700KF, 64GB, 5TB SSD, RTX 4070 and RTX 2080TI Ollama - Primarily used by OpenWebUI, but also regularly used as an API via Python. OpenWebUI - UI for Ollama Chat Qdrant - RAG data store for encoding…
Digging a pointless birthday trench
Today is my birthday and I'm spending it knocking out a task that has been nagging me for months. I had originally tucked an outdoor ethernet cable between the house and shop. I wasn't able to get 10Gbps speeds to link between the two due to what I thought was distance, so I ran a fiber cable and combined them in a cable conduit that had been sitting on the grass for months. The reason…