My tips, start a project with an NoSQL store, and when you are certain about your schema, consider traditional SQL.
It’s so comfortable to iterate quickly without schema constraints
It’s so comfortable to iterate quickly without schema constraints
I tend to nuke my entire db, recreate it and reload some data into it. I wish there was a tool that ran in watch mode and patched the db based schema edits.
I'd be very careful about this simplistic reasoning. The whole point of schemas is data validation, and the hard part of "iterating quickly" is migrating data in a way you ensure it remains valid.
Neither of these requirements are tied to relational databases.
At most, breaking a schema ensures you cannot proceed with broken data without undergoing a migration, or completely wiping your database. But you are already doing that, aren't you?