Hacker News Reader

You can use FluentMigrator package for database migration. We have used it and it is pretty solid.

https://github.com/fluentmigrator/fluentmigrator/issues

I am curious about your encrytion scenario and why did .Net core fall short.

Thanks for the tip, does FluentMigrator require me to duplicate the table structure in it's DSL or does it have a way to pick up EF Core tables & detect changes?

Re encryption, I was looking for a way to do automatic TLS via https://letsencrypt.org/. Closest I could find was https://github.com/natemcmaster/LetsEncrypt which is archived.

Unfortunately it does not detect DSL changes automatically so yes you will have to copy changes.

What's the common use-case scenario for migration handling in the C# world? I've seen a lot of people doing checks on application startup: Do I have pending migrations? If so, run them. In the Ruby world, checking and running migrations is usually part of the deploy routine, not application startup, and are usually handled by a separate CLI command.

Reply on news.ycombinator.com