How to use Supabase RLS with third-party client library?

This page summarizes the projects mentioned and recommended in the original post on /r/Supabase

InfluxDB – Built for High-Performance Time Series Workloads
InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  1. postgres

    Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare (by porsager)

    I'm using Supabase as my database, with RLS turned on. I query the DB from a Node backend using the postgres.js client (it could be any other JS client really). As such I'm connecting direct with the default postgres user and I issue raw SQL queries.

  2. InfluxDB

    InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

    InfluxDB logo
  3. postgrest

    REST API for any Postgres database

    Yes that's exactly what I'm reading here and there. It seems to be the approach that Supabase is taking itself when receiving queries via their API gateway, powered by PostgREST. I had a look at the source code for the latter and it's basically converting the claims in the received JWT into as many local set_config() calls (basically a wrapper function around SET LOCAL). See this related discussion.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • Prisma + ZenStack: An Alternative to PostgREST

    2 projects | dev.to | 24 Apr 2023
  • Querying SQL from React without a backend (bear with me here)

    5 projects | /r/reactjs | 27 Jun 2022
  • Are ORMs considered an anti-pattern in Go?

    7 projects | /r/golang | 24 Feb 2022
  • Supabase versus Magic - You win!

    5 projects | dev.to | 7 Jul 2024
  • Business Logic Inside Database - How Evil Is It?

    3 projects | dev.to | 17 Apr 2023

Did you know that Haskell is
the 25th most popular programming language
based on number of references?