Wafris, an open-source web application firewall company, has shifted from using Redis to SQLite as the backing datastore for their Rails client. This change was prompted by difficulties encountered by users with Redis deployment, especially under real-world application scenarios. The shift to SQLite demonstrated a significant performance boost, with SQLite being three times faster than Redis for Wafris’ specific use case. By rearchitecting their v2 client to utilize SQLite, Wafris has streamlined deployment and improved efficiency, resulting in increased successful installs. This transition reflects their commitment to creating a user-friendly and fast solution for site protection.
https://wafris.org/blog/rearchitecting-for-sqlite