-
Patterns and Pages: Introducing Myself to the Samuels Community
In December 2024, I stood before the community to introduce myself as a new Library Trustee. I shared my background in IT and data analysis—though my nerves got the best of me when I accidentally said I joined in 2013! Read More
-
Workshops, SAR, Veterans Day, and Lasers
Many things happening over the past few days. A Raspberry Pi workshop being planned, acceptance to VASSAR, Veterans Day, and learning how to use the Laser Cutter. Read More
-
Samuels Library Officials Respond to Supervisor Assertions about Finances and Operational Accountability
Royal Examiner: I’m referenced as a Trustee-at-Large attending a special Board of Supervisors work session, joining library leadership in responding to assertions about finances, FOIA compliance, and governance—emphasizing transparency, audited performance, and the public value of Samuels Public Library. Read More
-
Warren County Supervisors and Library Trustees Meet
The recent Warren County Board of Supervisors meeting, held on October 29, 2024, included a detailed discussion with the Library Board of Trustees on the county’s budget allocations and events from last year. The session, lasting two hours, touched on operational funding breakdowns. As representatives took turns addressing prepared statements, community interest was clear, with… Read More
-
The October Joint Meeting: Observations from the Front Lines
On October 29, 2024, I was invited to the table for a joint meeting between the Nonprofit Library Trustees and County Supervisors. This clipped record captures my direct dialogue on funding, accountability, and the complexities of the library’s private nonprofit status. 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
-
Overcoming Challenges in Building an API with RTK Query
Building an API with RTK Query can be a rewarding experience, but it comes with its own set of challenges. One common hurdle is managing large apiSlice files, which can become difficult to maintain as the number of endpoints grows. To address this, I explored code splitting and modularizing endpoints, but these approaches introduced their… Read More
-
Studio 330 Ribbon-Cutting
A ribbon-cutting at Studio 330 marked more than a new makerspace opening. After the book challenge controversy, the Mellon grant, Library of the Year recognition, and Erin Rooney’s leadership showed Samuels Library turning toward renewal. 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