July 2021 Summaries

PostgreSQL, a widely used database among developers, offers several GUI tools to enhance interaction with its data, catering to varying user needs and preferences. Popular options include pgAdmin, which is open-source and supports all PostgreSQL features, and Navicat, a paid tool with extensive features and support for multiple SQL dialects. DBeaver, like pgAdmin, is open-source and versatile, supporting different databases and operating systems. HeidiSQL is noted for its ease of use on Windows, while DataGrip, a JetBrains product, offers a powerful, customizable experience across platforms. OmniDB focuses on lightweight, no-frills Postgres management, whereas Beekeeper Studio emphasizes a smooth, privacy-focused user interface. TablePlus offers a sleek UI with strong security features, and QueryPie provides data access governance across various platforms. SQLGate is geared toward simplifying database management, although it comes at a higher price point. Finally, Retool is a web-based tool for building internal applications, connecting to multiple databases and APIs, though it lacks some advanced Postgres-specific features. The choice of GUI often depends on the user's specific requirements, such as team collaboration, cost considerations, and the need for cross-platform support.

Earnin provides a suite of financial services that allow customers to access their earnings before payday, helping them manage bills and reduce financial stress, particularly during the COVID-19 pandemic. To support these services, Paula Obler, a software engineer at Earnin, developed a new customer service tool using Retool to enhance the efficiency of customer support operations, particularly with the launch of the WeWin feature, which offers users a chance to win money as they save. The previous internal tools were outdated and inefficient, complicating workflows and slowing customer support response times. By using Retool, Paula's team was able to build a more streamlined and intuitive dashboard that consolidated customer data in one place, thereby improving the ease and speed of customer service interactions. This development not only simplified the onboarding process for new agents but also accelerated the development cycle for internal tools, allowing the team to launch new features more rapidly and effectively support Earnin's growing customer base.

Spreadsheets have long been a staple for managing and storing structured data due to their flexibility and accessibility, but they can be error-prone and limited when it comes to building interactive interfaces or handling complex tasks. Retool offers a solution by enabling users to quickly create user interfaces and internal tools on top of Google Sheets, transforming simple spreadsheets into powerful applications. This integration is particularly useful for tasks like automating personalized emails in sales, managing inventory in e-commerce, or developing custom CRMs without moving to entirely new systems. Retool's capability to pull and combine data from various sources enhances these applications, allowing for enriched data insights and streamlined workflows. The platform supports a range of use cases, including applicant tracking and financial modeling, by allowing users to maintain their existing Google Sheets as a backend while offering a more controlled and user-friendly frontend experience.

Segment, a company that helps businesses understand and leverage customer data, has developed a product line called Personas that enables developers and marketers to build user cohorts based on data from websites, apps, or SaaS platforms. However, as customers create increasingly complex audiences, Segment's support team faced difficulties in accessing and consolidating data needed to diagnose issues. To address this, product manager Alex Millet, alongside his team, implemented Retool to create a dashboard that integrates various data sources into a single timeline. This tool allows the support team to efficiently locate and resolve customer issues by providing a detailed view of user interactions, such as product views and email openings, as well as audience segmentations. As a result, the support team can respond more quickly and accurately to customer requests, enhancing their ability to support complex audience creation and improving the overall user experience with the Personas product.

SaltPay, a payments company focused on empowering small and medium-sized businesses, has streamlined its customer support processes by integrating a Retool app to replace their previously disjointed back-office systems. This integration allows customer relations agents to access all necessary merchant data through a centralized dashboard, improving their efficiency and responsiveness. By consolidating multiple support tools into one, SaltPay's tech team can concentrate on developing core merchant-facing products and APIs, while agents are empowered to provide better service with real-time data and fewer manual tasks. This strategic move has not only improved service delivery but also freed up resources to focus on scaling and enhancing SaltPay's product offerings.

Revv is a comprehensive document management system that simplifies the transition from traditional paper documents to digital formats by converting Word documents, Excel sheets, and PDFs. It integrates with tools like Retool to automate the document creation and management process by connecting multiple Systems of Records (SoRs) such as CRM and ERP systems. With Revv and Retool, users can streamline internal workflows, automate the generation of business documents like NDAs using legally vetted templates, and manage information efficiently by integrating with CRMs like Salesforce. The integration allows for seamless data flow, enabling users to create custom applications that pull data from CRMs to populate document templates and facilitate actions such as eSignatures. This setup not only speeds up processes but also minimizes errors and data loss. SaltPay, for instance, consolidated multiple back-office tasks into a single Retool application, improving their customer support operations by centralizing user data and workflows.

The provided text is a comprehensive tutorial on building a tool using Retool and Sync Inc to manage Stripe subscriptions, which involves searching and retrieving subscription data, viewing invoices, and canceling subscriptions. The process is detailed with steps for setting up test subscriptions in Stripe, generating a restricted API key, and configuring Sync Inc to replicate Stripe data to a Postgres database. The tutorial then guides users through creating a Retool app that integrates this data, builds a user interface with searchable tables, and displays subscription details. The tutorial also covers creating SQL queries and JavaScript functions to handle data retrieval and manipulation, as well as creating interactions within the app for functionalities such as viewing invoices and canceling subscriptions. The use of Retool and Sync Inc aims to simplify data handling by avoiding complex API calls and facilitating seamless interactions between app components and data sources.