near / near-indexer-for-explorer

Watch NEAR network and store all the data from NEAR blockchain to PostgreSQL database
https://near-indexers.io/docs/projects/near-indexer-for-explorer
GNU General Public License v3.0
123 stars 56 forks source link

Hide tables to a separate schema #373

Closed telezhnaya closed 1 year ago

telezhnaya commented 1 year ago

I tried to restrict selecting from 2 tables (see the full story here). I came to the conclusion that managed Postgres does not allow this. That's why I created a deprecated schema, the users will not have access to it by default.

My plan is to move these tables to deprecated schema, hide them from all the users and see what happens. We will still write the data to that tables. If we break something important, we will grant access to the tables and consider how to fix it. After a month of silence, we can drop them completely.

More tech details on what's going on here:

I will also need to update the features_enabled branch. Waiting for your review first