はてなブックマーク

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 postgres.new, the in-browser Postgres sandbox with AI assistance.

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

Supavisor is a scalable, cloud-native Postgres connection pooler. We connected a million clients to it to see how it performs.

New features to streamline the interaction between CLI, code editors, and remote databases.

Supabase recently contributed to the OpenAI Retrieval Plugin repo with a Postgres and a Supabase implementation to help developers build ChatGPT plugins using pgvector.

🆕✨ 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

An example of how to build an AI-powered search engine using OpenAI's embeddings and PostgreSQL.

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.