4 ms·
I'll do one better. I suggest every developer learn how to replicate, backup and restore the very database they are excited about, from scratch at least once.
by subhobroto 6mo ago
I'll do one better.
I suggest every developer learn how to replicate, backup and restore the very database they are excited about, from scratch at least once. I propose this will teach them what takes to build a production ready system and gain some appreciation for other ways of managing state.
- gf000 6mo agoIf the app is not running, then `cp sqlite.db sqlite.db.BK`
- subhobroto 6mo agoThe if is doing a lot of heavy lifing there but with that out of the way you do make a strong case about "local first" apps. Nothing beats the simplicity of a simple `cp` but there are other tradeoffs to be made there. That's why I was encouraging people to make backups and restores of their DB because personally, it has made me appreciate why different designs exist and when to use them vs just slapping a DB connection to an RDS instance and calling it a day.