-
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
-
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
-
From JSON to SQL: The Road to Efficient Icon Management
Today, I focused on organizing Material UI icons and preparing them for database integration. After generating over 30,000 SQL inserts, I optimized the process to run multiple queries efficiently, avoiding a lengthy execution time. Along the way, I tackled a MySQL issue involving multiple statements and resolved it with a simple change in method usage.… Read More
-
PHP Error Database
I created a new database to log errors and proceed to move errors from the error log into the database while keeping tabs where I left off. In addition, I capture errors and exceptions as they happen and log them as well. A small Angular application is created to view the errors. 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
-
Separating Services
Changes were made to store the secrets in a separate database rather than a JSON file to allow scalability and portability. An initial design had setup an over-engineered system for an enterprise. Then it was simplified, and further normalized. 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