May 2023 Summaries

Doorstead, a property-tech startup, is revolutionizing property management by ensuring guaranteed rent and comprehensive service, thereby aligning the interests of owners and managers to minimize vacancies. CTO Philip Lee, who joined in 2021, leveraged Retool to enhance Doorstead's internal operations, enabling the company to scale efficiently during rapid growth. Retool's platform allowed Doorstead to build custom tools for pricing and operational needs, significantly increasing productivity and reducing human error. This shift from Airtable to Retool facilitated faster property readiness and improved tenant services, with structured data and automation optimizing the business model. Retool's adoption extended beyond internal tools, enhancing the tenant experience by streamlining maintenance request processing, which contributed to Doorstead's operational efficiency and growth, allowing them to manage a larger number of properties effectively.

Customer support and service teams are essential for businesses as they are often the first to identify product issues and play a crucial role in coordinating with other departments to resolve them. Despite an increasing demand for customer care, challenges such as slow onboarding, high employee attrition, and disconnected tools hamper their efficiency. Companies like Plaid have faced inefficiencies due to manual processes and disconnected systems, leading to suboptimal customer experiences. Solutions such as ready-made templates can help streamline processes by enabling developers to quickly build and customize internal tools, thus reducing development time and improving support workflows. For instance, efficient ticketing systems, call center analytics dashboards, and customizable Zendesk dashboards can enhance customer satisfaction and operational efficiency. Utilizing tools like Retool can significantly speed up time-to-deployment and reduce the engineering workload, as demonstrated by Greenly, which improved its deployment speed by 3x and saved over 50 engineering hours a month. Such improvements are vital for scaling businesses to maintain high customer satisfaction and effective product feedback loops.

Greenly, a company addressing the climate crisis through carbon accounting, has significantly enhanced its internal and external tool development by leveraging Retool, a platform that balances the flexibility of custom software with the efficiency of pre-built solutions. Initially adopted to build internal tools rapidly, Retool has enabled Greenly to save over 50 engineering hours monthly and streamline processes across various departments, such as creating custom solutions for sales teams and carbon calculators for climate experts. As the company expanded its use of Retool, it began developing tailored customer-facing applications, allowing for quick iterations and customized experiences across diverse industries like finance and food. These Retool-built apps are integrated into Greenly's customer portal, facilitating seamless data collection and analysis while maintaining stringent data security standards. Greenly's approach, championed by COO Matthieu Vegreville, empowers team members to contribute to product development, promoting a culture of innovation and efficiency while focusing on the core mission of reducing carbon emissions.

GraphQL is a versatile query language and server-side runtime that offers fine-grained control over data transactions, providing a solution to the inefficiencies of REST APIs by allowing clients to request exactly the data they need. Originally developed by Facebook to overcome the limitations of REST, GraphQL facilitates efficient data retrieval by accessing multiple tables with a single query, thus streamlining frontend-backend interactions. Since its open-source release in 2015, GraphQL has gained widespread adoption by companies like GitHub and Starbucks, and it integrates with various languages and databases, although it requires third-party libraries for database connectivity. While GraphQL offers advantages such as reducing over-fetching and under-fetching of data and simplifying nested data queries, it presents challenges like a higher complexity floor and less intuitive error handling compared to REST. Nonetheless, GraphQL's ability to improve data access efficiency makes it a desirable option for diverse applications, especially in scenarios requiring complex data interrelationships, although developers must address certain limitations like caching and file uploading through additional solutions.

Retool has introduced a new pricing model that is more cost-effective for most customers by differentiating between standard users, who build apps, and end users, who only view or use the apps. The company has added an annual billing option for its Team and Business plans, offering a 20% discount, and launched a self-hosted Business plan that includes advanced security features without needing sales interaction. While most SaaS companies are raising prices, Retool aims to lower theirs to promote word-of-mouth growth and deliver exceptional value, as evidenced by customer success stories from companies like Ramp and Plaid. The changes address feedback that pricing was sometimes a barrier to wider adoption, encouraging organizations to adopt customizable software solutions for internal operations. Retool is focused on transforming software development by making custom operational software accessible to all companies, highlighting the inefficiencies in current software development practices and aiming to capture a significant market opportunity where developers spend a substantial portion of their time on internal tools. Existing customers can transition to the new pricing plans, which are likely cheaper, and Retool continues to seek feedback to enhance its offerings.

