はてなブックマーク

AI Prompts Prompts for working with Supabase using AI-powered IDE tools We've curated a selection of prompts to help you work with Supabase using your favorite AI-powered IDE tools, such as Cursor or GitHub Copilot. How to use# Copy the prompt to a file in your repo. Use the "include file" feature from your AI tool to include the prompt when chatting with your AI assistant. For example, in Cursor,

Production ChecklistAfter developing your project and deciding it's Production Ready, you should run through this checklist to ensure that your project: is secure won't falter under the expected load remains available whilst in production Security# Ensure RLS is enabled Tables that do not have RLS enabled with reasonable policies allow any client to access and modify their data. This is unlikely t

Introducing database.build (formerly postgres.new), the in-browser Postgres sandbox with AI assistance. With database.build, you can instantly spin up an unlimited number of Postgres databases that run directly in your browser (and soon, deploy them to S3). Each database is paired with a large language model (LLM) which opens the door to some interesting use cases: Drag-and-drop CSV import (genera

Supabase Storage is now officially an S3-Compatible Storage Provider. This is one of the most-requested features and is available today in public alpha. Resumable Uploads are also transitioning from Beta to Generally Available. The Supabase Storage Engine is fully open source and is one of the few storage solutions that offer 3 interoperable protocols to manage your files: Standard uploads: simple

Fly Postgres has been deprecated. See deprecation announcement for more details. We're launching Fly Postgres, a managed Postgres offering by Supabase and Fly.io. Fly Postgres databases launch on Fly.io's edge computing platform from any of their 37+ locations. You get everything you expect from a Supabase managed database: a full-featured Postgres database with over 40+ extensions pgvector suppor

One of the most widely-discussed shortcomings of Postgres is it's connection system. Every Postgres connection has a reasonably high memory footprint, and determining the maximum number of connections your database can handle is a bit of an art. A common solution is connection pooling. Supabase currently offers pgbouncer which is single-threaded, making it difficult to scale. We've seen some novel

One of our goals at Supabase is to make Postgres development delightful. To do this, we need to simplify the experience between our CLI, your code editor, and the remote Postgres database powering your applications. We received feedback recently about our local development experience, encouraging us to improve. This iteration introduces many new features to address that feedback. Let’s jump into a

There’s been a major U-turn in people’s attitudes towards remote this year. In 2020-2021 we had the ‘Remote Revelation’ where everyone and their dog realized they can do their job perfectly well from the comfort of their own home (oftentimes in the company of said dog). Now in 2023, there’s been whiplash back to the office with larger companies fighting especially hard to convince their employees

One of the challenges that ChatGPT faces is being able to answer questions from a private dataset. We can solve this with “retrieval plugins”, which allow ChatGPT to access information from a database. Supabase recently contributed to the OpenAI repo with a Postgres and a Supabase implementation to help developers build plugins using pgvector. Let’s dig into the specifics of Retrieval plugins, the

🆕✨ Edge Functions now natively supports npm modules and Node built-in APIs. Learn more Today we’re open-sourcing Supabase Edge Runtime for self-hosting Deno Edge Functions. Edge Runtime is MIT licensed, written in Rust, and based on the latest Deno Runtime (1.32+). If you’ve been using the Supabase CLI to serve functions then you’re already one of our Beta testers (thanks!). Host your Edge Functi

Released on the Supabase platform today, pg_jsonschema is a Postgres extension which adds JSON Schema validation support for json and jsonb data types. The use-case for JSON validation# Despite Supabase being an SQL shop, even our most zealous relational data model advocates (begrudgingly) recognize some advantages to the document data model. Mainly, if some complex data will always be consumed to

The auth-helpers are now deprecated. Use @supabase/ssr to set up Auth for your Next.js app. See the Next.js Server-Side Auth guide to learn how.

A new PostgreSQL extension is now available in Supabase: pgvector, an open-source vector similarity search. The exponential progress of AI functionality over the past year has inspired many new real world applications. One specific challenge has been the ability to store and query embeddings at scale. In this post we'll explain what embeddings are, why we might want to use them, and how we can sto

Today we're open-sourcing an EXPERIMENTAL extension for CRDTs, pg_crdt. The GitHub repo is here. There are instructions for running it locally in the README. When we released the new multiplayer features for our Realtime engine, it took 30 minutes for someone to ask if we'd add CRDT support. Anyone from Supabase here, do you have any plans to build in support for CRDT toolkits such as Yjs or AutoM

And open a browser at localhost:3000. Features# Our demo version has a few neat features! Postgres 14.5, psql, pg_dump, etc. Save & restore state to/from a file. Save & restore Postgres state to/from the browser storage (IndexedDB). Quick start from a state file or fully reboot the emulator. Memory configuration options from 128MB to 1024MB. Adjust the font size for the terminal. Upload files to t

🆕✨ Edge Functions now natively supports npm modules and Node built-in APIs. Learn more Today we're launching one of our most requested and highly-anticipated features — Edge Functions. Edge Functions let you execute Typescript code close to your users, no matter where they're located. Edge Functions are executed on the secure-by-default Deno runtime, and deployed around the world in seconds using

🆕 pg_graphql has undergone significant enhancements since this announcement. Here is what is new: pg_graphql v1.0 New Features in pg_graphql v1.2 GraphQL support is now in general availability on the Supabase platform via our open source PostgreSQL extension, pg_graphql. pg_graphql enables you to query existing PostgreSQL databases using GraphQL, either from within SQL or over HTTP: From SQL:

Data auditing is a system that tracks changes to tables' contents over time. PostgreSQL has a robust set of features which we can leverage to create a generic auditing solution in 150 lines of SQL. Auditing is particularly useful for historical analysis. To demonstrate, imagine you have a users table that tracks when a user is online. You might add a status column which can have one of two values:

GraphQL support is in development for PostgreSQL + Supabase.

UI Blocks for Supabase ProjectsA collection of React components and blocks built on the shadcn/ui library that connect your front-end to your Supabase back-end via a single command.Get Started

Build in a weekendScale to millionsSupabase is the Postgres development platform. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, Storage, and Vector embeddings.