splinter
splinter copied to clipboard
supabase
Supabase Postgres Linter
Generated columns in Postgres are required to only use immutable functions, but this does not seem to be enforced at creation time. It can, however, cause the upgrade process to...
## What kind of change does this PR introduce? * adds a lint to check if there are any policies that allow access to anonymous users ## What is the...
RLS is not supported for foreign tables or materialized views Ideally they will not be in the search path. Remediation would be to move them to a private schema and...
A common failure mode of restores or other similar workflows is for a database to contain check constraints that are not immutable. This is not supported by Postgres, but not...
pg_upgrade does not support upgrading of databases containing table columns using these reg* OID-referencing system data types: - regcollation - regconfig - regdictionary - regnamespace - regoper - regoperator -...
# Bug report Any thoughts on how we could scan for problematic data types without a high false positive rate would be welcome
There are cases where users will create RLS policies in the `storage`, 'auth` and `realtime` schemas. Currently we exclude those schemas from all lints but we likely need to relax...
The latest version of the supabase CLI inserts migration statements into the database as text[] This lint would iterate through tables/functions/views and check to see if they are (at least)...
## Problem A user was complaining about `supabase-js`/PostgREST failing to detect new table changes. The root cause was the user somehow wiped the functions + event triggers (maybe Prisma or...
# Improve documentation ## Link https://supabase.com/docs/guides/database/database-advisors?lint=0013_rls_disabled_in_public ## Describe the problem The doc says > If row level security (RLS) is not enabled on a public table, anyone with the project's...
