93 subscribers
התחל במצב לא מקוון עם האפליקציה Player FM !
פודקאסטים ששווה להאזין
בחסות


Postgres vs SQLite with Litestream
Manage episode 332965715 series 2930339
Ben Johnson, the creator of Litestream, joined Fly.io a few weeks after we migrated changelog.com - episode 50 has all the details. That was pure coincidence. What was not a coincidence, is Gerhard jumping at the opportunity to talk to Ben about Postgres vs SQLite with Litestream.
The prospect of running a cluster of our app instances spread across all regions, with local SQLite & Litestream replication, is mind boggling. Let’s find out from Ben what will it take to get there. Thanks Kürt for kicking off this dream.
Changelog++ members save 6 minutes on this episode because they made the ads disappear. Join today!
Sponsors:
- Sentry – Working code means happy customers. That’s exactly why teams choose Sentry. From error tracking to performance monitoring, Sentry helps teams see what actually matters, resolve problems quicker, and learn continuously about their applications - from the frontend to the backend. Use the code
SHIPIT
and get the team plan free for three months. - FireHydrant – The reliability platform for every developer. Incidents impact everyone, not just SREs. FireHydrant gives teams the tools to maintain service catalogs, respond to incidents, communicate through status pages, and learn with retrospectives. Small teams up to 10 people can get started for free with all FireHydrant features included. No credit card required to sign up. Learn more at firehydrant.io
- Sourcegraph – Transform your code into a queryable database to create customizable visual dashboards in seconds. Sourcegraph recently launched Code Insights — now you can track what really matters to you and your team in your codebase. See how other teams are using this awesome feature at about.sourcegraph.com/code-insights
- Akuity – Akuity is a new platform (founded by Argo co-creators) that brings fully-managed Argo CD and enterprise services to the cloud or on premise. They’re inviting our listeners to join the closed beta at akuity.io/changelog. The platform is a versatile Kubernetes operator for handling cluster deployments the GitOps way. Deploy your apps instantly and monitor their state — get minimum overhead, maximum impact, and enterprise readiness from day one.
Featuring:
Show Notes:
🆕 FOLLOW-UP: Live read replicas update in GitHub issue comment
- How this episode started
- I’m All-In on Server-Side SQLite
- Getting Started with Litestream
- github.com/benbjohnson/litestream
- litestream.io repository
- The Secret Lives of Data - Raft
- 🎧 Replicating SQLite using Litestream with Ben Johnson - ThinkingElixir #101 - May, 2022
- 🎧 Open source, not open contribution - Changelog #433 - March, 2021
- Datasette - An open source multi-tool for exploring and publishing data
- How Litestream Eliminated My Database Server for $0.03/month - April, 2021
- Picoshare - A minimalist, easy-to-host service for sharing images and other files
- Picoshare deploy to Fly.io
- Fly Machines: An API for Fast-booting VMs

Something missing or broken? PRs welcome!
136 פרקים
Manage episode 332965715 series 2930339
Ben Johnson, the creator of Litestream, joined Fly.io a few weeks after we migrated changelog.com - episode 50 has all the details. That was pure coincidence. What was not a coincidence, is Gerhard jumping at the opportunity to talk to Ben about Postgres vs SQLite with Litestream.
The prospect of running a cluster of our app instances spread across all regions, with local SQLite & Litestream replication, is mind boggling. Let’s find out from Ben what will it take to get there. Thanks Kürt for kicking off this dream.
Changelog++ members save 6 minutes on this episode because they made the ads disappear. Join today!
Sponsors:
- Sentry – Working code means happy customers. That’s exactly why teams choose Sentry. From error tracking to performance monitoring, Sentry helps teams see what actually matters, resolve problems quicker, and learn continuously about their applications - from the frontend to the backend. Use the code
SHIPIT
and get the team plan free for three months. - FireHydrant – The reliability platform for every developer. Incidents impact everyone, not just SREs. FireHydrant gives teams the tools to maintain service catalogs, respond to incidents, communicate through status pages, and learn with retrospectives. Small teams up to 10 people can get started for free with all FireHydrant features included. No credit card required to sign up. Learn more at firehydrant.io
- Sourcegraph – Transform your code into a queryable database to create customizable visual dashboards in seconds. Sourcegraph recently launched Code Insights — now you can track what really matters to you and your team in your codebase. See how other teams are using this awesome feature at about.sourcegraph.com/code-insights
- Akuity – Akuity is a new platform (founded by Argo co-creators) that brings fully-managed Argo CD and enterprise services to the cloud or on premise. They’re inviting our listeners to join the closed beta at akuity.io/changelog. The platform is a versatile Kubernetes operator for handling cluster deployments the GitOps way. Deploy your apps instantly and monitor their state — get minimum overhead, maximum impact, and enterprise readiness from day one.
Featuring:
Show Notes:
🆕 FOLLOW-UP: Live read replicas update in GitHub issue comment
- How this episode started
- I’m All-In on Server-Side SQLite
- Getting Started with Litestream
- github.com/benbjohnson/litestream
- litestream.io repository
- The Secret Lives of Data - Raft
- 🎧 Replicating SQLite using Litestream with Ben Johnson - ThinkingElixir #101 - May, 2022
- 🎧 Open source, not open contribution - Changelog #433 - March, 2021
- Datasette - An open source multi-tool for exploring and publishing data
- How Litestream Eliminated My Database Server for $0.03/month - April, 2021
- Picoshare - A minimalist, easy-to-host service for sharing images and other files
- Picoshare deploy to Fly.io
- Fly Machines: An API for Fast-booting VMs

Something missing or broken? PRs welcome!
136 פרקים
כל הפרקים
×




1 Abstractions and implementations 53:14




1 Your customer is Amazon.com 1:15:21

1 Kubernetes is an anti-platform 1:35:42

1 TIME to get SERIESous about databases 53:46


1 A learning mindset, starting with COBOL 1:16:55



1 Learning & teaching networking & AI 1:19:34



1 Cloud-centric security logging 1:03:54


1 5000 Walmart stores in 2 months 1:15:40




1 What happened to open source 1:11:58



1 The infrastructure behind a PaaS 1:18:41





1 How WebMD ran in the year 2000 1:26:23

1 Managing Meta's millions of machines 1:02:58

1 Let's go back to AOL chat rooms 1:12:34



1 Deploying projects vs products 1:13:47


1 Productivity engineering at Netflix 1:31:15


1 Scoring your project’s security 1:23:58

1 Hybrid infrastructure load balancing 1:06:28


1 Building containers without Docker 57:27

1 Kaizen! Embracing change 🌟 1:16:36

1 Rust efficiencies at AWS scale 1:03:31

1 Treat ideas like cattle, not pets 1:09:11

1 Why we switched to serverless containers 1:08:14


1 The hard parts of platform engineering 1:17:05

1 Bare metal meets Talos Linux (the K8s OS) 1:04:00

1 🎄 Planning for failure to ship faster 🎁 1:05:12


1 Let's deploy straight to production! 1:07:25

1 Kaizen! 24 improvements & a lot more 1:08:43

1 Developer Experience Infrastructure (DXI) 1:05:14

1 The system that runs Norway's welfare payments 🇳🇴 1:01:56


1 Container base images with glibc & musl 1:03:11
ברוכים הבאים אל Player FM!
Player FM סורק את האינטרנט עבור פודקאסטים באיכות גבוהה בשבילכם כדי שתהנו מהם כרגע. זה יישום הפודקאסט הטוב ביותר והוא עובד על אנדרואיד, iPhone ואינטרנט. הירשמו לסנכרון מנויים במכשירים שונים.