Software Engineer
Current
New York City, Ny, Us
• Built a cross-platform desktop application using React to render reusable components, and manage data flow through prop drilling and hooks, to provide users with an organized and easy to use interface for monitoring database analytics.• Created an intuitive frontend GUI for dynamic state updates in modular components, allowing users to send queries through a Codemirror component, and handle incorrect statements using SQL query validation.• Utilized Node to provide modular functionality to our application, and employed Node’s package management system (npm) to use only necessary packages/modules that were needed to accomplish desired functionality and features.• Leveraged the TypeScript superset of JavaScript to implement static typing in order to identify and reduce bugs, improve developer experience and readability, and easily transpile down to more performant code.• Implemented PostgreSQL to create and store new database instances, which allowed for schema analysis by means of query speed comparison, and what-if analysis using dummy data generation.• Integrated Electron application with containerized PostgreSQL instances for sandboxed SQL testing, database import, and reliable creation and storage of large dummy-data files.• Streamlined development and production builds for Electron project executables, which allowed for optimal customization of codebase without sacrificing size or functionality, and also provided stable versions of native applications.• Product developed under tech accelerator OS Labs (opensourcelabs.io)