![]() He could refactor the code in place, test it and deploy it incrementally before he introduced the new, centralized database. ![]() Mike added the clientId field to the existing databases even though they didn’t need it. The solution ended up being astonishingly simple (the best solutions always are). The question was how to refactor the existing code-base, migrate old customers, minimize downtime, minimize development time, and avoid having to maintain two codebases for the different database schemas during the transition. It would need a new schema with an added clientId field for most tables. We decided it was best to stick with MySQL, but refactor the code to use a centralized database. I helped Mike think through the possibilities and we came up with a simple solution. He was proverbially tied to the train-tracks and the locomotive was barreling down on him. MySQL is not designed to scale this way, and performance and memory problems were starting to creep up. Each new customer, free or paying, added another database to his MySQL server.įast forward to 2019 and MemberVault’s MySQL server had thousands of databases. In the rush to get things out the door, he didn’t have time to change his original design: each client required their own database. ![]() Mike quit his day job and, together with his wife, started working full time on marketing, sales, customer support, bugs and new features. Instead, he moved towards a software-as-a-service solution, hosting each client’s course in one place for a monthly fee. He quickly realized it was going to be a nightmare to maintain the software in each client’s environment. His plan was to package up the product so it would be easier to custom-install on each clients’ hardware. That client had reach, and other people started asking about his work. Since it was a side job, and Mike was bored, he offer to do this job at a deeply discounted rate if he could retain rights to the source code. In 2016 he took a side job to build a simple course platform. Support concurrent engineering with the factory: Bill of material (BOM) transformation tools enable manufacturing engineers to quickly view and reconcile upstream changes to downstream manufacturing and plant-specific BOMs.Why do we care about modular design? Let me tell you a story about my friend Mike Kelly.By allowing users to identify changes in the view states captured in the CAD design, Windchill can now enable better management of CTQ characteristics. Visually manage critical to quality (CTQ) characteristics: Creo View 7, embedded in PTC's product lifecycle management software, provides visual comparisons based on process manufacturing information (PMI) created through model-based definition (MBD) practices.This capability is delivered through tight OSLC integration with the PTC toolchain and third-party requirements management tools (i.e. Implement closed-loop quality: System integration delivers proof of traceability for finding and fixing problems early.Experience eight times faster time-to-value for building a new custom app, down from three and a half months to under two weeks. Rapidly develop role- and task-based apps: ThingWorx Navigate 9.0 enables customers to build their own unique custom apps, leveraging a rapid app development environment with reusable components.Experience better collaboration, closed-loop quality, and concurrent manufacturing.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |