Docs for Redis transactions limitations

[hhunter-ms]

• Update the docs to make it clear that Redis shouldn’t be used as transactional state store
• Update docs/screenshots, etc when this issue merges: Switch default state store to SQLite for local experience cli#1328

[yaron2]

@hhunter-ms we should definitely not document that Redis shouldn't be used as a state store. On the contrary, it's one of the most stable, tested and widely used state stores. What needs to be documented is that it's not a fit for transactions unless you can accept the limitations imposed by Redis transactions (documented here https://redis.io/docs/interact/transactions/#what-about-rollbacks).

In the future we might deprecate the transactions capability on Redis but that decision hasn't been made yet.

[hhunter-ms]

@hhunter-ms we should definitely not document that Redis shouldn't be used as a state store. On the contrary, it's one of the most stable, tested and widely used state stores. What needs to be documented is that it's not a fit for transactions unless you can accept the limitations imposed by Redis transactions (documented here https://redis.io/docs/interact/transactions/#what-about-rollbacks).

ah thanks for the clarification - I overheard this in the sync earlier but didn't totally catch the context