INTEGRATIONS - SQLite
The SQLite integration provides several overrides to the built-in modules within Shiny.
For the most part, you won't see SQLite after you register it in your Shiny startup. You are simply swapping "engines" for the "under the hood" stuff.
Why Swap with SQLite
There are 3 main points to consider when swapping in SQLite
- If you are using SQLite Crypto - you will gain data protection across all of the different function points.
- Performance is not necessarily going to be better and in some cases will be worse.
- Data persistence will last across sessions where in-memory providers (cache) are used.
|Caching||Your cache values will survive across sessions if the values don't expire. You will sacrifice performance vs the in-memory provider though.|
|Storage||The benefit here is that you can use SQLite encryption to potentially protect values|
|Settings||Same benefits of potential encryption. However, if you are doing frequent (many changes in a second) writes to settings, you will lose performance|