db: Litestream + SQLite vs Postgres

Postgres vs SQLite with Litestream featuring Ben Johnson from litestream.io (Ship It! #59) |> Changelog

Ben Johnson, the creator of Litestream, joined Fly.io
Ben Johnson – Twitter, GitHub, Website

benbjohnson/litestream: Streaming replication for SQLite. @GitHub (GoLang!)

Litestream is a standalone streaming replication tool for SQLite. It runs as a background process and safely replicates changes incrementally to another file or S3. Litestream only communicates with SQLite through the SQLite API so it will not corrupt your database.

links from this podcast:

• I’m All-In on Server-Side SQLite
• 
  
• Litestream is an open-source project that makes SQLite tenable for full-stack applications through the power of ✨replication✨. If you can set up a SQLite database, you can get Litestream working in less than 10 minutes.
• 
  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
  
  
  
  Fly.io (company) - EverybodyWiki Bios & Wiki
  
  
  Fly is an American company that provides hosting for software development using command line runtimes. The fly command line system is open-source and available publicly on it's Github repository licensed under the Apache License 2.0. It's main service is providing "Edge Applications" hosting otherwise known as a CDN. Fly also allows the ability to collaborate by inviting other users to Fly organisations.