Flash-drive friendly DB support e.g. SQLite

[anthony]

Today, it's increasingly rare to find servers still using HDDs. MySQL was introduced a long time ago, at a time when computers were large and HDDs had limited capacity. Back then, it was an ideal solution for running an RDBMS on hosts with minimal memory and disk space. The frequent data writes by MySQL weren’t a concern. However, the situation has changed: now CPUs are much faster, RAM is abundant, but when it comes to storage, minimizing writes is key to extending the lifespan of flash drives and SSDs. As far as I see, SQLite, which is more suitable for SSDs and flash drives, isn't supported yet. So, what can be done to reduce disk writes and minimize wear on flash storage?

[yuri]

Hi,

The last time I looked into this topic, I came to conclusion that we don't need SQLite support. I don't think there's a benefit for our business to invest into SQLite support and then to maintain it.

Though, one may feel free to try to implement it as the framework allows it.