search

TheExGenesis / community-archive

An open tweet database and API anyone can build on.
https://www.community-archive.org
MIT License
55 stars 8 forks source link

RLS slows down long queries #140

Closed TheExGenesis closed 1 month ago

TheExGenesis commented 1 month ago

I've been getting around it by defining search functions as security definer, and filtering content from private users afterwards

TheExGenesis commented 1 month ago

I'm removing the option to have your archive be private for now - it'll come back once we're ready to implement granular permissions