July 2021 Summaries

Today, Supabase officially launches its Swag Store to provide high-quality swag items to users who make meaningful contributions to the platform. These contributions include creating content related to Supabase, finding and fixing bugs, answering questions on GitHub discussions or Discord, contributing to open source libraries, and more. The store is built using Shopify and offers limited edition designs with in-house production. Swag items are primarily intended as gifts for contributors, but users can also purchase them from the store. Due to international pandemic disruptions, shipping options may be limited, and swag availability will depend on production runs and inventory management.

Supabase has announced the release of Functions Hooks in Alpha for all new projects, as well as support for Postgres Functions and Triggers in their Dashboard. They are also working on a timeline for the rest of Supabase Functions. The company is taking a staged approach to releasing these features, with the first stage allowing developers to trigger external HTTP functions using Function Hooks. Future stages will include the ability to trigger Serverless functions on AWS and GCP, as well as their own Serverless Functions (Supabase Functions).

The first Supabase Hackathon has begun, running from July 30th to August 6th, 2021. Participants have seven days to create a new open-source project using Supabase. They can enter individually or as teams of up to five people. Submissions should include a link to the GitHub repository and a detailed README file. Prizes will be awarded in several categories, including Best Overall Project, Most Visually Pleasing, Most Technically Impressive, Most Fun/Interesting, and Best Meme. The judging panel includes notable industry figures such as @swyx and @themarcusbattle. All entries must be open-source and use Supabase in some capacity.

Supabase has announced the release of Postgres Functions and Triggers in their Dashboard, with plans to launch Supabase Functions in stages. The first stage includes giving developers the ability to trigger external HTTP functions using Database Webhooks (previously called "Function Hooks"). In the second stage, they will provide support for developers to trigger their own Serverless functions on AWS and GCP. Finally, in the third stage, they plan to release Supabase Functions themselves. The new features aim to make it easier for developers to build PostgreSQL Functions and manage PostgreSQL triggers.

