DEV Community

loading...

Discussion on: How do you plan your database in development, before migrating to production?

Collapse
ajeebkp23 profile image
Ajeeb.K.P • Edited
  1. I install Mysql/Postgres/MongoDB locally using apt/flatpak/snap. And I use systemctl enable/disable/start/stop if not using any service/ not required.
  2. Keep backup of data with tools like mysqldump/pg_dump. Roll back is done by ORM's migrations (I use Django and Laravel by the way, both support rollbacks)
  3. I migrate with ORM.

My scenarios mostly include users under 1000 in numbers. Of which daily users may be under 100. Of course, I may need to change if more number of users are active.