Moving from Redis to SQLite with Mike Buckbee
Database School26 Nov 2024

Moving from Redis to SQLite with Mike Buckbee

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.

Database school on YouTube: https://www.youtube.com/playlist?list=PLI72dgeNJtzqElnNB6sQoAn2R-F3Vqm15
Database school audio only: https://databaseschool.transistor.fm

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

Avsnitt(30)

Infinite, shareable volume storage with Hunter Leath, Archil CEO

Infinite, shareable volume storage with Hunter Leath, Archil CEO

Hunter Leath, CEO of Archil, explains how they’re building a “universal storage engine” that sits between your apps and S3—making an S3 bucket behave like a fast, POSIX-compatible disk for containers,...

15 Jan 55min

Building search for AI systems with Chroma CTO Hammad Bashir

Building search for AI systems with Chroma CTO Hammad Bashir

Hammad Bashir, CTO of Chroma, joins the show to break down how modern vector search systems are actually built from local, embedded databases to massively distributed, object-storage-backed architectu...

18 Dec 20251h 6min

Scaling DuckDB in the cloud with MotherDuck CEO Jordan Tigani

Scaling DuckDB in the cloud with MotherDuck CEO Jordan Tigani

In this episode of Database School, Aaron Francis sits down with Jordan Tigani, co-founder and CEO of MotherDuck, to break down what DuckDB is, how MotherDuck hosts it in the cloud, and why analytics ...

11 Dec 20251h 5min

Just use Postgres with Denis Magda

Just use Postgres with Denis Magda

In this episode, Aaron talks with Dennis Magda, author of Just Use Postgres!, about the wide world of modern Postgres, from JSON and full-text search to generative AI, time-series storage, and even me...

4 Dec 20251h 7min

Strictly typed SQL with Contra CTO, Gajus Kuizinas

Strictly typed SQL with Contra CTO, Gajus Kuizinas

In this episode, Gajus Kuizinas, co-founder and CTO of Contra, joins Aaron to talk about building the engineering world you want to live in, from strict runtime-validated SQL with Slonik to creating h...

20 Nov 202559min

Building serverless vector search with Turbopuffer CEO, Simon Eskildsen

Building serverless vector search with Turbopuffer CEO, Simon Eskildsen

In this episode, Aaron Francis talks with Simon Eskildsen, co-founder and CEO of TurboPuffer, about building a high-performance search engine and database that runs entirely on object storage. They di...

13 Nov 20251h 6min

Building an S3 Competitor with Tigris CEO Ovais Tariq

Building an S3 Competitor with Tigris CEO Ovais Tariq

Aaron talks with Ovais Tariq, co-founder and CEO of Tigris Data and former Uber engineer who helped scale one of the world’s largest distributed systems. They discuss Uber’s hyperscale infrastructure,...

6 Nov 20251h 7min

Rewriting SQLite from prison with Preston Thorpe

Rewriting SQLite from prison with Preston Thorpe

In this episode of Database School, Aaron talks with Preston Thorpe, a senior engineer at Turso who is currently incarcerated, about his incredible journey from prison to rewriting SQLite in Rust. The...

30 Okt 20251h 18min

Populärt inom Utbildning

rss-bara-en-till-om-missbruk-medberoende-2
historiepodden-se
det-skaver
nu-blir-det-historia
alska-oss
sektledare
harrisons-dramatiska-historia
allt-du-velat-veta
johannes-hansen-podcast
rss-sjalsligt-avkladd
rss-viktmedicinpodden
not-fanny-anymore
rss-max-tant-med-max-villman
i-vantan-pa-katastrofen
sa-in-i-sjalen
roda-vita-rosen
rss-basta-livet
rikatillsammans-om-privatekonomi-rikedom-i-livet
rss-npf-podden
sex-pa-riktigt-med-marika-smith