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 - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  • 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.

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

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
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
  • Business Logic Inside Database - How Evil Is It?

    3 projects | dev.to | 17 Apr 2023
  • Architecture Pitfalls: Don’t use your ORM entities for everything — embrace the SQL!

    5 projects | /r/programming | 12 Jan 2023