Switch default state store to SQLite for local experience

[ItalyPaleAle]

Describe the proposal

Running dapr init sets up a default state store "statestore" that is based on Redis. Redis has some issues when used as actor state store, so we should start by migrating the default state store used in the local experience to SQLite.

Release Note

RELEASE NOTE: UPDATE Switch default state store to SQLite for local experience

[mukundansundar]

This requires a config file change.

[dapr-bot]

This issue has been automatically marked as stale because it has not had activity in the last 30 days. It will be closed in the next 7 days unless it is tagged (pinned, good first issue, help wanted or triaged/resolved) or other activity occurs. Thank you for your contributions.

[ItalyPaleAle]

Is there any update on this?

[mukundansundar]

As discussed in an endgame sync, moving this to next milestone for now.

[oleksandr-bilyk]

Yes please also update documentation how to do it withy VS2022 + docker-compose + .NET Steps to reproduce:

1. But happens when we register reminder and instead of using hit-once call we used call multiple times. E
2. After processing message with reminder data we unregister reminder.

Please fix all documentation because all customer who will start using reminders will have this issue. If SqlLight works well then you must provide template how to use SqlLight with S2022 + docker-compose + .NET because this is the set that official documentation uses https://learn.microsoft.com/en-us/dotnet/architecture/dapr-for-net-developers/getting-started