{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Database School","title":"Moving from Redis to SQLite with Mike Buckbee","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/aa1a7338\"></iframe>","width":"100%","height":180,"duration":4154,"description":"Want to learn more SQLite? Check out my SQLite course: https://highperformancesqlite.com \nIn 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. \nGet production ready SQLite with Turso: https://tur.so/af. \nFollow Mike: \nTwitter: https://twitter.com/mbuckbee \nLinkedIn: https://www.linkedin.com/in/michaelbuckbee \nWafris website: https://wafris.org \nRearchitecting Redis to SQLite article: https://wafris.org/blog/rearchitecting-for-sqlite \nFollow Aaron: \nTwitter: https://twitter.com/aarondfrancis \nLinkedIn: https://www.linkedin.com/in/aarondfrancis \nWebsite: https://aaronfrancis.com - find articles, podcasts, courses, and more.\nDatabase school on YouTube: https://www.youtube.com/playlist?list=PLI72dgeNJtzqElnNB6sQoAn2R-F3Vqm15\nDatabase school audio only: https://databaseschool.transistor.fm  \nChapters: 00:00 - Introduction and Guest Overview\n01:06 - What is Wafris?\n02:43 - Naming and Origins of Wafris\n04:00 - Mike's Cybersecurity Background\n07:17 - Challenges with Web Application Firewalls\n10:01 - Wafris Architecture Overview\n16:15 - Why Switch to SQLite?\n18:01 - Handling IP Address Ranges\n24:00 - Wild Redis Data Structures Explained\n28:51 - Transitioning to SQLite\n32:02 - Operational Advantages of SQLite\n37:04 - How Wafris Leverages Threat Lists\n40:13 - Performance Gains with SQLite\n46:51 - Splitting Reads and Writes in the New Architecture\n52:29 - Closing Thoughts and Where to Learn More","thumbnail_url":"https://img.transistorcdn.com/QPpKhRBWtM56k1sC7Y7j7aqGy8sd-XKWw6mEKgA1jmw/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9lMmRl/ZTM5ZTAxOTMzNTgy/MmJmZTA4MWE1ZjMw/YjE4Ny5wbmc.webp","thumbnail_width":300,"thumbnail_height":300}