Supabase LogoSupabase Logo
  • Pricing

  • Docs

  • Blog

88.8KSign inStart your project

Blog/Planetpg

    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

    What's new in pgvector v0.7.0 thumbnail

    2 May 2024

    •

    8 minute read

    What's new in pgvector v0.7.0

    Exploring new features in pgvector v0.7.0

    Postgres Bloat Minimization thumbnail

    26 Apr 2024

    •

    7 minute read

    Postgres Bloat Minimization

    Understanding and minimizing Postgres table bloat

    Postgres Roles and Privileges thumbnail

    11 Apr 2024

    •

    43 minute read

    Postgres Roles and Privileges

    A guide to Postgres roles and privileges

    How pg_graphql works thumbnail

    24 Jan 2024

    •

    14 minute read

    How pg_graphql works

    An insight into the internals of GraphQL in Postgres using pg_graphql, and how you can contribute.

    Elixir clustering using Postgres thumbnail

    9 Jan 2024

    •

    6 minute read

    Elixir clustering using Postgres

    Learn about our approach to connecting multiple nodes in Elixir using Postgres

    Supabase Wrappers v0.2: Query Pushdown & Remote Subqueries thumbnail

    14 Dec 2023

    •

    6 minute read

    Supabase Wrappers v0.2: Query Pushdown & Remote Subqueries

    Supabase Wrappers v0.2 brings more Wrappers, query pushdown, remote subquery, and more

    PostgREST 12 thumbnail

    13 Dec 2023

    •

    4 minute read

    PostgREST 12

    PostgREST 12 is out and we take a look at some of the major new features like JWT Caching and Aggregate Functions

    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

    pg_graphql: Postgres functions now supported thumbnail

    12 Dec 2023

    •

    7 minute read

    pg_graphql: Postgres functions now supported

    pg_graphql now supports the most requested feature: Postgres functions a.k.a. User Defined Functions (UDFs)

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

    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.

    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

    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

    pg_jsonschema: JSON Schema support for Postgres thumbnail

    19 Aug 2022

    •

    6 minute read

    pg_jsonschema: JSON Schema support for Postgres

    Today we're releasing pg_jsonschema, a Postgres extension for JSON validation.

    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.

    Partial data dumps using Postgres Row Level Security thumbnail

    28 Jun 2022

    •

    6 minute read

    Partial data dumps using Postgres Row Level Security

    Using RLS to create seed files for local PostgreSQL testing.

    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.

    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