Today we are officially launching the Supabase Swag Store.` Since we started gifting swag, we are constantly asked, "when will you launch a store?" We take our swag game seriously and want to offer high-quality swag to our users. Our primary goal with swag is gifting developers who make meaningful contributions to Supabase in various ways, including creating content, finding bugs, answering questions, and advocating for the project on social media. To celebrate this launch, we've built an eCommerce store using Shopify and are excited to offer limited-edition designs and small runs of our swag. However, due to shipping limitations and high demand, some items may be out of stock, and restocks will be prioritized based on user contributions to Supabase.

The first Supabase Hackathon is starting now, offering a 7-day opportunity for individuals or teams of up to 5 people to build an open-source project using Supabase. The hackathon's goal is to encourage creativity and innovation in building projects with Supabase. Participants can submit their projects by the deadline on Friday, August 6th, 2021, and will be eligible for prizes in categories such as Best Overall Project, Most Visually Pleasing, and Most Technically Impressive. The judging panel includes well-known figures from the tech industry, including @swyx, @themarcusbattle, and members of the Supabase Team, who will evaluate projects based on creativity, functionality, visual appeal, technical expertise, and fun factor. Participants can find resources and guides to help them get started with building their project on GitHub, and the Supabase Team will be actively participating in the hackathon, providing support and guidance through Discord channels.

Supabase, a platform for building mobile and web applications, has introduced a new "Reports" section to its Dashboard, providing users with one month of data on API requests across all core services. This includes metrics like CPU usage and memory usage, with more on the way. The company plans to expand to unlimited reports in the future, along with longer date range options, report templates, stacked charts, and private/public visibility configurations. Supabase also added a new project home page with weekly overviews of important metrics such as database storage, number of Auth users, and storage space.

Supabase is introducing a new set of metrics to its platform, allowing developers to build better products for their users. The new "Reports" section provides a one-month view of data across Supabase's core pillars: Database, Auth, and Storage, with customizable charts built using Recharts. Each project can have multiple reports, which will be expanded to unlimited reports in the near future. Additionally, Supabase is introducing a new project home page with weekly overviews of important metrics, such as database storage, auth users, and storage space. The platform also provides observability metrics for infrastructure anomalies and tools to diagnose and manage issues. To gather relevant metrics, Supabase uses a federated approach, running monitoring systems in each geographical region, which allows for sharding and reduced latency. The available sources and metrics include project statistics, detailed stats from pg_stat_statements, system level metrics like CPU, memory, and disk utilization, and interactive widgets to view-only reports.

Supabase, an open-source alternative to Firebase, has introduced Phone Auth for its Auth v2 service. This feature allows users to log in using their mobile devices with SMS-based one-time passwords (OTPs). Supabase supports Twilio as an SMS provider and will add more options soon. The company also plans to introduce multi-factor authentication (MFA) in the future. Additionally, Supabase has added two new OAuth providers: Twitch and Discord, bringing the total number of supported providers to ten.

Mobbin, a platform that helps creators search and view design patterns from well-known apps, migrated its user base of over 200,000 users from Firebase to Supabase for better authentication experience. The company initially used Firebase but faced issues with duplicate logins, data integrity, and increasing costs due to high API requests. Mobbin found Supabase as a solution covering all their needs, including superior performance, fairer pricing, and relational database support. The migration helped improve the end-user experience and reduced monthly spending without maintaining a custom backend.

Supabase Auth is a key component of the Supabase Stack, offering a flexible and extensible authentication system that allows developers to control access to their own database. The latest version introduces Phone Auth, which enables users to log in using their mobile phone with SMS-based OTPs, as well as passwordless SMS login options. This feature supports Twilio as an SMS provider and can be used in conjunction with other Supabase features, such as Storage. Additionally, the community has contributed OAuth providers, including Twitch and Discord, and new features like dynamic email generation via API endpoints are being added to make life easier for developers. The next major item on the list is Multi-Factor Authentication (MFA), which includes Time-Based One-Time Passwords (TOTP).

Supabase Storage has released its Beta version, introducing new features such as streaming media support and public buckets for hosting assets in web or mobile applications. It also added directory uploads, a policy editor for Postgres Row Level Security (RLS), and compatibility with local development environments without additional setup. The update also includes performance improvements for large buckets and API changes like the addition of upsert functionality. Supabase Storage is now being used by several production applications, and future plans include implementing a Content Delivery Network and basic transformation support for media files.

Indie developer Tyler Shukert, an expert in Firebase and Flutter, discovered Supabase and decided to use it for his latest app, Spot - a geolocation-based video sharing app with social networking features. He chose Supabase over Firebase due to its SQL support, relational schemas, and open-source nature. Tyler believes that Supabase, combined with Flutter, enables faster development of high-quality web and mobile applications at a low cost. Spot is now open source, allowing developers to use it as the basis for their next project.

Supabase has released Storage Beta, introducing new features such as streaming media support, public buckets, directory uploads, and an improved policy editor. The update also includes the ability to use Storage in local development without any additional setup. Furthermore, Supabase is planning a Content Delivery Network for faster downloads and basic transformation and optimization support for media files.

Supabase has updated its Postgres version to 13.3, introducing significant performance improvements and new features such as native UUID generation, a new JSONB datetime function, vacuuming indexes in parallel, incremental sortings, smaller btree indexes, and enhancements to extended statistics. The Supabase Postgres repo has also been updated from 0.15.0 to 13.3.0. Large System Extensions (LSE) have been enabled for ARM instances, which is expected to greatly enhance application performance through atomics and improve locking and synchronization performance across large systems. The new version of Supabase Postgres also includes enhanced security features such as fail2ban protection against brute force attacks on direct connections to Postgres.

Supabase, an open-source platform for Postgres and Hasura, has highlighted some of the key tools and community efforts that have contributed to its growth since its last Launch Week. These include PostgreSQL version 13.3, which is now used in every new Supabase project, and PostgREST version 8.0, which offers improved performance, reduced downtime, dynamic configuration, less admin burden, and better diagnostic information. Additionally, the Supabase Flutter/Dart (Beta release) has been released by the community, with fully-functional apps using Supabase Auth and Storage. The Supabase Discord server is also now available for users to interact with developers and other members of the community.

Epsilon3, a USA-based Y Combinator startup, is revolutionizing space operations by digitizing paper-based procedures in the industry using telemetry data. Their product is rapidly becoming the OS for space projects and complex operations. The team at Epsilon3 uses Supabase to help teams execute secure and reliable operations in an industry where project spend runs into the billions. They have successfully sent satellites into space and are about to use their software for an operational Rocket Launch. As a result, they are receiving enquiries from clients in robotics, logistics, and medical equipment sectors who need a structured and standardized way of running procedures and keeping audit trails.

Supabase, a popular open-source platform, has grown significantly since its last Launch Week. It relies heavily on open source tools like PostgreSQL and PostgREST. In this article, the author highlights some of these tools and community efforts that contribute to Supabase's success. The latest version of PostgreSQL (13.3) is now being used in every new Supabase project. Additionally, Supabase has made it easier for users to get started with Postgres without using Supabase by providing a Postgres image in the AWS marketplace and developing several extensions. Furthermore, the author discusses the latest version of PostgREST (8.0), which includes improved performance, reduced downtime, dynamic configuration, less admin burden, and better diagnostic information. The community has also made numerous enhancements and bug fixes for this new version. Lastly, the article mentions the release of Supabase Flutter/Dart libraries in Beta and encourages users to join the Supabase Community Discord for more interaction with developers.

PostgreSQL version 13.3 has been adopted as the default database version for new Supabase projects, thanks to Supabase's efforts in promoting open source tools and Postgres. Supabase provides various ways to use PostgreSQL without its platform, including a Postgres image on AWS Marketplace and Bundles. Additionally, Supabase is developing several extensions, such as supautils and pg_net. The latest version of PostgREST (8.0) offers improved performance, reduced downtime, dynamic configuration, and simplified administration, making it more enterprise-grade. This new version also includes features like reloadable schema cache, better diagnostic information, and simpler OpenAPI output. Supabase is now supporting a community-led Discord server to facilitate discussion and collaboration among developers.

From today, new Supabase projects will be on a version of Supabase Postgres that runs on Postgres 13.3, introducing significant performance improvements and some great new functionality, including native UUID generation, new JSONB datetime function, vacuuming indexes in parallel, incremental sorting, smaller btree indexes, and improvements to extended statistics, as well as support for Large System Extensions (LSE) on ARM instances, enabling enhanced application performance through atomics. Supabase Postgres can now be easily upgraded whenever a new major or minor version of PostgreSQL is released, and new extensions such as pgRouting and wal2json have been added, along with enhanced security features to combat brute force attacks. Additionally, four new configurations of PostgreSQL are being offered in the AWS and Digital Ocean Marketplaces, each catering to common use-cases, allowing users to choose the best fit for their needs.

Supabase is set to launch a series of new features and updates during Launch Week II, starting from July 26th. The event will feature daily releases, with the first day focusing on community developments. Other highlights include Storage v2, Auth v2, Dashboard v2, and additional surprises on the last day. Users can follow Supabase on Twitter for real-time updates using the hashtag #supalaunchweek.

Supabase is hosting Launch Week II: The SQL from July 26 to July 30, 2021, where they will launch new products and features each day. Expect updates on Storage v2, Auth v2, Dashboard v2, and more surprises on Friday. Follow their blog or Twitter for daily updates using the hashtag #supalaunchweek.

PostgreSQL manages permissions through roles, and to create these roles a database user needs the CREATEROLE privilege. However, granting this privilege can lead to potential security risks as it allows role modification or dropping of important roles. To address this issue, Supabase uses dedicated roles for each customer's backend services and employs PostgreSQL Hooks in their SupaUtils extension to protect these reserved roles. The SupaUtils extension sets up a hook that intercepts SQL statements like ALTER ROLE and DROP ROLE, checks if the role being altered or dropped is a reserved one, and aborts the operation if it is. This way, customers can manage roles as they do in on-premises databases while ensuring the protection of important roles.

The SupaUtils extension for PostgreSQL uses hooks to extend internal functionality, specifically the ProcessUtility_hook, which allows it to hook into utility statements such as alter role and drop role. The extension defines a configuration parameter "supautils.reserved_roles" that can be modified by editing the postgresql.conf file, allowing users to define their own reserved roles. When an alter or drop role statement is executed, the extension checks if the affected role is in the reserved roles list, reporting an error and aborting the statement execution if it is. The supautils hook also calls the previous hook defined by another extension, ensuring that any previously set hooks are run before its own logic.