Mike Buckbee, co-founder of Wafris and an expert in cybersecurity, discusses his transition from Redis to SQLite for web application firewalls. He shares challenges faced in managing security and architecture, emphasizing the enhanced performance and usability gained through SQLite. The conversation highlights SQL's advantages over JSON, addressing operational challenges and how Wafris effectively handles IP data. Buckbee also reflects on Wafris' dual architecture, operational efficiencies, and the importance of community engagement in cybersecurity.
Mike Buckbee discusses Wafris' mission to make advanced cybersecurity tools accessible for developers and startups, democratizing security solutions.
The transition from Redis to SQLite significantly simplified the installation process and operational overhead, enhancing user adoption and effectiveness.
SQLite's performance improvements, especially in read operations, outpace Redis, resulting in faster access times and increased reliability for Wafris.
Deep dives
Introduction to Wafris and Its Mission
Wafris is an open-source client web application firewall designed to enhance cybersecurity for web applications. It was founded by Mike Buckby, with a focus on addressing the significant imbalance between the ease with which attackers can exploit vulnerabilities and the challenges developers face in defending against such attacks. By aiming to make sophisticated security tools accessible to a broader range of users, including smaller startups, Wafris seeks to eliminate the barriers that often come with traditional enterprise-level web application firewalls. The initiative reflects a commitment to democratizing cybersecurity and providing effective defenses against common threats.
The Transition from Redis to SQLite
Wafris originally relied on Redis for its data storage but faced challenges related to complexity and user setup. Users often struggled to manage and set up Redis properly, leading to operational roadblocks in adopting the firewall effectively. To overcome these challenges, Wafris transitioned to SQLite, which simplifies the installation process and reduces the overhead associated with managing a dedicated Redis instance. This shift not only improved ease of use but also addressed broader issues related to distributed deployments across multiple regions.
Operational Enhancements with SQLite
The adoption of SQLite allowed Wafris to implement a more streamlined synchronization model, enhancing operational efficiency. SQLite's read-only functionality enables clients to download the latest database containing security rules seamlessly, facilitating quick updates and reducing management burdens. The fact that SQLite databases can be easily updated in the background while still serving requests minimizes disruptions during security rule updates. This ‘upsync’ and ‘downsync’ mechanism contributes to a smoother user experience, making Wafris more accessible for developers across diverse environments.
Performance Improvements Following Architectural Changes
The transition to SQLite yielded significant performance improvements, with benchmarks indicating that SQLite outperforms Redis by threefold during read operations. The reasons for this improvement include the elimination of network overhead associated with Redis, as SQLite operates directly on local file systems, providing faster access times. Additionally, because SQLite is inherently simple to manage and deploy, it reduces the complexity of interactions that typically slow down other systems like Redis. As a result, Wafris not only becomes faster but also more reliable in handling a high volume of requests.
Customization and Community Engagement
Wafris fosters community involvement through its freemium model, allowing users to set up custom rules and contribute to the open-source project. This approach not only empowers users to tailor their security configurations to meet specific needs but also encourages feedback and collaboration within the developer community. By distributing multiple SQLite databases and allowing users to implement their custom configurations, Wafris assures flexibility in deployment and management. This community-centric ethos aims to establish Wafris as a standard tool that can be readily adopted by developers facing today’s cybersecurity challenges.
Want to learn more SQLite? Check out my SQLite course: https://highperformancesqlite.com In this episode, I sit down with Mike Buckbee to dive into the nitty-gritty of web application firewalls and his journey from using Redis to SQLite in Wafris. We talk about database architecture, operational challenges, and the fascinating ways SQLite improves performance and usability in cybersecurity tools. Get production ready SQLite with Turso: https://tur.so/af. Follow Mike: Twitter: https://twitter.com/mbuckbee LinkedIn: https://www.linkedin.com/in/michaelbuckbee Wafris website: https://wafris.org Rearchitecting Redis to SQLite article: https://wafris.org/blog/rearchitecting-for-sqlite Follow Aaron: Twitter: https://twitter.com/aarondfrancis LinkedIn: https://www.linkedin.com/in/aarondfrancis Website: https://aaronfrancis.com - find articles, podcasts, courses, and more. Chapters: 00:00 - Introduction and Guest Overview 01:06 - What is Wafris? 02:43 - Naming and Origins of Wafris 04:00 - Mike's Cybersecurity Background 07:17 - Challenges with Web Application Firewalls 10:01 - Wafris Architecture Overview 16:15 - Why Switch to SQLite? 18:01 - Handling IP Address Ranges 24:00 - Wild Redis Data Structures Explained 28:51 - Transitioning to SQLite 32:02 - Operational Advantages of SQLite 37:04 - How Wafris Leverages Threat Lists 40:13 - Performance Gains with SQLite 46:51 - Splitting Reads and Writes in the New Architecture 52:29 - Closing Thoughts and Where to Learn More
Get the Snipd podcast app
Unlock the knowledge in podcasts with the podcast player of the future.
AI-powered podcast player
Listen to all your favourite podcasts with AI-powered features
Discover highlights
Listen to the best highlights from the podcasts you love and dive into the full episode
Save any moment
Hear something you like? Tap your headphones to save it with AI-generated key takeaways
Share & Export
Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more
AI-powered podcast player
Listen to all your favourite podcasts with AI-powered features
Discover highlights
Listen to the best highlights from the podcasts you love and dive into the full episode