PlanetScale is an advanced MySQL-compatible database service powered by Vitess that provides scalable solutions for applications, and this tutorial guides users on how to connect it with Retool to build internal tools and dashboards. The process begins with setting up a PlanetScale database, followed by creating and configuring a MySQL resource in Retool, ensuring secure connections using SSL/TLS and a CA Certificate. Users then utilize Retool's Query Library to seed their PlanetScale database with tables and sample data, enabling the creation of a basic schema with teams and players. Once the database is populated, a Retool application is developed, where queries are created to retrieve and display data dynamically. The tutorial emphasizes the potential of combining PlanetScale and Retool for building powerful internal tools, encouraging users to explore further possibilities through community forums and additional projects, such as integrating Retool with Square APIs for a ticket-selling dashboard.

The guest post by Aaron Fritsch from Archilogic discusses the importance of floor plans in industries like real estate, construction, and facilities management, highlighting their role in providing a visual representation of physical spaces and facilitating property management. It introduces Archilogic's tools that enable developers to create applications for managing and visualizing these floor plans using digital twins, which are virtual replicas of physical spaces. By integrating with Archilogic's SDKs and APIs, users can efficiently update and maintain accurate floor plan data without needing extensive architectural knowledge. The post provides a step-by-step guide on building a Retool application for visualizing floor plans and retrieving resource information, emphasizing the ease and speed of updating digital twins and integrating spatial data into applications without the need for building complex infrastructure independently.

As SQL approaches its 50th anniversary, it remains the dominant language for managing and querying data in relational databases. Originating from IBM's development of System R, SQL has become a "lingua franca" in data management, influencing countless database systems like MySQL, Postgres, and Microsoft SQL Server. Despite its age, SQL remains crucial, with commands like CREATE, INSERT, SELECT, UPDATE, and DELETE forming the backbone of database operations. The language's complex syntax and error messages contribute to a love-hate relationship among developers, further complicated by its high stakes in data manipulation. While SQL dialects exist due to various database optimizations, its standardized format under ANSI helps maintain consistency. As technology advances, tools like large language models are emerging to assist in SQL writing and optimization, ensuring its continued relevance and growth in the data management ecosystem.

In a tutorial detailing the creation of a lightweight ticket-selling dashboard, the author explains how to leverage Square's Payment APIs and Retool's drag-and-drop interface to build a custom ticket-selling application. The guide covers setting up a Square API resource, creating Retool resource queries, and using various APIs to manage ticket orders, including creating, searching, and retrieving orders. It provides specific instructions on configuring the front end in Retool, including setting up ListView and Form components for ticket purchasing and a Table component for managing and viewing order details. The tutorial emphasizes hands-on experience, encouraging users to test the application thoroughly and explore further customizations, such as integrating with other APIs for additional functionalities like donations or loyalty programs. The overall goal is to offer a customizable, user-friendly ticket-selling platform that minimizes fees and enhances the user experience.

Many businesses rely on spreadsheets for data management, but as data complexity grows, spreadsheets can become a liability due to issues like data integrity, performance slowdowns, and collaboration challenges. When spreadsheets become unwieldy, transitioning to a relational database is recommended for better data integrity, scalability, and advanced querying capabilities. No-code tools like Airtable offer an intermediary solution by providing structured data storage and basic relational database functionalities, although they still face limitations in handling complex data operations. Retool Database is suggested as a user-friendly gateway to relational databases, combining a spreadsheet-like interface with PostgreSQL's robustness, enabling users to import CSV files, build custom applications, and automate workflows efficiently. By leveraging Retool's features, businesses can create scalable and reliable data-driven applications, overcoming the limitations of spreadsheets and no-code tools.

In 2023, companies are increasingly investing in internal tools to streamline operations and reduce manual processes, spending approximately 4.5 trillion dollars annually on IT, with a significant focus on admin panels, dashboards, and custom tools. A survey of over 2,200 engineers and operators revealed that JavaScript and SQL are the most commonly used languages for building these tools, with React being a favored frontend framework. Despite the popularity of custom-built tools, many organizations also rely on platforms like Retool, Zapier, and Google Sheets for prototyping and managing internal processes. Business intelligence tools such as Tableau remain prevalent, although there is some dissatisfaction with their integration and automation capabilities. As companies aim to consolidate SaaS tools and enhance productivity, there is a growing trend towards using scalable platforms and reducing context-switching between disparate systems. Moreover, the development of AI technologies is anticipated to play a significant role in advancing internal tooling experiences, as organizations continue to measure success through improved productivity, employee adoption, and internal user satisfaction.