March 2023 Summaries

Retool has introduced Usage Analytics to its Enterprise plan, providing a centralized platform for monitoring application and user adoption, essential for informed decision-making during scaling. This feature offers comprehensive insights into Retool usage across all apps and instances, facilitating the identification of trends and the timing for necessary actions, especially as more teams within an organization adopt and develop Retool apps. Usage Analytics enhances the management of teams and applications by providing visibility into key metrics such as user activity, top apps, logins, and potential apps for deprecation. It is available for both self-hosted and cloud customers, with cloud users having it enabled by default in their admin settings. This update was part of a broader announcement at Developer Day, which also introduced new features such as the Retool Database, improved layout tools, enhanced app performance, and support for technologies like GPT-4 and Python.

Retool recently held its first Developer Day to introduce a range of new features and enhancements aimed at improving user experience and developer efficiency. The event highlighted the general availability of Retool Database, a PostgreSQL database hosted by Retool that transforms spreadsheet processes into scalable apps effortlessly. The updates include an improved table component for handling large datasets, Python support in Retool Workflows for better data analysis, and the integration of GPT-4 for automating data interactions. Users can also benefit from a Command Palette for quick actions, enhanced drag-and-drop functionality for easier component management, a streamlined component creation flow, and a new runtime that boosts performance significantly. Retool continues to engage with its community through a newly launched Discord server for developer interactions and feedback, encouraging users to explore these advancements by accessing their Retool accounts or signing up for a free plan.

Retool has launched Retool Database, a PostgreSQL database with a spreadsheet-like interface, now generally available to customers, aiming to simplify data management and application building. This new offering provides a scalable solution to replace traditional spreadsheets, addressing limitations such as data integrity and the lack of structured data management. Users benefit from a free 5GB data storage for one year, with the ability to easily create and manage databases using the intuitive Retool Database UI. The platform allows seamless integration with existing tools like Airtable and Google Sheets, supports standard SQL queries, and offers connection strings for external access. It is tightly integrated with the Retool platform, enabling the development of web and mobile apps, scheduling of cron jobs and ETL tasks, and the use of GPT-4 for automated notifications. The database supports multiple environments, facilitating safe schema changes and deployment, and is available for cloud and self-hosted customers, with the latter requiring an upgrade to version 2.113 or later.

Retool has announced the general availability of Retool Database, a PostgreSQL database with a spreadsheet interface, designed to streamline the process of building secure and scalable applications. This service allows users to upgrade from spreadsheet-based processes, providing 5GB of free data storage for one year, and features a user-friendly interface that simplifies schema creation and data management. Users can import data from Airtable and Google Sheets by uploading CSV files, and perform direct SQL queries to integrate with Retool applications or external databases. Retool Database supports multiple environments and offers integration with Retool Workflows for automated tasks, alongside compatibility with GPT-4 for natural language data queries. It is available to all cloud customers, with self-hosted customers needing to upgrade to v2.113 or later to access these features.

Retool has partnered with Google Cloud to integrate support for AlloyDB, a fully-managed PostgreSQL-compatible database service, allowing companies to build applications with full read and write access to AlloyDB databases. This collaboration enables quick connections between Retool apps and AlloyDB, facilitating the creation of internal tools, including those for fraud and anomaly detection, by leveraging SQL-based predictions through Vertex AI. Retool’s integration with AlloyDB is part of the Google Cloud Ready – AlloyDB initiative, ensuring deep functional and interoperability standards. The partnership has already enabled Retool customers to swiftly transition to AlloyDB, enhancing app stability and development speed. Additionally, Retool has announced the general availability of Retool Database, a PostgreSQL database with a spreadsheet interface, to all customers, offering a seamless and free setup experience.

In 1988, Alan Cooper prepared to present his software project, Tripod, to Bill Gates at Microsoft headquarters. Cooper, a pioneer in selling desktop applications independently from hardware, had been working on Tripod, a shell construction set for Windows, after being inspired by Microsoft's dynamic-link libraries (DLLs) introduced during a technical conference. Although impressed by Windows' capabilities, Cooper noted its rudimentary graphical user interface compared to Apple's Macintosh. This perceived gap in the market motivated him to build a more sophisticated Windows shell. His project aimed to enhance interprocess communication and dynamic module loading, addressing the limitations he identified in Microsoft's operating system.

Retool has introduced Python support in its Workflows, allowing users to integrate Python code blocks into their automation processes to enhance data ingestion, analysis, and visualization capabilities. This update includes preinstalled development tools like autocomplete, linting, and over 20 libraries such as numpy and pandas, facilitating a more seamless experience for developers accustomed to using these tools in integrated development environments or notebooks. Users can now choose between JavaScript and Python for code blocks, enabling them to select the best tool for specific tasks within their automation projects. This flexibility is particularly beneficial in tasks like data transformation and reporting, where Python's rich library ecosystem proves advantageous over JavaScript or SQL. The platform also supports creating portable APIs and visualizations using Python-based plotting libraries, enhancing collaboration between data analysts, operations teams, and engineers. Python code blocks are currently available for cloud customers and will soon be available on-premises.

