April 2020 Summaries

Following Google's announcement of a phased shutdown of its Google App Maker platform, users are exploring alternative low-code app development tools, with several options available before the complete cessation of the service. AppSheet, newly acquired by Google Cloud, is deemed a suitable alternative, particularly due to its cross-platform functionality and affordability, though it has limitations in SQL database integration and customization capabilities. Microsoft Power Apps offers seamless integration with Office365 but is less customizable for advanced users. Salesforce Lightning Platform is ideal for automating workflows related to Salesforce data, although it may not be suitable for those new to Salesforce. Zoho Creator is favored by small to medium-sized businesses for its ease of use but requires learning its scripting language, Deluge. Appian, with a higher price point, is better suited for larger companies, excelling in form-based apps with built-in customization tools. WaveMaker offers extensive customization through its IDE but is notably expensive, making it apt for larger enterprises with substantial budgets. Retool provides flexibility and integration with numerous platforms, appealing to small to medium businesses despite its learning curve. Ultimately, the choice of platform depends on company size and specific requirements, with each tool offering distinct advantages and limitations.

The migration of Retool’s community from Spectrum to Discourse involved significant data handling and transformation challenges due to differences in data structures and the lack of documentation from Spectrum. Spectrum’s data, stored in RethinkDB with DraftJS formatting, required conversion to Discourse’s Markdown-friendly schema. The process included creating a DraftJS to Markdown parser, handling user creation with accurate post attributions via HTTP headers, and mapping threads and messages to Discourse’s topics and posts through the API. Despite the successful migration, challenges such as API rate limiting, incomplete data transfers, and manual interventions were encountered, underscoring the complexity of such transitions. The team open-sourced their migration scripts to aid others facing similar tasks, highlighting the intricacies of maintaining community integrity across different platforms.

React-admin is a powerful framework for building admin panels and internal tools using React, Material UI, and other libraries that facilitate the creation of frontend applications interacting with existing REST or GraphQL APIs. Developed by Marme Lab, it allows for the easy management of data through features like data providers, relationship support, conditional formatting, and datagrids. This tutorial walks through creating a fully functional admin panel with react-admin, showcasing how to use data providers to connect to APIs, customize data displays using components like Resource and ListGuesser, and integrate authentication using Firebase. The framework emphasizes modular development, allowing developers to build custom components and fields tailored to specific needs, and supports optimistic rendering to enhance user experience by updating the client-side state before server confirmation. React-admin's flexibility and ease of use make it a valuable tool for developers looking to create robust internal applications quickly.