Database suggestions about near-indexer-for-explorer HOT 2 CLOSED

Hey there!

provide a public backup of the database so that it can be restored and the whole chain won't have to be reindexed (maybe in s3 similar to how near lake data is made publicly available).

I am sorry but we have no plans to provide publicly available postgres backups because of the size of the database. At least in the nearest future.

add auto-incrementing ids to all tables or provide updated/inserted timestamps to all tables
add indexes to such columns

I would ask @telezhnaya and @pkudinov to answer here

from near-indexer-for-explorer.

Hey @juls858 !
The blockchain nature allows us to use natural PKs for most of the tables. As the bonus, Postgres keeps the consistent state, ignores duplicates, etc.
This is a crucial feature for us.

If you want such columns, I'm afraid we can only suggest you to fork the implementation and add the columns you may find useful.
Keep in mind that you need to avoid duplicates somehow.
Also, keep in mind that Snowflake does not support big integers which are required for storing amount values.

from near-indexer-for-explorer.