-
Fuel Report Discrepancies
I’ve been sitting in on the Warren County Finance/Audit Committee meetings since May of this year. I’ve been noticing a few things, writing notes, and just observing. I decided to go ahead and start digging into something that was bugging me. The fuel reports every month had a column that reported 0 MPG for many… 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
-
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
-
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
-
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