Jason Wang, a software engineer at Census, outlines how the integration of Census and Retool can facilitate rapid access to customer data through the use of the Census Entity API. Census, a data activation platform, enables data teams to sync data from warehouses like Snowflake, BigQuery, and Redshift into SaaS applications without the need for custom pipelines, while Retool allows for the quick development of internal tools with minimal coding. The blog post provides a step-by-step guide for setting up real-time personalization in Retool apps using the Census Entity API, highlighting the ease of pulling customer data for ad hoc use cases and creating applications such as a Customer 360 dashboard. By enabling the Entity API and configuring Retool components, users can map, query, and display data efficiently, ultimately broadcasting Customer 360 data wherever needed.

Retool has launched the Smart Block in its Workflows platform, integrating GPT-4 to enhance automation capabilities by allowing users to interact with their data through natural language programming interfaces. Available in all Retool cloud instances, the Smart Block enables developers to automate tasks by combining JavaScript and visual logic blocks, connecting to any data source to perform actions based on input data. This innovation bridges the gap between AI models and user data, making it easier to apply advanced AI capabilities like those of GPT-4, which surpass GPT-3.5 in performance and can efficiently parse unstructured data. Users can leverage the Smart Block to automate processes such as filtering data, summarizing information, and executing code, with applications spanning from generating concise reports to creating custom systems for task management. The Smart Block is available for free during its beta phase, inviting developers to explore its potential applications and share feedback.

Developers often struggle with the complexity of regular expressions (RegEx), prompting the creation of a user-friendly RegEx generator that leverages OpenAI's GPT-3 and CodeMirror within Retool to simplify the process. This tool allows users to describe their desired RegEx functionality in plain language, which the AI then translates into JavaScript code. The app is structured into four main components: the OpenAI API resource call, a basic UI in Retool, custom components for the CodeMirror editor, and temporary variables to manage the app's state. The use of Retool's UI components, such as text areas and input fields, enables smooth user interaction and efficient management of prompts and test strings. By integrating with OpenAI and utilizing Retool's customizable features, the app not only generates RegEx patterns but also enhances developer productivity by minimizing the need for extensive coding.

Retool Mobile, recently released in public beta, aims to facilitate the rapid development and deployment of internal mobile apps for iOS and Android by using a cross-platform app built with React Native. The team encountered performance challenges during alpha trials, particularly due to the app's slow rendering on Android devices, which they addressed through three key optimizations: replacing heavy third-party component libraries with custom lightweight alternatives, minimizing unnecessary component re-rendering using Immutable.js and Redux, and eliminating code-splitting that impeded the UI thread. These improvements resulted in a 67% performance boost, underscoring the essential balance between fast initial development and subsequent performance refinements. The team is also pursuing further enhancements through projects like the new Fabric architecture to elevate the product's performance even more.

Retool Mobile, recently released in public beta, aims to simplify building and deploying internal mobile apps for iOS and Android, utilizing a cross-platform React Native app to render and update applications. The development team faced performance challenges due to the cross-platform architecture, initially using third-party component libraries, unnecessary re-rendering with Redux, and code-splitting inherited from their React codebase. To optimize performance, they replaced heavy third-party libraries with custom lightweight ones, minimized unnecessary re-rendering by refining state management, and removed code-splitting, leading to a 67% performance improvement. These efforts highlight the balance between rapid prototyping and production optimization, with further enhancements planned as they explore new architectures like React Native's Fabric.

Custom scripts and tools often present challenges for DevOps professionals in terms of scalability, sharing, and maintenance, especially as infrastructure complexity and team size increase. This blog post discusses using Retool to create custom admin panels that streamline DevOps processes, specifically managing Amazon EC2 virtual servers. By leveraging Retool's drag-and-drop interface and built-in integrations, users can simplify tasks such as launching, starting, stopping, and checking the status of EC2 instances. The post provides a step-by-step guide on setting up Retool to interface with the Amazon EC2 API, transforming data for better readability, and creating a user-friendly interface, complete with features like instance state color-coding and image selection from a listbox. The guide concludes by encouraging readers to explore Retool's capabilities for building custom admin panels, offering a JSON file to jumpstart their projects.

The tutorial, created in collaboration with Anshuman Bhardwaj, guides users through building an admin panel using Microsoft SQL Server and Retool to manage a database of shops. It highlights the advantages of using Microsoft SQL Server for financial and large-scale applications due to its ACID compliance and optimistic concurrency model but notes the security risks of direct database management. The solution proposed is to create an isolated admin layer to enhance security and user experience. The tutorial includes setting up a new SQL database with Azure, migrating sample data, and connecting the SQL Server to Retool. It details creating a Retool app with a user interface that allows admins to view, update, and delete store information, as well as add new stores using forms. Through this process, users learn how to implement queries to display store data, remove stores, update store information, and add new stores, ensuring secure and efficient database management.