November 2022 Summaries

The text discusses the decision between using a standard SQL database or a newer NoSQL document-based database for storing project data. Both options have trade-offs, with NoSQL being easier to get started with but more difficult when it comes to accessing and analyzing data later on. The author presents an example of tracking daily food intake, water consumption, exercise, and weight, and how this data can be stored in both SQL and NoSQL databases. They also demonstrate how to use PostgreSQL's JSON functions and operators to combine the ease-of-use of NoSQL with the power of SQL for better data analysis and presentation.

In this tutorial, we built a real-time chat application using Flutter and Supabase. The app includes user registration and login functionality, as well as a room list page where users can start new conversations or join existing ones. We also implemented proper authorization to prevent unauthorized access to private rooms. Here's an overview of the steps we took: 1. Set up the Flutter project and Supabase configuration. 2. Implement user registration and login functionality using Supabase authentication API. 3. Create a real-time chat room list page that displays all available public rooms. 4. Add authorization to prevent unauthorized access to private rooms using Row Level Security (RLS). 5. Implement 1 on 1 chat feature by adding user profiles and enabling users to start new conversations with other users. 6. Use bloc for state management solution. 7. Test the application thoroughly to ensure all features are working as expected. In future improvements, we could explore some cool feature enhancements such as implementing a list of online users instead of just displaying the newest created users, or adding push notifications when new messages arrive in a user's private conversations.

Next.js Conf 2022 announced the release of Next.js 13, which introduces Server Components and Suspense to streamline data fetching and caching in Next.js applications. This provides excellent DX improvements and aligns the Next framework even closer with the future of React. The article explores how to use these new async components to simplify fetching and caching data from Supabase, focusing on the app directory, Server Components, and Suspense.

In this tutorial, we'll create an Ionic Angular app that uses Supabase for authentication and database integration. We'll cover the following topics: 1. Setting up a new Ionic Angular project with Capacitor. 2. Creating a new Supabase project and installing the Supabase CLI. 3. Using the Supabase CLI to create tables, define policies, and configure authentication settings. 4. Integrating Supabase into our Ionic app by installing the @supabase/supabase-js package and configuring it with our Supabase API credentials. 5. Implementing user authentication in our Ionic app using email magic links provided by Supabase. 6. Protecting internal pages of our Ionic app by creating a guard that checks if a user is authenticated or not. 7. Handling the magic link on a mobile phone by defining a custom URL scheme for our app and updating the authentication settings in Supabase. 8. Adding some finishing touches to the messaging page with CSS styling. By following this tutorial, you'll learn how to create an Ionic Angular app that uses Supabase for authentication and database integration, making it easy to build secure and scalable mobile applications.

During October, the company shipped several updates, including new SDKs, quickstarts, and Functions tricks, in addition to announcing Launch Week 6. The supabase-js V2 and supabase-flutter v1 SDKs have been fully released, with improvements such as a revamped Next.js Quickstart guide and an example for trying out Next.js 13's data fetching capabilities. Additional updates include the release of Database Testing with pgTAP, Edge Functions support for GET requests, and various quick product updates. The company also showcased several successful apps made with Supabase, including Remote Water Feeder, Decile App, and Explainpaper. Launch Week 6 is scheduled to take place on December 12-16, and the company is hiring new team members.