dalewebb

How does your system work?

Good job! Those quotes are insane! I've worked on a few projects where I've had to build this from scratch, I had no idea that a SaaS existed for it...

Shouldn't the migration task be separate from the application running the web server?

If you had this within an application running in a Kubernetes pod, then each instance will attempt to run the migration.

Additionally, the application will need a DB user credentials that is capable of powerful actions like dropping a table, so that the migrator is capable of doing that - this would be a potential security vulnerability.

The image wouldn't generate for me

Look! It's Asana!

There was a product listed on HN a while ago that tackled the problem with the solution you described. I can't remember what it's called though...

I've worked with companies where we have pre-sold products (before they fully exist). By producing prototypes to get initial buy-in and then running pilots (trials) to get them to put money down.

These were potential solutions to problems that they don't have the budget or time to solve themselves

I was wondering about this. I don't think people do beyond class diagrams and possibly something that resembles an activity diagram.

What provoked the question?

Probably around 4 hrs a day (or half a day). The other time is taken by code reviewing, video calls, spec writing & research