June 2021 Summaries

Low code and no code platforms are gaining traction as tools to streamline software development through visual interfaces, with Gartner forecasting that over 65% of application development will utilize these platforms by 2024. Low code allows developers to build applications using a mix of visual components and custom code, while no code eliminates the need for coding entirely, targeting non-technical users. Despite skepticism among some developers, who fear vendor lock-in and scalability issues, low code can accelerate development time, improve productivity, and expand developer capabilities, especially for creating internal tools, user interfaces, and automating legacy systems. As enterprises and startups adopt these technologies, they can modernize their tech stacks and achieve faster iterations, although the platforms may not fully replace traditional software development. The impact of low code is significant, as it democratizes software creation, enabling broader participation beyond traditional developers, and reshapes the landscape of software development by allowing developers to focus more on complex problem-solving.

MongoDB is a widely used NoSQL database known for its flexibility and horizontal scaling advantages over traditional relational databases. It leverages document databases through nested key-value pairs, making it conducive for front-end data parsing. While MongoDB can be accessed via the command line, GUIs offer a more user-friendly alternative for managing data, especially with medium to large datasets. Popular GUIs for MongoDB include MongoDB Compass, TablePlus, Robo 3T, Studio 3T, MongoDB Atlas, and NoSQLBooster, each offering unique features such as schema visualization, code autocomplete, and integration capabilities. These tools facilitate easier data management, visualization, and editing without the need for extensive command line use, catering to different user needs and project scopes. Additionally, Retool allows for rapid app development connected to MongoDB, highlighting the diverse options available for working with MongoDB databases.

Processing sensitive data using SaaS products presents challenges, particularly in regulated environments where data movement or storage through vendor clouds may necessitate extensive security reviews. To address these concerns while supporting developers in building business apps securely, a self-hosted solution involving Retool plans was developed, requiring a system for license key management due to the increase in self-hosted customers and product complexity. Initially managed by simple scripts, the process became unscalable as customer numbers grew, prompting the introduction of the Account Team Dashboard. This dashboard empowers account teams to independently manage customer licenses with features like generating license keys, extending trials, mapping Salesforce accounts, and enabling custom feature flags. The dashboard integrates multiple data sources and utilizes queries to streamline operations, reducing dependencies on engineering, accelerating onboarding and renewals, and enhancing the overall customer experience. Retool's tool has become essential for efficient workflow and time savings, exemplified by significant reductions in debugging and customer support time, showcasing the benefits of removing dependencies and speeding up processes.

Modern applications and websites often incorporate maps, ranging from simple address displays to intricate features like stock level identification by location. For complex mapping applications in React, the article identifies google-map-react and react-leaflet as the top choices due to their versatility and ease of use. Google-map-react is ideal for projects using the Google Maps API, offering quick setup and comprehensive documentation, while react-leaflet stands out for its adaptability, working seamlessly with both open-source solutions like OpenStreetMap and proprietary ones like Mapbox. Despite the popularity of these two libraries, the article also acknowledges other options like React-map-gl, which integrates with Mapbox GL, and Pigeon-maps, noted for its lack of external dependencies. Ultimately, leveraging well-documented and robust React map libraries can significantly simplify the integration of mapping functionalities into React applications.

Retool, a tool for engineers to build internal applications quickly, initially launched with a cloud-only version, but encountered challenges with potential customers unable to connect their databases due to security concerns. As a solution, Retool developed an on-premise offering using Docker, allowing customers to host Retool within their own cloud environments, thus ensuring data never leaves their infrastructure. This move was pivotal in attracting large enterprises and regulated industries, significantly expanding Retool’s customer base. The shift to on-premise not only mitigated security concerns and accelerated security review processes but also aligned with industry trends where many cloud-reliant companies generate substantial revenue from self-hosted deployments. While supporting on-premise solutions presents challenges such as maintaining consistent features across different deployment models and managing multiple software versions, Retool has managed these issues effectively, demonstrating that self-hostable software offers compelling advantages for certain business needs.

