February 2023 Summaries

Retool offers a streamlined approach to building administrative applications by simplifying frontend development with pre-built components, enabling teams to efficiently leverage data warehouses like Snowflake. The tutorial guides users through creating a simple admin panel for Snowflake, detailing steps such as setting up sample data, establishing a connection with Retool, and building an app to view, search, and manipulate data. Key functionalities like adding, updating, and deleting records are supported through SQL queries and UI components, with a focus on ease of use and best practices in naming and permissions. The process underscores Retool’s versatility, with potential applications extending to other databases and data warehouses.

The tutorial, with contributions from Amarachi Aso, provides a step-by-step guide on building a basic CRUD admin panel using Retool, connected to a Redis database. It explains the reasons for choosing Retool, highlighting its prebuilt frontend components and the ease it offers to developers who prefer writing SQL and JavaScript over React components. The guide covers setting up a Redis database with sample employee data, integrating it with Retool, and creating a user interface to perform CRUD operations. It also details the construction of queries for adding, updating, and deleting records, and demonstrates how to create and link corresponding UI components in the Retool editor. The process concludes with testing to ensure the functionality of the app, and the tutorial encourages further exploration of Retool’s capabilities and templates for building other applications.

In the months leading up to Y Combinator's Demo Day for the Winter 2017 class, David Hsu's fintech startup was on the brink of failure, burning through $1,000 daily and facing a dire financial situation. The team decided to pivot from their UK-based Venmo competitor to creating a tool that would allow for the drag-and-drop building of internal software, inspired by the custom software they had developed to keep their fintech operations running. This shift led to the creation of Retool, which they successfully presented at Demo Day, landing a $1.5 million enterprise customer pilot. Initially relying on outbound sales to gain traction, the company later experienced a dramatic shift to inbound sales after a successful post on Hacker News, leading to rapid growth and the hiring of a go-to-market team. Retool's success was further propelled by developing tools to monitor and support users in real-time, ensuring customer satisfaction and retention. Their journey to product-market fit was marked by a strategic shift in messaging and target market, moving away from legacy software users to focus on developers of internal applications, which ultimately led to substantial growth and a $50 million Series B funding round. Looking ahead, Retool sees significant opportunities in enhancing the quality of internal tools for businesses, aiming to improve efficiency and employee satisfaction.

React Native and Expo CLI offer distinct advantages for mobile app development, with Expo increasingly favored due to its streamlined processes and support from the React Native core team. Originally, Expo had limitations, particularly with native libraries and in-app purchases, but recent updates, including EAS Build and Expo Dev Clients, have addressed many of these concerns, enhancing compatibility with native features and expanding development capabilities. Expo Go, a key component, allows for easy testing via QR code but initially lacked support for native libraries; however, Expo SDK libraries and the ability to create custom Dev Clients have mitigated this issue. The Expo Application Service (EAS) further facilitates app development and submission processes, although it requires a paid subscription for full features. Despite some historical objections, Expo's advancements have largely dispelled concerns about app size, build resources, and support for features like WebRTC, making it a preferred choice for developers who value ease of use and efficiency.

Retool has transitioned its continuous integration (CI) environment from Azure Pipelines to Buildkite, leveraging Kubernetes for both production and test environments to ensure consistency and efficiency in managing deployments. Infrastructure engineer Anna Yan spearheaded the project, opting for the Garden toolkit over other options like Tilt, due to its dual focus on supporting both developer environments and CI processes. This transition allowed Retool to gain granular insights into test metrics, enabling precise resource allocation. While acknowledging the challenges smaller companies might face in implementing similar setups, Anna emphasized the importance of choosing the right tools, like Buildkite for its flexibility and scalability. By aligning development and production environments through Kubernetes, Retool has streamlined its operations, allowing for effective knowledge transfer within its engineering team, and is now focusing on resolving test flakiness to further improve their infrastructure.

In a detailed exploration of personal Amazon spending, the author describes building an "Amazon Purchases Insights Dashboard" using tools like Google Sheets, Retool, and ChatGPT to analyze purchase data from 2022. By downloading purchase history as a CSV from Amazon, importing it into Google Sheets, and utilizing Retool's integration, the author was able to create a dashboard that visualizes monthly and category-based spending, highlights the most expensive purchases, and identifies trends such as a high expenditure in June due to travel-related shopping. ChatGPT assisted in categorizing items into broader groups to simplify analysis. The dashboard revealed significant spending on baby-related items, a high return rate of 20%, and an average monthly expense of $838, emphasizing the ease of overspending with online shopping. This project offers insights into personal spending habits and provides a framework for more effective budgeting in the future.

Technical teams dedicate a significant portion of their time to developing internal tools, with an average of 33% of their working hours focused on these projects. This trend is particularly pronounced in larger companies, where more time and code are dedicated to internal use cases. As businesses expand, the reliance on both custom code and no-code solutions like Zapier and Airtable becomes more prevalent, alongside popular frameworks such as React. Databases are the primary data sources for these tools, with PostgreSQL being the most favored option. Operations teams are the predominant users of internal tools, signaling a shift in focus towards operational efficiency. Despite the critical role these tools play, many lack robust access controls, posing security risks. Companies often employ full-time positions to manage these tools, primarily within engineering and operations departments, with productivity improvements being the primary metric for assessing their ROI. The survey insights underscore a persistent trend in how internal tools are valued for their role in enhancing productivity while highlighting opportunities for increased security measures.