transaction_hash
or a specific column, Postgres is a very safe choice to start with. It’s great as a backend for live data APIs.
However, it can be slow for analytics queries with a lot of aggregations. For that, you may want to look for an analytical database.
Great hosted solutions for Postgres include NeonDB, AWS Aurora, and GCP CloudSQL.