Best of Supabase2024

  1. 1
    Article
    Avatar of supabaseSupabase·2y

    Snaplet is now open source

    Snaplet, a startup providing tools that help developers work with production-like data, has open-sourced its main products after closing down. The tools include Copycat for generating deterministic fake data, Snaplet Seed for creating realistic synthetic data from a database schema, and Snapshot for capturing and restoring database snapshots. The Snaplet team has joined Supabase, which will maintain the open-sourced tools. Peter Pistorius, Snaplet's founder, has returned to working on RedwoodJS.

  2. 2
    Article
    Avatar of supabaseSupabase·2y

    The Open Source Firebase Alternative

    FerretDB is an open source document database that adds MongoDB compatibility to other database backends like Postgres and SQLite. This post explains how to run FerretDB locally via Docker, test it with mongosh, and deploy it on Fly.io for production.

  3. 3
    Article
    Avatar of supabaseSupabase·2y

    postgres.new: In-browser Postgres with an AI interface

    Introducing postgres.new, an in-browser Postgres sandbox with AI assistance. It allows the creation and management of Postgres databases directly in the browser using PGlite, a WASM version of Postgres. Key features include drag-and-drop CSV import, report generation, chart creation, and database diagram construction. The platform leverages a large language model for autonomous database operations, and it supports semantic search with pgvector. Future enhancements include deploying databases to S3 and supporting more file types.

  4. 4
    Article
    Avatar of supabaseSupabase·2y

    Supabase + Vercel Partnership

    Vercel has launched official First-Party Integrations, including Supabase, making it easier to manage Postgres databases directly from the Vercel dashboard. This integration supports Vercel Templates, unified billing, and offers dedicated Postgres instances, modular building blocks like AI and Auth, low latency with read replicas, and secure, scalable solutions. It's currently in Public Alpha as of August 28, 2024.

  5. 5
    Article
    Avatar of supabaseSupabase·2y

    Building offline-first mobile apps with Supabase, Flutter and Brick

    Building offline-first mobile apps improves user experience by ensuring app usability in areas with poor connectivity. Using Supabase and Brick with Flutter allows data to be cached locally, minimizing round trip times and enabling apps to function smoothly offline. Brick manages local and remote state synchronization, providing code generation for serialization/deserialization and handling migrations automatically.

  6. 6
    Article
    Avatar of supabaseSupabase·2y

    Building an Uber Clone with Flutter and Supabase

    This tutorial guides you through building an Uber-like app using Flutter and Supabase, focusing on real-time location tracking using the PostGIS extension. The steps include setting up dependencies, creating and managing databases, and implementing real-time tracking for a consumer-facing app. The guide demonstrates using Supabase Edge Functions to handle routes and real-time updates, and provides a foundation for further development of features like payments and driver ratings.

  7. 7
    Article
    Avatar of supabaseSupabase·2y

    Postgres Realtime location sharing with MapLibre

    Learn how to build a Telegram Bot to capture live location data and use a Supabase Edge Function to insert it into a Postgres database. The tutorial covers using Supabase Realtime to broadcast database changes and integrating MapLibre GL JS in React to visualize the live data on a map. Key topics include creating Edge Functions, using RPC for database operations, and setting up Realtime subscriptions in React.

  8. 8
    Article
    Avatar of supabaseSupabase·2y

    Self-host Maps with Protomaps and Supabase Storage

    Learn how to self-host maps using Protomaps and Supabase Storage. This tutorial guides you through extracting an area into a PMTiles file, uploading it to Supabase Storage, rendering it on a web page using MapLibre, and using Supabase Edge Functions to restrict file access. This setup allows for a customized and secure map hosting solution.

  9. 9
    Article
    Avatar of supabaseSupabase·2y

    In-Browser Semantic AI Search with PGlite and Transformers.js

    The post introduces a method for building an in-browser semantic search experience using PGlite, pgvector, and Transformers.js. This setup could benefit eCommerce sites by quickly surfacing relevant products without server roundtrips. It includes instructions for setting up the database schema and code examples for a React application, enabling local storage and retrieval of text and embeddings using IndexedDB.

  10. 10
    Article
    Avatar of supabaseSupabase·2y

    Local-first Realtime Apps with Expo and Legend-State

    Legend-State is a high-performance state and sync library designed to simplify and accelerate the development of local-first mobile and web applications. It integrates seamlessly with Expo, React Native, and Supabase for robust offline functionality and real-time data synchronization. The setup involves creating a new Expo app, configuring necessary dependencies, setting up Supabase for data management, and using Legend-State for efficient state management and data persistence.

  11. 11
    Article
    Avatar of supabaseSupabase·2y

    Using React Query with Next.js App Router and Supabase Cache Helpers

    Learn how to use React Query with Next.js App Router and Supabase Cache Helpers. The article provides step-by-step instructions for installing dependencies, creating a React Query client, generating TypeScript types, creating Supabase clients, automating query key management, writing reusable queries, and fetching data server-side and client-side. The post concludes by discussing the benefits and use cases of using React Query with Server Components.

  12. 12
    Article
    Avatar of supabaseSupabase·2y

    Official Supabase extension for VS Code and GitHub Copilot

    A new GitHub Copilot extension for VS Code, created in collaboration with Anas Araid, enhances the development experience with Supabase. Key features include a Chat Participant for GitHub Copilot to help with Supabase queries, guided database migrations, and tools to inspect tables, views, and functions. Users need the Supabase CLI installed and local project setup. Future updates will integrate the Supabase Management API.