Dataabase cache driver

[binaryfire]

Content

Hi @albertcht. I know you've mentioned in the docs that:

Hypervel does not support the database cache driver at this time. We don't encourage using database as a cache driver either because of the poor performance.

However one place where a db cache driver is essential is for apps deployed to IOT devices, and for all-in-one Docker images. These types of apps are usually built with SQLite because including additional services like Redis isn't always possible.

Regarding the performance of SQLite - with the right optimizations it can hit insanely high levels of performance. Around 80,000 inserts / second:

https://www.powersync.com/blog/sqlite-optimizations-for-ultra-high-performance
https://news.ycombinator.com/item?id=35547819
https://phiresky.github.io/blog/2020/sqlite-performance-tuning/

Which makes it perfect for caching when Redis isn’t an option. It’s much faster than the file driver.

I'd like to PR a database cache driver. Will that be ok with you?

[albertcht]

Hi @binaryfire , thanks for asking, a PR for database driver is welcome!