Feature Request: SQLite storage

[felix920506]

The current storage implementation is a bunch of loose files on the filesystem.
Using SQLite can have the following benefits:

• improve robustness when multithreaded access is desired
• make the data easier to manage (as it will be a single file)
• potentially improve performance

[ValueRaider]

Don't waste time implementing this in your fork, it's not happening, I will explain later.

[ValueRaider]

improve robustness when multithreaded access is desired

Running multiple threads/processes on top of YFC can corrupt the cache, especially exchange schedules. Don't do it.

make the data easier to manage (as it will be a single file)

But this makes cache harder to manage - now you can delete individual tickers.

potentially improve performance

How? Each ticker being a separate folder naturally allows parallel fetching. But the parallelism has to be inside YFC https://github.com/ValueRaider/yfinance-cache/blob/main/yfinance_cache/yfc_multi.py