ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Cloud & infrastructure · #supabase
Supabase leverages PostgREST to translate API requests into SQL queries. When retrieving large datasets using the limit and offset parameters, the underlying PostgreSQL engine must scan and discard rows prior to returning the requested page. As the offset value increases, there is a potential for linear degradation in query performance, leading to increased
PostgreSQL Logical Replication and Storage Supabase Realtime leverages the supabase_realtime publication and logical replication slots to stream database changes to clients via WebSockets. This architecture relies on the PostgreSQL Write Ahead Log (WAL) to track and broadcast INSERT , UPDATE , and DELETE events. Resource Constraints In environments with high
Recursive Policy Evaluation Supabase leverages PostgreSQL Row Level Security (RLS) to enforce data access via auth.uid() . In schemas where a table contains a self-referencing foreign key—such as a categories table with a parent_id column—policies often need to check the permissions of the parent record to determine access to the child record. Constraint and