What's the most efficient way to add many records to the development database?

Hi,

I would like to add a few hundred records to a few tables in the development database. Here are a few options I can think of but wondering if there are other better ones.

Option 1: use the view/edit data function within Wappler. I believe I can’t copy paste a full table but rather have to edit cell by cell right?

Option 2: set up a CSV upload. I don’t need this feature for any user. It would just be for me. It seems a bit inefficient to build out this feature just for me.

Option 3: directly edit the databse within docker. Is this possible?

Option 4: host database somewhere else than within a docker (e.g. RDS) and use the database tool there to upload values.

Option 5: manually edit the migration file to have more “INSERT” statements and “rollback” to the edited version

On a related note, how should I set up the production version of this application? If I’m using AWS, would the best practice be:

1. host the docker following https://docs.wappler.io/t/setup-aws-hosting-with-docker/23867 and
2. then the database separately (not within the docker) on S3 following https://docs.wappler.io/t/setup-s3-on-aws/23618? how would I do it if I wanted to use RDS?

Thanks!