Backend Banter #020 - Running SQLite on the Edge with Pekka Enberg
Sep 25, 2023
Pekka Enberg, CTO of TursoDB, talks about running SQLite on the edge and discusses the benefits of using SQLite as an embedded database. They explore the challenges of distributing a centralized database worldwide and improving performance with AWS Lambda. They also touch on using Postgres and Elasticsearch for transactional data and analytics, and discuss write guarantees and data consistency in databases.
Chapters
Transcript
Episode notes
1 2 3 4 5 6 7 8
Introduction
00:00 • 2min
Bringing Data Close to Code
02:11 • 16min
Using SQLite as an Embedded Database
17:54 • 10min
Distributing Backend Code and Database
28:15 • 9min
Tail Latency and Improving Performance with AWS Lambda
37:26 • 22min
Postgres and Elasticsearch for Transactional Data and Analytics
59:16 • 8min
Discussion on Write Guarantees and Write Delegation in Databases
01:07:36 • 2min
Data Consistency and Database Management
01:09:23 • 5min