Our great sponsors
Postgres.js - The Fastest full featured PostgreSQL client for Node.js and Deno (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.
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.
Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.
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