•Streamlined server setup using Express.js with a MySQL database on AWS, integrating middleware for efficient data retrieval and query optimization, boosting system efficiency and reliability
•Leveraged PostgreSQL's advanced data types and structural flexibility to boost data handling efficiency, enabling sophisticated query operations within the DbSpy system
•Optimized AWS MySQL databases through strategic data storage and query performance enhancements, reducing storage costs and boosting efficiency in high-demand scenarios, resulting in a more scalable and robust system
•Implemented React to refine the database UI, integrating global context, custom hooks, and reusable components to streamline data pattern recognition and enhance large dataset navigation for improved user interaction and long-term efficiency
•Transitioned to TypeScript from JavaScript for its robust static typing, creating reusable interfaces and a tailored lint configuration, which simplified onboarding, facilitated dependency upgrades, and boosted code reliability and maintainability across the project
•Used Axios to develop a user-friendly 'Save' feature, ensuring seamless interaction with the backend, facilitating the storage and management of multiple database configurations through patch or post requests, significantly enhancing the user experience
•Implemented Axios for data retrieval by its long term scalability, integrated it with react flow in the “Load Database” feature, enabling efficient visualization of user-specific database schemas and datasets
•Developed a React Flow-based ER diagramming tool, streamlining database visualization with interactive handles and table connections for easier management of complex data relationships
•Deployed dbSpy using AWS technologies: Elastic Beanstalk, RDS, S3 and EC2, facilitating ease of future developments and our own deployment
