✨ Move storage to SQLite

AwesomeBlazor / AutoScrum

AutoScrum tells your clients/team members what are you doing with one click. It finds the PBIs you did yesterday and works out what are you doing today. It supports Azure DevOps and GitHub projects and issues (coming soon). The consultants at SSW use it everyday and the best thing is that it force every team member to keep the backlog up-to-date. https://www.ssw.com.au/rules/methodology-daily-scrums

https://autoscrum.jkdev.me/

16 stars 5 forks source link

✨ Move storage to SQLite #70

Open jernejk opened 2 years ago

jernejk commented 2 years ago

As per this Tweet, SQLite with EF Core might be possible in Blazor WASM .NET 6. https://twitter.com/bricelambs/status/1491134363945570305?s=20&t=AqGHx65g7ibZ8he_K93f1A

[x] Investigate
[ ] Spike
[ ] Upgrade
[ ] Simplify DB schema to support many integrations without DB change (JSON store for custom data instead of custom tables?)
[ ] Final migration script from JSON to SQLite

jernejk commented 2 years ago

Starting to work on this issue to simplify the infrastructure code for Blazor and later migrations.

jernejk commented 2 years ago

Here is the GitHub repo for integrating EF Core SQLite into Blazor WASM. https://github.com/JeremyLikness/SqliteWasmHelper

jernejk commented 11 months ago

EF Core 8 changes lots of things and will simplify things. Switching to .NET 8 + EF Core 8 and using the latest SQLite tech is recommended.