In our team, we currently all develop on our local environment, with a local database, that regularly fetches data from the production database.
However, as our production database grows, it's becoming impossible to fetch data from it and store it on our work laptops.
What are the best solutions for development databases ? Do people use remote development databases (e.g one per developer so everyone can run migrations and make changes) ?
Any direction will be appreacitedd