✨ Move storage to SQLite

Open jernejk opened this issue 4 years ago • 3 comments

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

Feb 09 '22 22:02 jernejk

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

Aug 07 '22 05:08 jernejk

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

Aug 10 '22 09:08 jernejk

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.

Sep 05 '23 03:09 jernejk