July 2022 Summaries

In this post, we explored four different ways to implement a Postgres-based solution for tracking how many people have seen a particular piece of content. We used the following approaches: 1. simple-counter: A simple counter that increments every time someone sees a post. 2. simple-hstore: Using an HStore field to store the number of times a post has been seen. 3. assoc-table: Storing each view as a row in a table, and querying for the count of rows. 4. hll: Using HyperLogLog to count distinct entries (views). We found that while simple-counter was the fastest solution on average, it had the highest 99.999%ile latency. The HLL approach provided a good balance between performance and accuracy, with an average latency of 2.16ms and a 99.999%ile latency of 27ms. We also discussed some other potential solutions, such as incremental view maintenance powered by pg_ivm and doing graph computations with AGE. While these solutions were not explored in depth, they could be worth considering for future implementations.

We've been working on improving our Auth experience for developers using Supabase, specifically addressing server-side rendering (SSR) environments. Our Auth Helpers libraries now support SvelteKit, with a simplified interface to facilitate seamless transitions between frameworks. We've also revamped the library's name and structure, moving into a monorepo to publish packages individually and improve performance. To help developers transition, we've provided a migration guide and examples, and invite contributors to join our community by creating pull requests or reporting bugs. Additionally, we're working on Remix Auth Helpers and encourage interested individuals to follow their development on GitHub or YouTube.

In June, Supabase made several updates and announcements. They revamped their Auth Helpers for Next.js, separating them into individual packages. Additionally, they introduced unlimited free projects with the ability to pause and restore projects on demand. Users can now create a project from the Supabase CLI, and realtime functionality has been added to table editors. Upcoming features include multiplayer support, enhanced PostgreSQL error handling, and more. They also launched weekly live streams called "Supabase Happy Hour" every Thursday at 17:00 PT | 20:00 ET on YouTube or Twitch. Community highlights from June included various projects built with Supabase, tutorials, and tips for using the platform. Singapore CityJS will feature talks by Supabase community members and a live coding workshop. They are also hiring and have reached 50k stars on GitHub.