-
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