-
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
-
Enhanced API Flexibility Through Slug Decoupling
To streamline API identification, we decoupled slug management from core icon functionality. This allowed us to introduce dedicated tables for slugs and their types, ensuring a centralized system. We also implemented a “SlugHistory” table for seamless redirects and historical context. Moving forward, we plan to enhance the API with features like slug suggestions and drag-and-drop… 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
-
Infinite Scrolling in React
oday, I implemented a toggle for site edit mode, optimized code navigation with markdown links, and removed outdated code. I also created a dialog for editing navigation icons and explored infinite scrolling in React. I tackled performance issues, including debouncing scroll events and leveraging useDeferredValue for smoother item loading. Read More
-
REST API Paths
When naming REST API paths, it’s important to follow best practices such as avoiding file extensions, using HTTP verbs like GET, POST, PUT, DELETE, and placing variable names in the path. Proper structuring of endpoints helps differentiate between collections and singletons, like using /api/users for a collection and /api/users/123 for a specific resource. Relationships between… Read More
-
RTK Query
I transitioned my Redux application to use RTK Query for API calls. This reduced the need for selectors and simplified data management. While RTK Query is powerful, it has limitations like needing many endpoints for a single server and requiring complex TypeScript types for builders. Sagas are still used for specific cases like handling drag-and-drop… Read More
-
Queue Downloads
I created @codejamboree/web-requests-queue, a library that queues and spaces out HTTP requests to prevent server overload, with features like pausing, resuming, and downloading files or parsing JSON. I also developed a basic testing platform with function mocks and expectations. The library is available on GitHub and npm. Read More
-
Encryption Key Backup
Without access to a key management service, I work on different solutions to backing up encryption keys off-site while thinking through security risks and the recovery process. Read More