Moving from Redis to SQLite with Mike Buckbee
Database School26 Marras 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

Jaksot(30)

How Durable Objects and D1 Work: A Deep Dive with Cloudflare’s Josh Howard

How Durable Objects and D1 Work: A Deep Dive with Cloudflare’s Josh Howard

Josh Howard, Senior Engineering Manager at Cloudflare, joins me to explain how Durable Objects and D1 work under the hood—and why Cloudflare’s approach to stateful serverless infrastructure is so uniq...

14 Touko 20251h 14min

20 years of hacking Postgres with Heikki Linnakangas (cofounder of Neon)

20 years of hacking Postgres with Heikki Linnakangas (cofounder of Neon)

In this episode of Database School, I talk with Heikki Linnakangas, co-founder of Neon and longtime PostgreSQL hacker, to talk about 20+ years in the Postgres community, the architecture behind Neon, ...

6 Touko 20252h

Building a serverless database replica with Carl Sverre

Building a serverless database replica with Carl Sverre

Want to learn more SQLite? Check out my SQLite course: https://highperformancesqlite.com In this episode, Carl Sverre and I discuss why syncing everything is a bad idea and how his new project, Graft,...

18 Huhti 20251h 28min

Postgres on bare metal with the CEO of Prisma

Postgres on bare metal with the CEO of Prisma

Prisma started as a GraphQL backend and pivoted into one of the most widely used ORMs in the world. Now, they’ve launched Prisma Postgres, and CEO Søren Bramer Schmidt is here to break down the journe...

17 Helmi 20251h 24min

Bootstrapping an email service provider (with Jesse Hanley)

Bootstrapping an email service provider (with Jesse Hanley)

Want to learn more Postgres? Check out my Postgres course: https://masteringpostgres.com. In this interview, I talk with Jesse Hanley, founder of Bento, about running a lean email service from Japan. ...

14 Loka 20241h 21min

Creating a Postgres platform with Monica & Tudor from Xata.io

Creating a Postgres platform with Monica & Tudor from Xata.io

Want to learn more Postgres? Check out my Postgres course: https://masteringpostgres.com. Production ready Postgres for teams that ship fast: https://xata.io In this interview, I talk with Monica Sarb...

7 Loka 20241h 1min

Heroku's glory days & Postgres vs the world, w/ Craig Kerstiens

Heroku's glory days & Postgres vs the world, w/ Craig Kerstiens

Want to learn more Postgres? Check out my Postgres course: https://masteringpostgres.com. In this interview, I dive deep with Craig Kerstiens from Crunchy Data into the world of Postgres, covering its...

24 Syys 20241h 2min

Suosittua kategoriassa Koulutus

rss-murhan-anatomia
psykopodiaa-podcast
voi-hyvin-meditaatiot-2
rss-narsisti
adhd-podi
rss-liian-kuuma-peruna
rss-valo-minussa-2
rss-duodecim-lehti
aamukahvilla
jari-sarasvuo-podcast
psykologia
salainen-paivakirja
leveli
rss-uskonto-on-tylsaa
rss-luonnollinen-synnytys-podcast
rss-tietoinen-yhteys-podcast-2
rss-koira-haudattuna
rss-arkea-ja-aurinkoa-podcast-espanjasta
ihminen-tavattavissa-tommy-hellsten-instituutti
rss-hereilla