search

blogifierdotnet / Blogifier

Blogifier is an open-source publishing platform Written in ASP.NET and Blazor WebAssembly. With Blogifier make a personal blog or a website.
https://blogifier.net
MIT License
1.28k stars 518 forks source link

add migrations with multiple providers #233

Closed dorthl closed 3 years ago

dorthl commented 3 years ago

add migrations with multiple providers

rxtur commented 3 years ago

Hi dorthl, with database, we want to stay away from tight coupling to specific providers. We did this before and it resulted in having us to support and maintain code manually. Basically, any small change to the back-end would require to go an test every single provider by hand, which is very time consuming. Now to use none-standard (not SQLite) provider it would require to regenerate migrations as outlined here.

dorthl commented 3 years ago

Hi dorthl,

Hi dorthl, with database, we want to stay away from tight coupling to specific providers. We did this before and it resulted in having us to support and maintain code manually. Basically, any small change to the back-end would require to go an test every single provider by hand, which is very time consuming. Now to use none-standard (not SQLite) provider it would require to regenerate migrations as outlined here.

Hi rxtur,

My English is not very good, please forgive me I want to use this project to implement my own blog. After I tried to deploy the project code, I encountered the problem of database migration. The document has indeed stated that I must re-migrate by myself, but I think this is not in line with the current The deployment mode of the software. Yes, any subtle changes to the backend require manual testing of each provider, but I hope it can be clearly stated that other databases are not supported. I have tested the current code even if it is re-tested. There are still problems in generating migration in mysql. These problems are often difficult to find. Since ef core supports these providers, I hope to add some support for these databases in the code.