Retool has announced a public beta for a self-hosted deployment option for its Free and Startup plans, allowing more customers to deploy the platform on their own infrastructure, such as behind a VPN or within a VPC. This development caters to developers, particularly in regulated industries like financial services and healthcare, who require private deployments for security and compliance reasons. Previously, self-hosted deployment was only available through the Enterprise plan, which involved additional steps, but now developers can easily sign up for a self-serve account and choose a self-hosted option. Both SaaS and self-hosted deployments offer the same features, but self-hosting provides enhanced security and control, ensuring sensitive data remains within a private network and offering flexibility in software updates and workflows. Retool aims to meet the needs of developers in various operational scenarios, promoting both cloud and on-premise solutions as the trend for hybrid offerings grows.

In the evolving landscape of web applications, autocomplete features have become increasingly essential, with Downshift emerging as the preferred React autocomplete library due to its simplicity, flexibility, and accessibility. Developed by Kent C. Dodds, Downshift is distinguished by its use of render callbacks and controlled props, which allow developers complete control over component states without relying on external APIs. Although not the most popular in download numbers, Downshift is praised for its excellent documentation and its ability to seamlessly integrate with accessibility tools like Apple's VoiceOver, making it particularly useful for users with vision impairments. While other libraries such as react-select, react-autosuggest, and react-bootstrap-typeahead are also popular, they have varying degrees of support, documentation, and development activity, with react-select being the closest runner-up due to its active development and backing by major companies. Downshift's small size and efficient performance further solidify its position as the optimal choice for most use cases in building modern web applications that require robust autocomplete functionality.

The ongoing debate between on-premise and cloud computing revolves around the differences in equipment ownership, maintenance, and control, with each option offering distinct advantages and challenges depending on a company's needs. On-premise infrastructure requires physical server ownership, maintenance by IT staff, and significant upfront capital expenditures, while cloud infrastructure provides scalability, global coverage, and operational expenditure flexibility, albeit with potential risks of vendor lock-in and high costs. For startups, the public cloud offers agility and cost-effective scaling, though enterprises often face complex migrations due to existing investments in on-premise systems. The emergence of private cloud and self-hosted software solutions offers a middle ground by combining the public cloud's scalability with the control of on-premise systems, leading to a multi-cloud strategy that many companies adopt. This approach allows organizations to re-evaluate their infrastructure needs and consider private clouds as a viable alternative, indicating a possible shift towards more localized infrastructure solutions in the future.

Date pickers are crucial components in many applications, particularly for event bookings, as they enhance usability by preventing invalid date entries and eliminating format confusion. Previously, React Native provided date picker APIs for Android and iOS, but these are now deprecated, prompting developers to either create custom solutions or use third-party libraries. Upon evaluating several React Native date picker libraries based on documentation, popularity, update frequency, usability, bundle size, and the reputation of creators, the React-Native DateTimePicker emerged as the best option due to its popularity, comprehensive documentation, active maintenance by the React Native community, and wide support for multiple platforms. Alternatives like react-native-modal-datetime-picker, react-native-date-picker, and react-native-calendar-picker also offer viable options depending on specific needs. The React-Native DateTimePicker is noted for its simplicity in installation and integration, making it a suitable choice for developers seeking a reliable date picker solution in their applications.

Admin panels are essential for moderating content, managing user accounts, and tracking metrics on a platform, with various options available for building them, including database GUI clients, frontend admin libraries, backend admin frameworks, and third-party tools like Retool. Each option has its strengths and weaknesses: database clients provide raw data access but lack in automation and monitoring capabilities; frontend templates offer good user experience for data entry and editing but require custom coding to connect to backends; backend libraries simplify admin panel creation through automation but are difficult to extend; and Retool combines the benefits of frontend libraries with ease of building and maintaining custom interfaces. The choice of admin panel depends on the project's complexity and technical requirements, with Retool being particularly effective for building flexible and easy-to-extend admin tools.

Oddbox, a company dedicated to tackling the UK's food waste problem by delivering surplus fruits and vegetables, faced challenges in its customer service processes due to an inefficient system reliant on Google Forms and spreadsheets, which led to delays and errors in complaint handling. To address these issues, Senior Product Manager Tommy Newman implemented Retool, allowing for the development of the Customer Happiness Tracker app that streamlined the complaint logging and resolution process. This app provided customer service agents with a comprehensive and user-friendly interface, improving data accuracy, reducing response times, and enabling better communication with third-party vendors and internal teams. The new system not only enhanced the overall customer experience but also facilitated the onboarding of new agents and allowed Oddbox to track its performance against company goals. As a result, the customer service team became more efficient, and Tommy plans to further refine the system to enhance its functionality.