Postgres vs SQLite with Litestream
source link: https://changelog.com/shipit/59
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Brought to you by
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.
- 73 minutes
- Recorded Jun 10, 2022
- Published Jun 29, 2022
- Download (71MB)
- Transcript
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.
Transcript
Recommend
-
29
Litestream
-
6
Why I Built LitestreamPosted February 10, 2021 by Ben Johnson ‐ 6 min readtl;dr—Despite an exponential increase in computing power,...
-
5
How Litestream Eliminated My Database Server for $0.03/month Here’s a riddle. My web app keeps all of its data in a SQL database. I can spontaneously tear it down, deploy the code to a di...
-
11
MySQL 与 Postgres 和 SQLite 的对比和优缺点发布于 2020年08月31日 ｜ 上次编辑：2020年09月01日 本文比较和对比了三个最广泛使用的开源 RDBMS：SQLite、MySQL 和 PostgreSQL。具体地说，我们会探讨每个 RDBMS 使用...
-
6
Postlite Postlite is a network proxy to allow access to remote SQLite databases over the Postgres wire protocol. This allows GUI tools to be used on remote SQLite databases which can make administration easier. The proxy work...
-
6
Sample config/database.yml from Rails. Postgres, MySQL, and SQLite · GitHub Instantly share code, notes, and snippets. ...
-
6
@junglesvenJungle SvenAlgorithmic trading in PythonCredibilityWhat’s the best w...
-
5
I Migrated from a Postgres Cluster to Distributed SQLite with LiteFSNovember 21st, 2022 — 22 min read
-
9
-
4
SQLedge [State: alpha] SQLedge uses Postgres logical replication to stream the changes in a source Postgres database to a SQLite database that can run on the edge. SQLedge serves reads from its local SQLite database, and forwards w...
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK