-
Lewis Moten: Materials for Our Data Review Discussion
A reply to the WCFAC chair explaining my custom data-analysis workflow, limits of automation without stable county data access, and rationale for separating policy concerns into a broader supervisory discussion, while keeping this exchange focused on tools, methods, and transparent financial analysis. Read More
-
Lewis Moten: Materials for Our Data Review Discussion
An email sent to the chair of the Warren County Finance Audit Committee outlining the tools, methods, and datasets used to analyze county financial records. It documents the technical context behind audit-related findings and a follow-up to a public meeting discussion. Read More
-
When Modern Accountability Meets 1980s Technology
A canceled county meeting led me into a surprising look at our decades-old financial system—complete with telnet screens and missing programmers. Between illness, community kindness, and late-night coding, I built a powerful new tool to analyze general-ledger data and push modernization forward. Read More
-
Raspberry Pi Digital Signage
I look into various services and projects that offer digital signage kiosks on a low budget. Most start out at $10 or more per month, and free versions are fairly limited in capability or just bad. I then start creating my own service. Read More
-
From Confusion to Clarity: Database Query Optimization
In this blog post, I discuss optimizing database queries and improving the user interface. By using common table expressions and grouping, I resolved issues with inconsistent icon tagging. I also separated the tab rendering functionality into a dedicated React component for better maintainability. This approach has enhanced the overall user experience and will continue to… Read More
-
Slugs: A Deep Dive into Web Development
In the realm of web development, slugs serve as the unsung heroes behind the scenes. These unique identifiers, often derived from content titles, play a crucial role in enhancing user experience, improving search engine optimization (SEO), and streamlining content management. By understanding the benefits and best practices associated with slugs, you can elevate your website’s… Read More
-
Error Logging
Read through as I parse PHP large error log files and then progress to architect a database to hold them more efficiently. Read More
-
Secure Database / Vault
I venture on a path to evaluate the cryptographic features available on my shared hosts database, tests its weaknesses, setup auditing, and perform encryption outside of the database while storing keys in a secrets manager. Read More
-
Automated Database Migrations
I walk through the process of setting up a database project for automated migrations to support an environment of multiple developers and database targets enabling rolling back the database. Read More
-
Choosing a Host
Follow along as I gripe about my current host, review various hosting plans, choose a plan, and discover what’s actually under the hood. Read More