Database School Moving from Redis to SQLite with Mike Buckbee
13 snips
Nov 26, 2024 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.
AI Snips
Chapters
Transcript
Episode notes
Unexpected Traffic Origin
- Mike Buckbee shared an anecdote about a company with internal HR software.
- Despite only operating in the US, most of their website traffic originated from China.
Wafris's Role
- Wafris sits between every request and the application, making it a critical component.
- It checks if an IP address should be blocked and manages complex rule sets.
Homegrown IP Management
- Mike encountered a client with a homegrown system containing three-quarters of a million IP addresses in a simple list.
- This highlighted the need for a better IP management solution.