Supabase LogoSupabase Logo
  • Pricing

  • Docs

  • Blog

88.5KSign inStart your project

Blog/Postgres

    OrioleDB Patent: now freely available to the Postgres community thumbnail

    9 Sep 2025

    •

    3 minute read

    OrioleDB Patent: now freely available to the Postgres community

    Supabase is explicitly making available a non-exclusive license of the OrioleDB patent to all OrioleDB users in accordance with the OrioleDB license.

    Build a Personalized AI Assistant with Postgres thumbnail

    25 Jun 2025

    •

    10 minute read

    Build a Personalized AI Assistant with Postgres

    Learn how to build a Supabase powered AI assistant that combines PostgreSQL with scheduling and external tools for long-term memory, structured data management and autonomous actions.

    Announcing Multigres: Vitess for Postgres thumbnail

    10 Jun 2025

    •

    4 minute read

    Announcing Multigres: Vitess for Postgres

    Today we are welcoming Sugu, the co-creator of Vitess, to the Supabase team. He is joining Supabase to build Multigres: Vitess for Postgres.

    Building on open table formats thumbnail

    29 May 2025

    •

    8 minute read

    Building on open table formats

    Open table formats like Apache Iceberg, Delta Lake, and Apache Hudi are transforming how developers manage large-scale data on object storage systems.

    Open Data Standards: Postgres, OTel, and Iceberg thumbnail

    26 May 2025

    •

    7 minute read

    Open Data Standards: Postgres, OTel, and Iceberg

    Replace custom CRUD endpoints, reduce infrastructure complexity, and accelerate product delivery.

    Simplifying back-end complexity with Supabase Data APIs thumbnail

    17 May 2025

    •

    8 minute read

    Simplifying back-end complexity with Supabase Data APIs

    Replace custom CRUD endpoints, reduce infrastructure complexity, and accelerate product delivery.

    PostgreSQL Event Triggers without superuser access thumbnail

    8 May 2025

    •

    4 minute read

    PostgreSQL Event Triggers without superuser access

    Using Postgres Hooks to allow regular users to create event triggers

    Automatic Embeddings in Postgres thumbnail

    1 Apr 2025

    •

    7 minute read

    Automatic Embeddings in Postgres

    Automatic embeddings move the vector generation step into Postgres

    Postgres Language Server: Initial Release thumbnail

    29 Mar 2025

    •

    17 minute read

    Postgres Language Server: Initial Release

    Language Server Protocol and collection of language tools for Postgres

    Migrating from Fauna to Supabase thumbnail

    21 Mar 2025

    •

    8 minute read

    Migrating from Fauna to Supabase

    A guide to migrating from Fauna to Supabase.

    Migrating from the MongoDB Data API to Supabase thumbnail

    20 Mar 2025

    •

    6 minute read

    Migrating from the MongoDB Data API to Supabase

    A guide to migrating from the MongoDB Data API to Supabase.

    Dedicated Poolers thumbnail

    7 Mar 2025

    •

    3 minute read

    Dedicated Poolers

    A dedicated pgbouncer instance that's co-located with your database for maximum performance and reliability.

    Postgres as a Graph Database: (Ab)using pgRouting thumbnail

    25 Feb 2025

    •

    13 minute read

    Postgres as a Graph Database: (Ab)using pgRouting

    Learn how to use pgRouting as a lightweight graph database solution in Postgres.

    Running Durable Workflows in Postgres using DBOS thumbnail

    10 Dec 2024

    •

    6 minute read

    Running Durable Workflows in Postgres using DBOS

    Technical deep dive into the new DBOS integration for Supabase

    database.build v2: Bring-your-own-LLM thumbnail

    6 Dec 2024

    •

    16 minute read

    database.build v2: Bring-your-own-LLM

    Use any OpenAI API compatible LLMs in database.build

    Restore to a New Project thumbnail

    6 Dec 2024

    •

    3 minute read

    Restore to a New Project

    Effortlessly Clone Data into a New Supabase Project

    Supabase Queues thumbnail

    5 Dec 2024

    •

    7 minute read

    Supabase Queues

    Durable Message Queues with Guaranteed Delivery in Postgres

    High Performance Disk thumbnail

    5 Dec 2024

    •

    4 minute read

    High Performance Disk

    Store up to 60 TB of data with 100x improved durability and 5x more IOPS

    Supabase Cron thumbnail

    4 Dec 2024

    •

    4 minute read

    Supabase Cron

    Schedule Recurring Jobs in Postgres

    Supabase AI Assistant v2 thumbnail

    2 Dec 2024

    •

    4 minute read

    Supabase AI Assistant v2

    An evolution of how we approach AI within the Supabase dashboard

    ClickHouse Partnership, improved Postgres Replication, and Disk Management thumbnail

    30 Oct 2024

    •

    6 minute read

    ClickHouse Partnership, improved Postgres Replication, and Disk Management

    Improving the developer experience between Postgres and ClickHouse.

    Live Share: Connect to in-browser PGlite with any Postgres client thumbnail

    10 Oct 2024

    •

    8 minute read

    Live Share: Connect to in-browser PGlite with any Postgres client

    Connect any Postgres client to your postgres.new databases.

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

    12 Aug 2024

    •

    15 minute read

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

    Introducing postgres.new, the in-browser Postgres sandbox with AI assistance.

    Simplifying Time-Based Queries with Range Columns thumbnail

    11 Jul 2024

    •

    6 minute read

    Simplifying Time-Based Queries with Range Columns

    Learn how to use range columns in Postgres to simplify time-based queries and add constraints to prevent overlaps.

    Postgres Realtime location sharing with MapLibre thumbnail

    4 Jul 2024

    •

    8 minute read

    Postgres Realtime location sharing with MapLibre

    Use Supabase Realtime to draw live location data onto the map with MapLibre GL JS.

    Generate Vector Tiles with PostGIS thumbnail

    26 Jun 2024

    •

    12 minute read

    Generate Vector Tiles with PostGIS

    Use PostGIS to programmatically generate Mapbox Vector Tiles and render them with MapLibre GL.

    Implementing semantic image search with Amazon Titan and Supabase Vector thumbnail

    26 Mar 2024

    •

    9 minute read

    Implementing semantic image search with Amazon Titan and Supabase Vector

    Implementing semantic image search with Amazon Titan and Supabase Vector in Python.

    Build a content recommendation app with Flutter and OpenAI thumbnail

    26 Feb 2024

    •

    19 minute read

    Build a content recommendation app with Flutter and OpenAI

    Build a movie-viewing app that recommends another movie based on what the user is viewing using OpenAI, Flutter and Supabase.

    Matryoshka embeddings: faster OpenAI vector search using Adaptive Retrieval thumbnail

    13 Feb 2024

    •

    22 minute read

    Matryoshka embeddings: faster OpenAI vector search using Adaptive Retrieval

    Use Adaptive Retrieval to improve query performance with OpenAI's new embedding models

    NoSQL Postgres: Add MongoDB compatibility to your Supabase projects with FerretDB thumbnail

    31 Jan 2024

    •

    6 minute read

    NoSQL Postgres: Add MongoDB compatibility to your Supabase projects with FerretDB

    NoSQL Postgres: Add MongoDB compatibility to your Supabase projects with FerretDB

    pgvector 0.6.0: 30x faster with parallel index builds thumbnail

    30 Jan 2024

    •

    14 minute read

    pgvector 0.6.0: 30x faster with parallel index builds

    pgvector 0.6.0 brings a significant improvement: parallel index builds for HNSW. Building an HNSW index is now up to 30x faster for unlogged tables.

    Getting started with Ruby on Rails and Postgres on Supabase thumbnail

    29 Jan 2024

    •

    5 minute read

    Getting started with Ruby on Rails and Postgres on Supabase

    Learn how to create a new Rails app and connect it to a Supabase Postgres database.

    Getting started with Laravel and Postgres thumbnail

    22 Jan 2024

    •

    4 minute read

    Getting started with Laravel and Postgres

    Learn how to create a new Laravel PHP app and connect it to a Supabase PostgreSQL database.

    Top 10 Launches of LWX thumbnail

    19 Dec 2023

    •

    6 minute read

    Top 10 Launches of LWX

    Our CEO takes a look at his favorite ships from LWX

    Introducing Read Replicas thumbnail

    15 Dec 2023

    •

    8 minute read

    Introducing Read Replicas

    We are launching support for Postgres Read Replicas

    Fly Postgres, managed by Supabase thumbnail

    15 Dec 2023

    •

    6 minute read

    Fly Postgres, managed by Supabase

    A managed Postgres offering developed by Supabase and Fly.io

    Supabase Branching thumbnail

    13 Dec 2023

    •

    8 minute read

    Supabase Branching

    A Postgres database for every Pull Request.

    Supavisor 1.0: a scalable connection pooler for Postgres thumbnail

    13 Dec 2023

    •

    7 minute read

    Supavisor 1.0: a scalable connection pooler for Postgres

    Supavisor is now used across all projects, providing a scalable and cloud-native Postgres connection pooler that can handle millions of connections

    Postgres Language Server: implementing the Parser thumbnail

    8 Dec 2023

    •

    26 minute read

    Postgres Language Server: implementing the Parser

    A detailed analysis of our iterations to implement a Parser for Postgres

    pgvector vs Pinecone: cost and performance thumbnail

    10 Oct 2023

    •

    9 minute read

    pgvector vs Pinecone: cost and performance

    Direct performance comparison between pgvector and Pinecone.

    Dynamic Table Partitioning in Postgres thumbnail

    3 Oct 2023

    •

    25 minute read

    Dynamic Table Partitioning in Postgres

    Learn how to scale large postgres tables in place and increase query performance.

    pgvector v0.5.0: Faster semantic search with HNSW indexes thumbnail

    6 Sep 2023

    •

    11 minute read

    pgvector v0.5.0: Faster semantic search with HNSW indexes

    Increase performance in pgvector using HNSW indexes

    Supavisor: Scaling Postgres to 1 Million Connections thumbnail

    11 Aug 2023

    •

    14 minute read

    Supavisor: Scaling Postgres to 1 Million Connections

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

    pgvector: Fewer dimensions are better thumbnail

    3 Aug 2023

    •

    11 minute read

    pgvector: Fewer dimensions are better

    Increase performance in pgvector by using embedding vectors with fewer dimensions

    pgvector 0.4.0 performance thumbnail

    13 Jul 2023

    •

    13 minute read

    pgvector 0.4.0 performance

    There's been a lot of talk about pgvector performance lately, so we took some datasets and pushed pgvector to the limits to find out its strengths and limitations.

    What is new in PostgREST v11.1? thumbnail

    12 Jul 2023

    •

    6 minute read

    What is new in PostgREST v11.1?

    Impersonated Role Settings, Configurable Isolation Level, improved Bulk Insert, and more

    Supabase Vecs: a vector client for Postgres thumbnail

    29 May 2023

    •

    6 minute read

    Supabase Vecs: a vector client for Postgres

    Introducing Supabase Vecs, a PostgreSQL vector client

    ChatGPT plugins now support Postgres & Supabase thumbnail

    25 May 2023

    •

    10 minute read

    ChatGPT plugins now support Postgres & Supabase

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

    Next steps for Postgres pluggable storage thumbnail

    1 May 2023

    •

    4 minute read

    Next steps for Postgres pluggable storage

    Exploring history of Postgres pluggable storage and the possibility of landing it in the Postgres core.

    What's New in pg_graphql v1.2 thumbnail

    21 Apr 2023

    •

    6 minute read

    What's New in pg_graphql v1.2

    New Features in the v1.2 release of pg_graphql

    dbdev: PostgreSQL Package Manager thumbnail

    14 Apr 2023

    •

    11 minute read

    dbdev: PostgreSQL Package Manager

    We're publicly previewing dbdev, a PostgreSQL package manager.

    Trusted Language Extensions for Postgres thumbnail

    14 Apr 2023

    •

    6 minute read

    Trusted Language Extensions for Postgres

    We're collaborating with AWS to bring Trusted Language Extensions to Postgres.

    Type Constraints in 65 lines of SQL thumbnail

    17 Feb 2023

    •

    10 minute read

    Type Constraints in 65 lines of SQL

    Creating validated data types in Postgres

    Storing OpenAI embeddings in Postgres with pgvector thumbnail

    6 Feb 2023

    •

    15 minute read

    Storing OpenAI embeddings in Postgres with pgvector

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

    What's new in Postgres 15? thumbnail

    16 Dec 2022

    •

    5 minute read

    What's new in Postgres 15?

    Describes the release of Postgres 15, new features and reasons to use it

    pg_graphql v1.0 thumbnail

    16 Dec 2022

    •

    6 minute read

    pg_graphql v1.0

    Announcing the v1.0 release of pg_graphql

    Point in Time Recovery is now available for Pro projects thumbnail

    16 Dec 2022

    •

    3 minute read

    Point in Time Recovery is now available for Pro projects

    We're making PITR available for more projects, with a new Dashboard UI that makes it simple to use.

    PostgREST 11 pre-release thumbnail

    16 Dec 2022

    •

    5 minute read

    PostgREST 11 pre-release

    Describes new features of PostgREST 11 pre-release

    Supabase Vault is now in Beta thumbnail

    16 Dec 2022

    •

    8 minute read

    Supabase Vault is now in Beta

    A Postgres extension to store encrypted secrets and encrypt data.

    pg_crdt - an experimental CRDT extension for Postgres thumbnail

    10 Dec 2022

    •

    9 minute read

    pg_crdt - an experimental CRDT extension for Postgres

    Embedding Yjs and Automerge into Postgres for collaborative applications.

    SQL or NoSQL? Why not use both (with PostgreSQL)? thumbnail

    24 Nov 2022

    •

    18 minute read

    SQL or NoSQL? Why not use both (with PostgreSQL)?

    How to turn Postgres into an easy-to-use NoSQL database that retains all the power of SQL

    What is PostgreSQL commitfest and how to contribute thumbnail

    27 Oct 2022

    •

    11 minute read

    What is PostgreSQL commitfest and how to contribute

    A time-tested method for contributing to the core Postgres code

    Postgres Full Text Search vs the rest thumbnail

    14 Oct 2022

    •

    14 minute read

    Postgres Full Text Search vs the rest

    Comparing one of the most popular Postgres features against alternatives

    Postgres WASM by Snaplet and Supabase thumbnail

    3 Oct 2022

    •

    11 minute read

    Postgres WASM by Snaplet and Supabase

    We're open sourcing postgres-wasm, a PostgresQL server that runs inside a browser, with our friends at Snaplet.

    Choosing a Postgres Primary Key thumbnail

    8 Sep 2022

    •

    18 minute read

    Choosing a Postgres Primary Key

    Turns out the question of which identifier to use as a Primary Key is complicated -- we're going to dive into some of the complexity and inherent trade-offs, and figure things out

    PostgREST v10: EXPLAIN and Improved Relationship Detection thumbnail

    19 Aug 2022

    •

    8 minute read

    PostgREST v10: EXPLAIN and Improved Relationship Detection

    Today, PostgREST 10 was released. Let's take a look at some of the new features that go hand in hand with supabase-js v2.

    Implementing "seen by" functionality with Postgres thumbnail

    18 Jul 2022

    •

    33 minute read

    Implementing "seen by" functionality with Postgres

    Different approaches for tracking visitor counts with PostgreSQL.

    Postgres Auditing in 150 lines of SQL thumbnail

    8 Mar 2022

    •

    13 minute read

    Postgres Auditing in 150 lines of SQL

    PostgreSQL has a robust set of features which we can leverage to create a generic auditing solution in 150 lines of SQL.

    Protecting reserved roles with PostgreSQL Hooks thumbnail

    2 Jul 2021

    •

    14 minute read

    Protecting reserved roles with PostgreSQL Hooks

    Using Postgres Hooks to protect functionality in your Postgres database.

    Developers stay up to date with intheloop.dev thumbnail

    22 Mar 2021

    •

    3 minute read

    Developers stay up to date with intheloop.dev

    Learn why Kevin is building intheloop.dev with Supabase

    Using Supabase in Replit thumbnail

    11 Mar 2021

    •

    4 minute read

    Using Supabase in Replit

    Free hosted relational database from within your node.js repl

    Postgres as a CRON Server thumbnail

    5 Mar 2021

    •

    8 minute read

    Postgres as a CRON Server

    Running repetitive tasks with your Postgres database.

    Cracking PostgreSQL Interview Questions thumbnail

    27 Feb 2021

    •

    7 minute read

    Cracking PostgreSQL Interview Questions

    Understand the top PostgreSQL Interview Questions

    Postgres Views thumbnail

    18 Nov 2020

    •

    7 minute read

    Postgres Views

    Creating and using a view in PostgreSQL.

    Continuous PostgreSQL Backups using WAL-G thumbnail

    2 Aug 2020

    •

    6 minute read

    Continuous PostgreSQL Backups using WAL-G

    Have you ever wanted to restore your database's state to a particular moment in time? This post explains how, using WAL-G.

    What are PostgreSQL Templates? thumbnail

    9 Jul 2020

    •

    4 minute read

    What are PostgreSQL Templates?

    What are PostgreSQL templates and what are they used for?

    Physical vs Logical Backups in PostgreSQL thumbnail

    7 Jul 2020

    •

    5 minute read

    Physical vs Logical Backups in PostgreSQL

    What are physical and logical backups in Postgres?

Footer

We protect your data.More on Security
  • SOC2 Type 2 Certified
  • HIPAA Compliant
Supabase LogoSupabase Logo
Twitter
GitHub
Discord
Youtube
Product
  • Database
  • Auth
  • Functions
  • Realtime
  • Storage
  • Vector
  • Cron
  • Pricing
  • Launch Week
Solutions
  • AI Builders
  • No Code
  • Beginners
  • Developers
  • Postgres Devs
  • Hackathon Contestants
  • Startups
  • Enterprise
  • Innovation Teams
Resources
  • Blog
  • Support
  • System Status
  • Become a Partner
  • Integrations
  • Brand Assets
  • Security & Compliance
  • DPA
  • SOC2
  • HIPAA
Developers
  • Documentation
  • Supabase UI
  • Changelog
  • Careers
  • Contributing
  • Open Source
  • SupaSquad
  • DevTo
  • RSS
Company
  • Company
  • General Availability
  • Terms of Service
  • Privacy Policy
  • Acceptable Use Policy
  • Support Policy
  • Service Level Agreement
  • Humans.txt
  • Lawyers.txt
  • Security.txt
© Supabase Inc