Wafris, an open-source web application firewall company, migrated its Rails client from Redis to SQLite to alleviate deployment issues and improve performance. The switch was driven by challenges in managing Redis, especially in cloud environments, and the advantages of SQLite's simplicity and reduced network latency. Performance tests showed a significant speed improvement with SQLite for specific use cases. The rearchitected client aims to make it easier for developers to deploy and manage web application security.
Table of contents
BackgroundTL;DRWhat forced this change?What is Speed?Monolith-ish AssumptionsForcing a rethink of our architectureEnter SQLiteWhat's good about SQLite for Wafris?Benchmarking SQLite and RedisThe Testing ProtocolTesting ResultsWhat's missing from the chart?Results are just the startBuilding a sync architectureSQLite Distributed ArchitectureBut what about writes?Conclusion3 Comments
Sort: