August 2022 Summaries

Many databases originate from spreadsheets, and migrating data from Google Sheets to a relational database like PostgreSQL involves several important considerations, including data modeling, handling missing data, and setting up user permissions. Unlike Google Sheets, relational databases require a structured data model with consistent data types, primary keys, and defined relationships between tables. The migration can be executed through various methods, such as exporting data to a CSV file and using the COPY command in PostgreSQL, or utilizing GUI tools like pgAdmin for a more user-friendly experience. Additionally, third-party services like Retool offer alternative solutions for data import and management, providing features like a spreadsheet-like UI and hosted database options. Each method has its own complexities and is chosen based on the specific needs and scale of the data migration project.

React Native for Web is an extension of React Native that allows developers to use React's components and APIs to create applications for web, Android, and iOS platforms from a single codebase. It translates React Native APIs like View into their HTML5 counterparts, facilitating the development of web applications that closely mirror their native counterparts. While popular on GitHub and NPM, React Native for Web has limitations such as restricted web API support, missing core components, styling issues, and compatibility challenges with certain libraries. It is best suited for projects where the web and native apps have similar functionalities. Alternatives include using Solito for navigation or creating separate libraries for web and mobile. Expo is a recommended toolchain for getting started with React Native for Web, with options for new projects or migrating existing ones. Despite its limitations, React Native for Web remains a popular choice for developers seeking to unify their app development process across multiple platforms.

Cameron Archer, Content Marketing Lead at Tinybird, shares his experience of building internal analytics without using Google Analytics, focusing on privacy and using Tinybird and Retool. Upon joining Tinybird, Archer was informed that the company doesn't use Google Analytics due to privacy concerns and GDPR rulings, opting instead for first-party data collection through Tinybird's Events API and visualization through Retool. He describes the process of replicating Google Analytics views, starting with creating a session-based data structure in Tinybird and then developing a traffic widget that aggregates web events data using SQL-based queries. Archer highlights how Tinybird's capabilities, such as materialized views and parameterized queries, facilitate efficient data handling, while Retool offers easy data visualization for internal analytics. The post details the technical steps, including setting up Retool resource queries and utilizing temporary states to create interactive widgets, aiming to replicate familiar Google Analytics functionalities while maintaining data privacy.

Retool Mobile is a new platform launched in private beta that simplifies the development of production-grade native mobile apps for teams, allowing developers to build and deploy apps quickly without needing extensive mobile expertise. By providing over 15 pre-built React Native components and enabling customization through familiar languages like JavaScript and SQL, Retool Mobile reduces the friction typically associated with mobile app development. This platform supports cross-platform deployment to iOS, Android, and as a Progressive Web App (PWA) with a single click, offering features like over-the-air updates to bypass lengthy app store approvals. It also includes functionalities such as barcode scanners, multi-screen navigation, and theming, with future updates promising geolocation, offline modes, and push notifications. Retool Mobile aims to provide deskless workers, such as those in warehouses and field operations, with efficient mobile software tools to improve their workflows, as demonstrated by early users like The Modern Milkman, who quickly deploy apps across platforms.

Retool has launched a new PostgreSQL database solution integrated into their platform, designed to simplify database management for app developers by providing a user-friendly spreadsheet interface for schema updates and data management. Currently in private beta, this Retool-hosted database offers an easy transition from spreadsheets to a robust SQL environment, allowing teams to build apps quickly without the complexities of setting up traditional databases. Early users have successfully transitioned from tools like Google Sheets, benefiting from streamlined data handling and scalable app development. The database is free to use during the beta phase, with a generous storage tier, and Retool invites interested users to join their waitlist. Additionally, Retool has announced a successful Series C2 fundraising round, securing $45 million at a $3.2 billion valuation.