Is it better to have a second database in this case?
I have bunch of tables for analytics, its comprehensice which might impact speed?
I'd like to use that data to have a marketplace on my normal website so people can see that data.
Am I overthinking or should I make a view replica?
1 Reply
Supabase has been working on a solution for handling analytical data because currently it is mainly transactional data that postgres is suited for. However, the solution is currently in private alpha https://supabase.com/docs/guides/storage/analytics/introduction but might end up being a better solution for you in the future. Given that you said it might impact speed i would probably suggest wait until it starts to impact speed